role_allow_switch

0 rows


Description

This table stores which which other roles a user is allowed

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
roleid BIGINT 19 null
role.id rolealloswit_rol2_fkR
allowswitch BIGINT 19 null
role.id rolealloswit_all2_fkR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
rolealloswit_all4_ix Performance Asc allowswitch
rolealloswit_rol4_ix Performance Asc roleid
rolealloswit_rolall2_uix Must be unique Asc/Asc roleid + allowswitch

Relationships

Close relationships within degrees of separation