Column Type Size Nulls Auto Default Children Parents Comments
ID int8 19 null

Contact-to-contact ID

creator int4 10 null
users.ID fk_contacts2contacts_creator N

Creator user ID (defaults to authenticated user on creation)

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)

contact1 int4 10 null
contacts.ID fk_contacts2contacts_contact1 C

First contact ID (**dependency**)

contact2 int4 10 null
contacts.ID fk_contacts2contacts_contact2 C

Second contact ID (**dependency**)

Table contained 0 rows


Constraint Name Type Sort Column(s)
pk_contacts2contacts Primary key Asc ID
fk_contacts2contacts_contact2 Performance Asc contact2
u_contacts2contacts_contact1_contact2 Must be unique Asc/Asc contact1 + contact2