Groups Table Schema (groups)


Description

Each record represents a group.

groups table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
assign_overrides.groupid assiover_gro2_fk R
groupings_groups.groupid grougrou_gro4_fk R
groups_members.groupid groumemb_gro2_fk R
lesson_overrides.groupid lessover_gro2_fk R
quiz_overrides.groupid quizover_gro2_fk R
courseid BIGINT 19 null
course.id grou_cou3_fk R
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

Table contained -1 rows

groups table indexes

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

groups table relationships