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
name VARCHAR 254
idnumber VARCHAR 100 √ null
description LONGTEXT 2147483647 √ null
descriptionformat TINYINT 3 null
visible BIT 1 1
component VARCHAR 100
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_con4_ix Performance Asc contextid

Relationships

Close relationships within degrees of separation