Role Allow Switch Table Schema (role_allow_switch)


Description

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

role_allow_switch table columns

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

The role the user has.
allowswitch BIGINT 19 null
role.id rolealloswit_all2_fk R

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

Table contained -1 rows

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

role_allow_switch table relationships

Close relationships within degrees of separation