Groupings Table Schema (groupings)


Description

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
course.id 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

Close relationships within degrees of separation