entities2channels

Name	Type	Storage	Nullable	Foreign Keys	Default Value & Notes
PKID	bigint	plain			Entity-to-channel 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)
entity	t_entity	plain			Canonical entity
index	integer	plain			Entity ID
channel	integer	plain		channels.ID	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
fk_entities2channels_creator	foreign_key
pk_entities2channels	primary_key
u_entities2channels_entity_index	unique

Loading...