contacts2contacts

Name	Type	Storage	Nullable	Foreign Keys	Default Value & Notes
PKID	bigint	plain			Contact-to-contact ID
creator	integer	plain		users.ID	Creator user ID (defaults to authenticated user on creation)
creationdate	bigint	plain			Default: date_part('epoch', now())Creation date and time as a Unix timestamp (defaults to current date and time on creation)
lastmodified	bigint	plain			Default: EXTRACT(epoch FROM now())Last modification date and time as a Unix timestamp (auto-reset on modification)
contact1	integer	plain		contacts.ID	First contact ID (**dependency**)
contact2	integer	plain		contacts.ID	Second contact ID (**dependency**)

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_contacts2contacts_contact2					btree	contact2
pk_contacts2contacts					btree	ID
u_contacts2contacts_contact1_contact2					btree	contact1, contact2

Name	Type
fk_contacts2contacts_contact1	foreign_key
fk_contacts2contacts_contact2	foreign_key
fk_contacts2contacts_creator	foreign_key
pk_contacts2contacts	primary_key
u_contacts2contacts_contact1_contact2	unique

Name	Type	Events	Function	Definition
tiu_contacts2contacts_unique	before	insert, update	ftiu_contacts2contacts_unique

Loading...