cohort

0 rows


Description

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

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
cohort_members.cohortid cohomemb_coh2_fkR
competency_templatecohort.cohortid Implied ConstraintR
tool_cohortroles.cohortid tool_cohortroles_erd_cohortR
contextid BIGINT 19 null
context.id coho_con2_fkR

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

Indexes

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

Relationships