groups

0 rows


Description

Each record represents a group.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
assign_overrides.groupid assiover_gro2_fkR
groupings_groups.groupid grougrou_gro4_fkR
groups_members.groupid groumemb_gro2_fkR
lesson_overrides.groupid lessover_gro2_fkR
quiz_overrides.groupid quizover_gro2_fkR
courseid BIGINT 19 null
course.id grou_cou3_fkR
idnumber VARCHAR 100
name VARCHAR 254

Short human readable unique name for the group.

description LONGTEXT 2147483647 null
descriptionformat TINYINT 3 0
enrolmentkey VARCHAR 50 null
picture BIGINT 19 0
hidepicture BIT 1 0
timecreated BIGINT 19 0
timemodified BIGINT 19 0

Indexes

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

Relationships