Role Allow Assign Table Schema (role_allow_assign)


Description

this defines what role can assign what role

role_allow_assign table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
roleid BIGINT 19 0
role.id rolealloassi_rol2_fk R
allowassign BIGINT 19 0
role.id rolealloassi_all2_fk R

Table contained -1 rows

role_allow_assign table 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

role_allow_assign table relationships

Close relationships within degrees of separation