contacts

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

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_creator	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...