contacts2contacts

Module: contacts

Junction table linking related contacts to each other.

Name	Type	Nullable	Default Value	Notes
PKID	bigint			Contact-to-contact ID
creator	integer			Creator user ID (defaults to authenticated user on creation)
creationdate	bigint		date_part('epoch', now())	Creation date and time as a Unix timestamp (defaults to current date and time on creation)
lastmodified	bigint		EXTRACT(epoch FROM now())	Last modification date and time as a Unix timestamp (auto-reset on modification)
contact1 contacts.ID	integer			First contact ID (**dependency**)
contact2 contacts.ID	integer			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
pk_contacts2contacts	primary_key
u_contacts2contacts_contact1_contact2	unique

Name	Type	Events	Function	Definition
tiu_contacts2contacts_unique	before	insert, update	ftiu_contacts2contacts_unique

Loading...