categories

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