Groupings Table Schema (groupings)


A grouping is a collection of groups. WAS: groups_groupings

groupings table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 null
course_modules.groupingid courmodu_gro2_fk R
groupings_groups.groupingid grougrou_gro3_fk R
courseid bigint 10 0 grou_cou4_fk R
name varchar 255

Short human readable unique name for group.

idnumber varchar 100
description longtext 2147483647 null
descriptionformat tinyint 2 0
configdata longtext 2147483647 null

extra configuration data - may be used by group IU tools

timecreated bigint 10 0
timemodified bigint 10 0

Table contained -1 rows

groupings table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
grou_cou2_ix Performance Asc courseid
grou_idn2_ix Performance Asc idnumber

groupings table relationships