contacts


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int4 10 √ null
accounts.contact fk_accounts_contact N
addresses.contact fk_addresses_contact C
contacts2contacts.contact1 fk_contacts2contacts_contact1 C
contacts2contacts.contact2 fk_contacts2contacts_contact2 C
davids.contact fk_davids_contact N
invitations.contact fk_invitations_contact N
opportunities.contact fk_opportunities_contact N
participants.contact fk_participants_contact N
users.contact 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

Visibility (0=REGULAR, 1=ARCHIVED, 2=DELETED)
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

Indexes

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

Relationships

Close relationships within degrees of separation