contacts2contacts


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID bigserial 19 nextval('"contacts2contacts_ID_seq"'::regclass)
creator int4 10 null
users.ID FK_contacts2contacts_creator N

The object creator

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

Last modification date/time (Unix timestamp in seconds)

contact1 int4 10 null
contacts.ID FK_contacts2contacts_contact1 C
contact2 int4 10 null
contacts.ID FK_contacts2contacts_contact2 C

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PK_contacts2contacts_ID Primary key Asc ID
UNQ_contacts2contacts_contact1_contact2 Must be unique Asc/Asc contact1 + contact2

Relationships