Groupings Groups Table Schema (groupings_groups)


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 grougrou_gro3_fk R
groupid BIGINT 19 0 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