Groups Table Schema (groups)


Description

Each record represents a group.

groups table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 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 10 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 2 0
enrolmentkey varchar 50 null
picture bigint 10 0
hidepicture BIT 1 0
timecreated bigint 10 0
timemodified bigint 10 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