permissions


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int8 19 √ null

Permission ID
creator int4 10 √ null
users.ID fk_permissions_creator N

Creator user ID (defaults to authenticated user on creation)
creationdate int8 19 date_part('epoch'::text, now())

Creation date and time as a Unix time stamp (defaults to current date and time on creation)
lastmodified int8 19 date_part('epoch'::text, now())

Last modification date and time as a Unix time stamp (auto-reset on modification)
group int4 10 null
groups.ID fk_permissions_group C

Group ID
identifier text 2147483647 null
numcounters.identifier Implied Constraint R

Permission identifier (Pattern: ^[\w.:-]+$)
writable int2 5 0

Allow writing of permission-specific data by group members

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
pk_permissions Primary key Asc ID
u_permissions_group_identifier Must be unique Asc/Asc group + identifier

Relationships

Close relationships within degrees of separation