Role Context Levels Table Schema (role_context_levels)


Description

Lists which roles can be assigned at which context levels. The assignment is allowed in the corresponding row is present in this table.

role_context_levels table columns

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

Table contained -1 rows

role_context_levels table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
rolecontleve_conrol_uix Must be unique Asc/Asc contextlevel + roleid
rolecontleve_rol_ix Performance Asc roleid

role_context_levels table relationships

Close relationships within degrees of separation