associations

Module: main

Generic many-to-many relationships between any two entities.

Name	Type	Nullable	Default Value	Notes
PKID	bigint			Association 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)
entity1	t_entity			First canonical entity
entity2	t_entity			Second canonical entity
index1	integer			First entity ID
index2	integer			Second entity ID
relation	text		''	Relation
meta	json			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
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...