app_totara_connect_client_courses

0 rows


Description

List of courses synced to a client, the enrolled users are restricted by totara_connect_clients.cohortid if specified

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_totara_connect_client_courses_id_seq'::regclass)
clientid int8 19 null
app_totara_connect_clients.id Defined in XML R
courseid int8 19 null
app_course.id Defined in XML R
timecreated int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_totaconncliecour_id_pk Primary key Asc id
app_totaconncliecour_cli_ix Performance Asc clientid
app_totaconncliecour_clico_uix Must be unique Asc/Asc clientid + courseid
app_totaconncliecour_cou_ix Performance Asc courseid

Relationships

Close relationships within degrees of separation