permissions

Name	Type	Storage	Nullable	Foreign Keys	Default Value & Notes
PKID	bigint	plain			Permission 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)
group	integer	plain		groups.ID	Group ID (**dependency**)
fork	integer	plain		forks.ID	Fork ID; is mutually exclusive to `application` and `identifier` (either one is required)
application	integer	plain		applications.ID	Application ID; is mutually exclusive to `fork` and `identifier` (either one is required)
identifier	character varying(200)	extended			Permission identifier (e.g. module); is mutually exclusive to `fork` and `application` (either one is required)
writable	smallint	plain			Default: 0Allow writing of permission-specific data by group members

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_permissions_application					gin	application
fk_permissions_fork					gin	fork
pk_permissions					btree	ID
u_permissions_group_fork_application_identifier					btree	group, fork, application, identifier

Name	Type
c_permissions_association	check
dc_permissions_identifier	check
fk_permissions_application	foreign_key
fk_permissions_creator	foreign_key
fk_permissions_fork	foreign_key
fk_permissions_group	foreign_key
pk_permissions	primary_key
u_permissions_group_fork_application_identifier	unique

Loading...