entities2channels

Module: control

Junction table linking entities to communication channels.

Name	Type	Nullable	Default Value	Notes
PKID	bigint			Entity-to-channel 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)
entity	t_entity			Canonical entity
index	integer			Entity ID
channel channels.ID	integer			Channel ID (**dependency**)

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_entities2channels_channel					btree	channel
pk_entities2channels					btree	ID
u_entities2channels_entity_index					btree	entity, index, +channel

Name	Type
c_entities2channels_entity	check
fk_entities2channels_channel	foreign_key
pk_entities2channels	primary_key
u_entities2channels_entity_index	unique

Loading...