Cohort Role Table Schema (cohort_role)


Description

A table to store roles assigned to a cohort

cohort_role table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
cohortid BIGINT 19 0
cohort.id cohorole_coh2_fk R
roleid BIGINT 19 0
role.id cohorole_rol2_fk R
contextid BIGINT 19 0
context.id Implied Constraint R
timemodified BIGINT 19 √ null
timecreated BIGINT 19 √ null
usermodified BIGINT 19 √ null
user.id cohorole_use2_fk R

Table contained -1 rows

cohort_role table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
cohorole_coh_ix Performance Asc cohortid
cohorole_cohrolcon_uix Must be unique Asc/Asc/Asc cohortid + roleid + contextid
cohorole_rol_ix Performance Asc roleid
cohorole_use_ix Performance Asc usermodified

cohort_role table relationships

Close relationships within degrees of separation