Column Type Size Nulls Auto Default Children Parents Comments
ID serial 10 nextval('"contacts_ID_seq"'::regclass) 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 C FK_opportunities_contact N FK_participants_contact N FK_users_contact N
owneruser int4 10 null
users.ID FK_contacts_owneruser C

The owner user

ownergroup int4 10 null
groups.ID FK_contacts_ownergroup C

The owner group (if owneruser and ownergroup are NULL, the element is public)

creator int4 10 null
users.ID FK_contacts_creator N

The object creator

assigneduser int4 10 null
users.ID FK_contacts_assigneduser N

The assigned user

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

Last modification date/time (Unix timestamp in seconds)

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

Last modification date/time (Unix timestamp in seconds)

visibility int2 5 0

0: Visible, 1: Archived, 2: Deleted

lastname text 2147483647 ''::text
firstname text 2147483647 ''::text
type int2 5 0

Contact type (0: Company, 1: Person)

title text 2147483647 ''::text
company text 2147483647 ''::text
position text 2147483647 ''::text
department text 2147483647 ''::text
address text 2147483647 ''::text
postalcode text 2147483647 ''::text
city text 2147483647 ''::text
region text 2147483647 ''::text
country varchar 2 ''::character varying
phone text 2147483647 ''::text
phone2 text 2147483647 ''::text
cell text 2147483647 ''::text
fax text 2147483647 ''::text
email text 2147483647 ''::text
email2 text 2147483647 ''::text
website text 2147483647 ''::text
birthdate int8 19 null
description text 2147483647 ''::text

The general description field

picbinfile int4 10 null

Image file

Table contained 0 rows


Constraint Name Type Sort Column(s)
PK_contacts_ID Primary key Asc ID