Cohort Visibility Table Schema (cohort_visibility)


Description

A table to store cohorts visible learning assignments

cohort_visibility table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
cohortid BIGINT 19 0
cohort.id cohovisi_coh2_fk R
instanceid BIGINT 19 0
instancetype SMALLINT 5 √ null
timemodified BIGINT 19 √ null
timecreated BIGINT 19 √ null
usermodified BIGINT 19 √ null
user.id cohovisi_use2_fk R

Table contained -1 rows

cohort_visibility table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
cohovisi_coh_ix Performance Asc cohortid
cohovisi_cohinsins_uix Must be unique Asc/Asc/Asc cohortid + instanceid + instancetype
cohovisi_use_ix Performance Asc usermodified

cohort_visibility table relationships

Close relationships within degrees of separation