storages

Name	Type	Storage	Nullable	Foreign Keys	Default Value & Notes
PKID	integer	plain			Storage ID
fork	integer	plain		forks.ID	Fork ID (`null` for base module)
ownergroup	integer	plain		groups.ID	Owner group ID (`null`=PUBLIC)
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: date_part('epoch', now())Last modification date and time as a Unix timestamp (auto-reset on modification)
visibility	smallint	plain			Default: 0Visibility (`0`=REGULAR, `1`=ARCHIVED, `2`=DELETED)
name	text	main			Name
description	text	extended			Default: ''Detailed general description

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_storages_fork					gin	fork
fk_storages_ownergroup					gin	ownergroup
i_storages_nofork					gin	fork
i_storages_noowner					gin	ownergroup
pk_storages					btree	ID
s_storages_name					gin	name

Name	Type
dc_storages_description	check
dc_storages_name	check
dc_storages_visibility	check
fk_storages_creator	foreign_key
fk_storages_fork	foreign_key
fk_storages_ownergroup	foreign_key
pk_storages	primary_key

Name	Type	Events	Function	Definition
td_storages_serials	before	delete	ftd_storages_serials

Loading...