categories

Module: main

User-defined categories for organizing entities.

Name	Type	Nullable	Default Value	Notes
PKID	integer			Category ID
fork forks.ID	integer			Fork ID (`null` for base module)
owneruser users.ID	integer			Owner user ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`)
ownergroup groups.ID	integer			Owner group ID (PUBLIC if `owneruser`=`null` and `ownergroup`=`null`)
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	text			Canonical entity
name	text			Name

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
i_categories_entity_name_root					btree	entity, name
i_categories_entity_name_sub					btree	entity, name
i_categories_fork_entity_name_root					btree	fork, entity, name
i_categories_fork_entity_name_sub					btree	fork, entity, name
pk_categories					btree	ID
u_categories_fork_entity_name_owneruser_ownergroup					btree	fork, entity, name, owneruser, ownergroup

Name	Type
c_categories_owner	check
dc_categories_entity	check
dc_categories_name	check
fk_categories_fork	foreign_key
fk_categories_ownergroup	foreign_key
fk_categories_owneruser	foreign_key
pk_categories	primary_key
u_categories_fork_entity_name_owneruser_ownergroup	unique

Loading...