Cohort Table Schema (cohort)


Description

Each record represents one cohort (aka site-wide group).

cohort table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
block_zoola_reports_cohort.cohortid bloczoolrepocoho_coh2_fk R
cohort_members.cohortid cohomemb_coh2_fk R
competency_templatecohort.cohortid Implied Constraint R
tool_cohortroles.cohortid Implied Constraint R
contextid BIGINT 19 null
context.id coho_con2_fk R

Context is usually ignored in sync operations so that the cohorts may be moved freely around in the context tree without any side affects.
name VARCHAR 254

Short human readable name for the cohort, does not have to be unique
idnumber VARCHAR 100 √ null

Unique identifier of a cohort, useful especially for mapping to external entities
description LONGTEXT 2147483647 √ null

Standard description text box
descriptionformat TINYINT 3 null
visible BIT 1 1

Visibility to teachers
component VARCHAR 100

Component (plugintype_pluignname) that manages the cohort, manual modifications are allowed only when set to NULL
timecreated BIGINT 19 null
timemodified BIGINT 19 null
theme VARCHAR 50 √ null

Table contained -1 rows

cohort table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
coho_con_ix Performance Asc contextid

cohort table relationships

Close relationships within degrees of separation