resources

Module: dev

Reusable script resources for applications.

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

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
pk_resources	primary_key
u_resources_identifier	unique

Loading...