group_permission

1998 rows


Description

Group authorized permissions

Columns

Column Type Size Nulls Auto Default Children Parents Comments
group_id int4 10 null
user_group.id fk_group_permission_group_id C
code bpchar 5 null
permission.code fk_group_permission_code C
perm_id int8 19 √ null
permission.id fk_group_permission_perm_id C

Indexes

Constraint Name Type Sort Column(s)
group_permission_pkey Primary key Asc/Asc group_id + code
idx_group_permission_perm_id Performance Asc perm_id

Relationships

Close relationships within degrees of separation