role_assignments

0 rows


Description

assigning roles in different context

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
roleid BIGINT 19 0
role.id roleassi_rol2_fkR
contextid BIGINT 19 0
context.id roleassi_con2_fkR
userid BIGINT 19 0
user.id roleassi_use2_fkR
timemodified BIGINT 19 0
modifierid BIGINT 19 0
component VARCHAR 100
itemid BIGINT 19 0
sortorder BIGINT 19 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
roleassi_comiteuse2_ix Performance Asc/Asc/Asc component + itemid + userid
roleassi_con4_ix Performance Asc contextid
roleassi_rol4_ix Performance Asc roleid
roleassi_rolcon2_ix Performance Asc/Asc roleid + contextid
roleassi_sor2_ix Performance Asc sortorder
roleassi_use4_ix Performance Asc userid
roleassi_useconrol2_ix Performance Asc/Asc/Asc userid + contextid + roleid

Relationships