permission

246 rows


Description

Available permissions

Columns

Column Type Size Nulls Auto Default Children Parents Comments
code bpchar 5 null
group_permission.code fk_group_permission_code C
group_permission_override.code fk_group_permission_override_code C
reports.permission_code Implied Constraint R
user_permission.code fk_user_permission_code C
user_permission_override.code fk_user_permission_override_code C
v_active_reports.permission_code Implied Constraint R
v_daily_reports.permission_code Implied Constraint R
name text 2147483647 √ null
category text 2147483647 √ null
parent bpchar 5 √ null
id bigserial 19 √ nextval('permission_id_seq'::regclass)
group_permission.perm_id fk_group_permission_perm_id C
group_permission_override.perm_id fk_group_permission_override_perm_id C
permission.parent_id fk_permission_parent_id R
user_permission.perm_id fk_user_permission_perm_id C
user_permission_override.perm_id fk_user_permission_override_perm_id 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 code
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

Relationships

Close relationships within degrees of separation