role_allow_switch

0 rows


Description

This table stores which which other roles a user is allowed to switch to if they have one role.

Columns

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

The role the user has.

allowswitch BIGINT 19 null
role.id rolealloswit_all2_fkR

The id of a role that the user is allowed to switch to as a result of having this role.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
rolealloswit_all_ix Performance Asc allowswitch
rolealloswit_rol_ix Performance Asc roleid
rolealloswit_rolall_uix Must be unique Asc/Asc roleid + allowswitch

Relationships