# role_capabilities

0 rows

### Description

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

### 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_cap_ix | Performance | Asc | capability
rolecapa_con_ix | Performance | Asc | contextid
rolecapa_mod_ix | Performance | Asc | modifierid
rolecapa_rol_ix | Performance | Asc | roleid
rolecapa_rolconcap_uix | Must be unique | Asc/Asc/Asc | roleid + contextid + capability

### Relationships