groupings

0 rows


Description

A grouping is a collection of groups. WAS: groups_groupings

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
course_modules.groupingid courmodu_gro2_fkR
groupings_groups.groupingid grougrou_gro3_fkR
courseid BIGINT 19 0
course.id grou_cou5_fkR
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

Indexes

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

Relationships