user_permission

39709 rows


Description

User authorized permissions

Columns

Column Type Size Nulls Auto Default Children Parents Comments
user_id int4 10 null
users.id fk_user_permission_user_id C
prop_id int4 10 null
property.id fk_user_permission_prop_id C
code bpchar 5 null
permission.code fk_user_permission_code C

Indexes

Constraint Name Type Sort Column(s)
user_permission_pkey Primary key Asc/Asc/Asc user_id + prop_id + code

Relationships

Close relationships within degrees of separation