resources

Name	Type	Storage	Nullable	Foreign Keys	Default Value & Notes
PKID	integer	plain			Resource 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: date_part('epoch', now())Last modification date and time as a Unix timestamp (auto-reset on modification)
application	integer	plain		applications.ID	Application ID (`null`=STANDALONE)
activity	smallint	plain			Default: 0Activity (`0`=ACTIVE, `1`=DEACTIVATED, `2`=DELETED)
name	text	main			Name
identifier	character varying(200)	main			Unique resource identifier
mimetype	text	main			Default: 'text/x-zymba'MIME type (RFC 2045)
public	smallint	plain			Default: 0Publicly accessible
binfile	integer	plain		binfiles.ID	No description provided.

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_resources_application					gin	application
fk_resources_binfile					btree	binfile
pk_resources					btree	ID
s_resources_identifier					gin	identifier
s_resources_name					gin	name
u_resources_identifier					btree	identifier

Name	Type
dc_resources_activity	check
dc_resources_identifier	check
dc_resources_mimetype	check
dc_resources_name	check
fk_resources_application	foreign_key
fk_resources_binfile	foreign_key
fk_resources_creator	foreign_key
pk_resources	primary_key
u_resources_identifier	unique

Loading...