role_allow_assign

0 rows


Description

this defines what role can assign what role

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
roleid BIGINT 19 0
role.id rolealloassi_rol2_fkR
allowassign BIGINT 19 0
role.id rolealloassi_all2_fkR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
rolealloassi_all_ix Performance Asc allowassign
rolealloassi_rol_ix Performance Asc roleid
rolealloassi_rolall_uix Must be unique Asc/Asc roleid + allowassign

Relationships

Close relationships within degrees of separation