Context Table Schema (context)


Description

one of these must be set

context table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
block_instances.parentcontextid blocinst_par2_fk R
block_positions.contextid blocposi_con2_fk R
blog_association.contextid blogasso_con2_fk R
catalog.contextid Implied Constraint R
cohort.contextid coho_con2_fk R
cohort_role.contextid Implied Constraint R
comments.contextid Implied Constraint R
competency_evidence.contextid Implied Constraint R
competency_framework.contextid Implied Constraint R
competency_template.contextid Implied Constraint R
editor_atto_autosave.contextid Implied Constraint R
enrol_lti_tools.contextid enroltitool_con2_fk R
external_tokens.contextid extetoke_con2_fk R
files.contextid file_con3_fk R
filter_active.contextid filtacti_con2_fk R
filter_config.contextid filtconf_con2_fk R
grade_letters.contextid Implied Constraint R
grading_areas.contextid gradarea_con2_fk R
logstore_standard_log.contextid logsstanlog_con2_fk R
logstore_standard_log.contextinstanceid Implied Constraint R
question_categories.contextid Implied Constraint R
question_usages.contextid quesusag_con2_fk R
rating.contextid rati_con2_fk R
repository_instances.contextid Implied Constraint R
role_assignments.contextid roleassi_con2_fk R
role_capabilities.contextid rolecapa_con2_fk R
role_names.contextid rolename_con2_fk R
role_sortorder.contextid rolesort_con2_fk R
tag_instance.contextid taginst_con2_fk R
tool_monitor_events.contextid Implied Constraint R
tool_monitor_events.contextinstanceid Implied Constraint R
totara_userdata_export.contextid Implied Constraint R
totara_userdata_purge.contextid Implied Constraint R
contextlevel BIGINT 19 0
instanceid BIGINT 19 0
path VARCHAR 255 null
depth TINYINT 3 0
parentid BIGINT 19 null

Used by Totara SQL access code

Table contained -1 rows

context table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
cont_conins_uix Must be unique Asc/Asc contextlevel + instanceid
cont_ins_ix Performance Asc instanceid
cont_par_ix Performance Asc parentid
cont_pat_ix Performance Asc path

context table relationships