Groupings table / groupings - Moodle LMS 3.9 Database schema / Zoola Analytics

groupings table columns

Related columns Constraint Comments

Search:

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

Showing 1 to 9 of 9 entries

Table contained -1 rows

groupings table indexes

Search:

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

Showing 1 to 3 of 3 entries

Groupings Table Schema (groupings)

Description

groupings table columns

groupings table indexes

groupings table relationships

Close relationships within degrees of separation