permissions
Group-based access permissions for views and features.
| Name | Type | Nullable | Default Value | Notes |
|---|---|---|---|---|
PKID | bigint | Permission 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) | |
group groups.ID | integer | Group ID (**dependency**) | ||
fork forks.ID | integer | Fork ID; is mutually exclusive to `application` and `identifier` (either one is required) | ||
application applications.ID | integer | Application ID; is mutually exclusive to `fork` and `identifier` (either one is required) | ||
identifier | character varying(200) | Permission identifier (e.g. module); is mutually exclusive to `fork` and `application` (either one is required) | ||
writable | smallint | 0 | Allow 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_fork | foreign_key |
| fk_permissions_group | foreign_key |
| pk_permissions | primary_key |
| u_permissions_group_fork_application_identifier | unique |
Loading...