Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| connection_id | BIGINT UNSIGNED | 20 | null |
|
|
|||
| group_id | BIGINT | 19 | null |
|
|
|||
| item_id | BIGINT | 19 | null |
|
|
|||
| propagate_to | enum('self', 'children') | 8 | null |
|
|
Which permissions should be recomputed for the group-item pair on the next iteration, either for the pair or for its children (through item hierarchy) |
Table contained 0 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc/Asc/Asc | connection_id + group_id + item_id |
| connection_id_propagate_to_group_id_item_id | Performance | Asc/Asc/Asc/Asc | connection_id + propagate_to + group_id + item_id |
| fk_permissions_propagate_item_id_items_id | Performance | Asc | item_id |