Role Capabilities Table Schema (role_capabilities)


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 rolecapa_con2_fk R
roleid BIGINT 19 0 rolecapa_rol2_fk R
capability VARCHAR 255 rolecapa_cap2_fk R
permission BIGINT 19 0
timemodified BIGINT 19 0
modifierid BIGINT 19 0 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