app_role_allow_switch

10 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 bigserial 19 √ nextval('app_role_allow_switch_id_seq'::regclass)
roleid int8 19 null
app_role.id Defined in XMLR
allowswitch int8 19 null
app_role.id Defined in XMLR

Indexes

Constraint Name Type Sort Column(s)
app_rolealloswit_id_pk Primary key Asc id
app_rolealloswit_all_ix Performance Asc allowswitch
app_rolealloswit_rol_ix Performance Asc roleid
app_rolealloswit_rolall_uix Must be unique Asc/Asc roleid + allowswitch

Relationships

Close relationships within degrees of separation