associations

Name	Type	Storage	Nullable	Foreign Keys	Default Value & Notes
PKID	bigint	plain			Association 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)
entity1	t_entity	plain			First canonical entity
entity2	t_entity	plain			Second canonical entity
index1	integer	plain			First entity ID
index2	integer	plain			Second entity ID
relation	text	extended			Default: ''Relation
meta	json	extended			JSON-encoded metadata (object)

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
i_associations_entity2_index2					btree	entity2, index2
pk_associations					btree	ID
u_associations_entity1_index1_entity2_index2					btree	entity1, index1, entity2, index2

Name	Type
c_associations_entity	check
dc_associations_meta	check
dc_associations_relation	check
fk_associations_creator	foreign_key
pk_associations	primary_key
u_associations_entity1_index1_entity2_index2	unique

Name	Type	Events	Function	Definition
tiu_associations_unique	before	insert, update	ftiu_associations_unique

Loading...