role_allow_view

0 rows


Description

This table stores which which other roles a user is allowed to view 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 rolealloview_rol2_fkR

The role the user has.
allowview BIGINT 19 null
role.id rolealloview_all2_fkR

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

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
rolealloview_all_ix Performance Asc allowview
rolealloview_rol_ix Performance Asc roleid
rolealloview_rolall_uix Must be unique Asc/Asc roleid + allowview

Relationships

Close relationships within degrees of separation