Totara Connect Client Cohorts Table Schema (totara_connect_client_cohorts)


Description

List of cohorts synced to a client, the members are restricted by totara_connect_clients.cohortid if specified

totara_connect_client_cohorts table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
clientid BIGINT 19 null
totara_connect_clients.id totaconncliecoho_cli2_fk R
cohortid BIGINT 19 null
cohort.id totaconncliecoho_coh2_fk R
timecreated BIGINT 19 null

Table contained -1 rows

totara_connect_client_cohorts table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
totaconncliecoho_cli_ix Performance Asc clientid
totaconncliecoho_clicoh_uix Must be unique Asc/Asc clientid + cohortid
totaconncliecoho_coh_ix Performance Asc cohortid

totara_connect_client_cohorts table relationships

Close relationships within degrees of separation