items_propagate


Description

Used by the algorithm that updates the items_ancestors table, and keeps track of what items still need to have their relationship with their descendants / ancestors propagated.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
items.id fk_id C
ancestors_computation_state enum('todo', 'done') 4 null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
ancestors_computation_date Performance Asc ancestors_computation_state

Relationships

Close relationships within degrees of separation