permission

417 rows


Description

Available permissions

Columns

Column Type Size Nulls Auto Default Children Parents Comments
code text 2147483647 null
group_permission.code fk_group_permission_permission C
group_permission_override.code fk_group_permission_override_permission C
rpc_permission.permission_code fk_rpc_permission_code R
user_permission.code fk_user_permission_permission C
user_permission_override.code fk_user_permission_override_permission C
name text 2147483647 √ null
category text 2147483647 √ null
parent text 2147483647 √ null
id bigserial 19 √ nextval('permission_id_seq'::regclass)
group_permission.perm_id fk_group_permission_permission C
group_permission_override.perm_id fk_group_permission_override_permission C
permission.parent_id fk_permission_parent_id R
user_permission.perm_id fk_user_permission_permission C
user_permission_override.perm_id fk_user_permission_override_permission C
app_code text 2147483647 'pms'::text
perm_key text 2147483647 √ null
parent_id int8 19 √ null
permission.id fk_permission_parent_id R

Indexes

Constraint Name Type Sort Column(s)
permission_pkey Primary key Asc id
idx_permission_app_code Performance Asc app_code
idx_permission_id Must be unique Asc id
idx_permission_perm_key Must be unique Asc perm_key
permission_category_idx Performance Asc category
permission_code_key Must be unique Asc code
permission_id_code_key Must be unique Asc/Asc id + code

Relationships

Close relationships within degrees of separation