role_capabilities

0 rows


Description

permission has to be signed, overriding a capability for a p

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
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_cap2_ix Performance Asc capability
rolecapa_con2_ix Performance Asc contextid
rolecapa_mod2_ix Performance Asc modifierid
rolecapa_rol2_ix Performance Asc roleid
rolecapa_rolconcap2_uix Must be unique Asc/Asc/Asc roleid + contextid + capability

Relationships

Close relationships within degrees of separation