items_ancestors


Description

All child-ancestor relationships (a item is not its own ancestor). Cache table that can be recomputed based on the content of groups_groups.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ancestor_item_id BIGINT 19 null
items.id fk_items_ancestors_ancestor_item_id_items_id R
child_item_id BIGINT 19 null
items.id fk_items_ancestors_child_item_id_items_id C

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc ancestor_item_id + child_item_id
ancestor_item_id Performance Asc ancestor_item_id
child_item_id Performance Asc child_item_id

Relationships

Close relationships within degrees of separation