Column Type Size Nulls Auto Default Children Parents Comments
ID int4 10 null fk_accounts_contact N fk_addresses_contact C
contacts2contacts.contact1 fk_contacts2contacts_contact1 C
contacts2contacts.contact2 fk_contacts2contacts_contact2 C fk_davids_contact N fk_invitations_contact N fk_opportunities_contact N fk_participants_contact N fk_users_contact N

Contact ID

owneruser int4 10 null
users.ID fk_contacts_owneruser C

Owner user ID (PUBLIC if owneruser=null and ownergroup=null)

ownergroup int4 10 null
groups.ID fk_contacts_ownergroup C

Owner group ID (PUBLIC if owneruser=null and ownergroup=null)

creator int4 10 null
users.ID fk_contacts_creator N

Creator user ID (defaults to authenticated user on creation)

assigneduser int4 10 null
users.ID fk_contacts_assigneduser N

Assigned user ID

creationdate int8 19 date_part('epoch'::text, now())

Creation date and time as a Unix time stamp (defaults to current date and time on creation)

lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)

picbinfile int4 10 null
visibility int2 5 0


lastname text 2147483647 ''::text

Last name (surname or company name); is required if firstname is empty

firstname text 2147483647 ''::text

First name (given name); is required if lastname is empty

type int2 5 0

Contact type (0=COMPANY, 1=PERSON)

title text 2147483647 ''::text

Title or salutation (only for PERSON)

company text 2147483647 ''::text

Company name (only for PERSON)

position text 2147483647 ''::text

Position or job title (only for PERSON)

department text 2147483647 ''::text

Department (only for PERSON)

address text 2147483647 ''::text

Address (street and building/suite number)

postalcode text 2147483647 ''::text

Postal or ZIP code

city text 2147483647 ''::text

City or municipality

region text 2147483647 ''::text

Region or state

country varchar 2 ''::character varying

Country code (ISO 3166-1 alpha-2) (Pattern: ^([A-Z]{2})?$)

phone text 2147483647 ''::text

Primary phone number

phone2 text 2147483647 ''::text

Secondary phone number

cell text 2147483647 ''::text

Cell phone number

fax text 2147483647 ''::text

Fax number

email text 2147483647 ''::text

Primary e-mail address

email2 text 2147483647 ''::text

Secondary e-mail address

website text 2147483647 ''::text

Website URL

birthdate int8 19 null

Birth date as a Unix time stamp (only for PERSON)

description text 2147483647 ''::text

Detailed general description

Table contained 0 rows


Constraint Name Type Sort Column(s)
pk_contacts Primary key Asc ID
i_contacts_lastname_firstname_ID Performance Asc/Asc/Asc lastname + firstname + ID
i_contacts_noowner Performance Asc ownergroup
i_contacts_owner Performance Asc/Asc/Asc owneruser + ownergroup + assigneduser
s_contacts Performance Asc/Asc/Asc/Asc/Asc lastname + firstname + company + email + email2