Role Assignments Table Schema (role_assignments)


Description

assigning roles in different context

role_assignments table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
roleid BIGINT 19 0
role.id roleassi_rol2_fk R
contextid BIGINT 19 0
context.id roleassi_con2_fk R
userid BIGINT 19 0
user.id roleassi_use2_fk R
timemodified BIGINT 19 0
modifierid BIGINT 19 0
component VARCHAR 100

plugin responsible responsible for role assignment, empty when manually assigned
itemid BIGINT 19 0

Id of enrolment/auth instance responsible for this role assignment
sortorder BIGINT 19 0

Table contained -1 rows

role_assignments table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
roleassi_comiteuse_ix Performance Asc/Asc/Asc component + itemid + userid
roleassi_con_ix Performance Asc contextid
roleassi_rol_ix Performance Asc roleid
roleassi_rolcon_ix Performance Asc/Asc roleid + contextid
roleassi_sor_ix Performance Asc sortorder
roleassi_use_ix Performance Asc userid
roleassi_useconrol_ix Performance Asc/Asc/Asc userid + contextid + roleid

role_assignments table relationships

Close relationships within degrees of separation