Cohort Table Schema (cohort)


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

cohort table columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigint 10 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 10 null 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 2 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 10 null
timemodified bigint 10 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