permissions_propagate


Description

Used by the access rights propagation algorithm to keep track of the status of the propagation

Columns

Column Type Size Nulls Auto Default Children Parents Comments
group_id BIGINT 19 null
groups.id fk_permissions_propagate_group_id_groups_id C
item_id BIGINT 19 null
items.id fk_permissions_propagate_item_id_items_id C
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 group_id + item_id
fk_permissions_propagate_item_id_items_id Performance Asc item_id
propagate_to_group_id_item_id Performance Asc/Asc/Asc propagate_to + group_id + item_id

Relationships

Close relationships within degrees of separation