role_capabilities

0 rows


Description

Override a capability for a particular role in a particular context https://github.com/moodle/moodle/blob/master/lib/db/install.xml https://docs.moodle.org/dev/Access_API

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
contextid BIGINT 19 0
context.id rolecapa_con2_fkR
roleid BIGINT 19 0
role.id rolecapa_rol2_fkR
capability VARCHAR 255
capabilities.name rolecapa_cap2_fkR
permission BIGINT 19 0

must be signed
timemodified BIGINT 19 0
modifierid BIGINT 19 0
user.id rolecapa_mod2_fkR

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
rolecapa_cap4_ix Performance Asc capability
rolecapa_con4_ix Performance Asc contextid
rolecapa_mod4_ix Performance Asc modifierid
rolecapa_rol4_ix Performance Asc roleid
rolecapa_rolconcap2_uix Must be unique Asc/Asc/Asc roleid + contextid + capability

Relationships

Close relationships within degrees of separation