contacts

Module: contacts

Contact records with personal, company, and address information.

Name	Type	Nullable	Default Value	Notes
PKID	integer			Contact ID
fork forks.ID	integer			Fork ID (`null` for base module)
owneruser users.ID	integer			Owner user ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`)
ownergroup groups.ID	integer			Owner group ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`)
creator	integer			Creator user ID (defaults to authenticated user on creation)
assigneduser users.ID	integer			Assigned user ID
creationdate	bigint		date_part('epoch', now())	Creation date and time as a Unix timestamp (defaults to current date and time on creation)
lastmodified	bigint		date_part('epoch', now())	Last modification date and time as a Unix timestamp (auto-reset on modification)
davserver davservers.ID	integer			DAV server ID
picbinfile binfiles.ID	integer			Binary file ID; is read-only (not for `PUT` or `PATCH`)
visibility	smallint		0	Visibility (`0`=REGULAR, `1`=ARCHIVED, `2`=DELETED)
lastname	text		''	Last name (surname or company name); is required if `firstname` is empty
firstname	text		''	First name (given name); is required if `lastname` is empty
type	smallint		0	Contact type (`0`=COMPANY, `1`=PERSON)
title	text		''	Title or salutation; only for PERSON
company	text		''	Company name; only for PERSON
position	text		''	Position or job title; only for PERSON
department	text		''	Department; only for PERSON
address	text		''	Address (street and building/suite number)
postalcode	text		''	Postal or ZIP code
city	text		''	City or locality
region	text		''	Region or state
country	character varying(2)		''	Country code (ISO 3166-1 alpha-2)
phone	text		''	Primary phone number
phone2	text		''	Secondary phone number
cell	text		''	Cell phone number
fax	text		''	Fax number
email	text		''	Primary e-mail address
email2	text		''	Secondary e-mail address
website	text		''	Website URL
birthdate	bigint			Birth date as a Unix timestamp; only for PERSON
description	text		''	Detailed general description

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_contacts_assigneduser					gin	assigneduser
fk_contacts_davserver					gin	davserver
fk_contacts_fork					gin	fork
fk_contacts_ownergroup					gin	ownergroup
fk_contacts_owneruser					gin	owneruser
fk_contacts_picbinfile					btree	picbinfile
i_contacts_lastname_firstname					btree	lastname, firstname
i_contacts_nofork					gin	fork
i_contacts_noowner					gin	ownergroup
pk_contacts					btree	ID
s_contacts_company					gin	company
s_contacts_email					gin	email
s_contacts_email2					gin	email2
s_contacts_firstname					gin	firstname
s_contacts_lastname					gin	lastname

Name	Type
c_contacts_name	check
c_contacts_owner	check
c_contacts_type	check
dc_contacts_address	check
dc_contacts_cell	check
dc_contacts_city	check
dc_contacts_company	check
dc_contacts_country	check
dc_contacts_department	check
dc_contacts_description	check
dc_contacts_email	check
dc_contacts_email2	check
dc_contacts_fax	check
dc_contacts_firstname	check
dc_contacts_lastname	check
dc_contacts_phone	check
dc_contacts_phone2	check
dc_contacts_position	check
dc_contacts_postalcode	check
dc_contacts_region	check
dc_contacts_title	check
dc_contacts_type	check
dc_contacts_visibility	check
dc_contacts_website	check
fk_contacts_assigneduser	foreign_key
fk_contacts_davserver	foreign_key
fk_contacts_fork	foreign_key
fk_contacts_ownergroup	foreign_key
fk_contacts_owneruser	foreign_key
fk_contacts_picbinfile	foreign_key
pk_contacts	primary_key

Loading...