Groupings Groups Table Schema (groupings_groups)


Description

Link a grouping to a group (note, groups can be in multiple groupings ONLY in a course). WAS: groups_groupings_groups

groupings_groups table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
groupingid BIGINT 19 0
groupings.id grougrou_gro3_fk R
groupid BIGINT 19 0
groups.id grougrou_gro4_fk R
timeadded BIGINT 19 0

Table contained -1 rows

groupings_groups table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
grougrou_gro2_ix Performance Asc groupid
grougrou_gro_ix Performance Asc groupingid

groupings_groups table relationships

Close relationships within degrees of separation