groups_ancestors


Description

All ancestor relationships for groups, given that a group is its own ancestor and team ancestors are not propagated to their members. It is a cache table that can be recomputed based on the content of groups_groups.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ancestor_group_id BIGINT 19 null
groups.id fk_groups_ancestors_ancestor_group_id_groups_id C
child_group_id BIGINT 19 null
groups.id fk_groups_ancestors_child_group_id_groups_id C
child_group_type enum('Class', 'Team', 'Club', 'Friends', 'Other', 'User', 'Session', 'Base', 'ContestParticipants') 19 null

The type of the child group in the relationship (we duplicate groups.type to improve performance)
is_self BIT 1 √ null

Whether ancestor_group_id = child_group_id (auto-generated)
expires_at DATETIME 19 9999-12-31 23:59:59

The group relation expires at the specified time

Table contained 1 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc/Asc ancestor_group_id + child_group_id
descendant Performance Asc child_group_id

Relationships

Close relationships within degrees of separation