Role Capabilities Table Schema (role_capabilities)


Description

permission has to be signed, overriding a capability for a particular role in a particular context

role_capabilities table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
contextid BIGINT 19 0
context.id rolecapa_con2_fk R
roleid BIGINT 19 0
role.id rolecapa_rol2_fk R
capability VARCHAR 255
capabilities.name rolecapa_cap2_fk R
permission BIGINT 19 0
timemodified BIGINT 19 0
modifierid BIGINT 19 0
user.id rolecapa_mod2_fk R

Table contained -1 rows

role_capabilities table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
rolecapa_cap_ix Performance Asc capability
rolecapa_con_ix Performance Asc contextid
rolecapa_mod_ix Performance Asc modifierid
rolecapa_rol_ix Performance Asc roleid
rolecapa_rolcapper_ix Performance Asc/Asc/Asc roleid + capability + permission
rolecapa_rolconcap_uix Must be unique Asc/Asc/Asc roleid + contextid + capability

role_capabilities table relationships

Close relationships within degrees of separation