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 19 null
course_modules.groupingid courmodu_gro2_fk R
groupings_groups.groupingid grougrou_gro3_fk R
courseid BIGINT 19 0 grou_cou4_fk R
name VARCHAR 255

Short human readable unique name for group.

idnumber VARCHAR 100
description LONGTEXT 2147483647 null
descriptionformat TINYINT 3 0
configdata LONGTEXT 2147483647 null

extra configuration data - may be used by group IU tools

timecreated BIGINT 19 0
timemodified BIGINT 19 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