# context

View table data

0 rows

### Description

one of these must be set

### Columns

Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | BIGINT | 19 |  | √ | null |
ai_action_register.contextid | Implied ConstraintR
ai_policy_register.contextid | Implied ConstraintR
analytics_indicator_calc.contextid | analindicalc_con2_fkR
analytics_predictions.contextid | analpred_con2_fkR
block_instances.parentcontextid | blocinst_par2_fkR
block_positions.contextid | blocposi_con2_fkR
blog_association.contextid | blogasso_con2_fkR
cohort.contextid | coho_con2_fkR
comments.contextid | Implied ConstraintR
communication.contextid | comm_con2_fkR
competency_evidence.contextid | compevid_con2_fkR
competency_framework.contextid | compfram_con2_fkR
competency_template.contextid | comptemp_con2_fkR
contentbank_content.contextid | contcont_con2_fkR
customfield_category.contextid | custcate_con2_fkR
customfield_data.contextid | custdata_con2_fkR
enrol_lti_tools.contextid | enroltitool_con2_fkR
external_tokens.contextid | extetoke_con2_fkR
favourite.contextid | favo_con2_fkR
files.contextid | file_con2_fkR
filter_active.contextid | filtacti_con2_fkR
filter_config.contextid | filtconf_con2_fkR
grade_letters.contextid | grade_letters_erd_contextR
gradepenalty_duedate_rule.contextid | Implied ConstraintR
grading_areas.contextid | gradarea_con2_fkR
logstore_standard_log.contextid | logsstanlog_con2_fkR
logstore_standard_log.contextinstanceid | Implied ConstraintR
message_conversations.contextid | messconv_con2_fkR
payment_accounts.contextid | paymacco_con2_fkR
question_categories.contextid | Implied ConstraintR
question_references.usingcontextid | quesrefe_usi2_fkR
question_set_references.questionscontextid | quessetrefe_que2_fkR
question_set_references.usingcontextid | quessetrefe_usi2_fkR
question_usages.contextid | quesusag_con2_fkR
rating.contextid | rati_con2_fkR
reportbuilder_report.contextid | reporepo_con2_fkR
repository_instances.contextid | repoinst_con2_fkR
role_assignments.contextid | roleassi_con2_fkR
role_capabilities.contextid | rolecapa_con2_fkR
role_names.contextid | rolename_con2_fkR
search_index_requests.contextid | searinderequ_con2_fkR
search_simpledb_index.contextid | Implied ConstraintR
tag_instance.contextid | taginst_con2_fkR
tiny_autosave.contextid | Implied ConstraintR
tool_brickfield_areas.contextid | toolbricarea_con2_fkR
tool_brickfield_process.contextid | Implied ConstraintR
tool_brickfield_schedule.contextid | Implied ConstraintR
tool_dataprivacy_ctxexpired.contextid | tooldatactxe_con_fkR
tool_dataprivacy_ctxinstance.contextid | tooldatactxi_con_fkR
tool_dataprivacy_ctxlst_ctx.contextid | Implied ConstraintR
tool_monitor_events.contextid | toolmonieven_con3_fkR
contextlevel | BIGINT | 19 |  |  | 0 |  |  |
instanceid | BIGINT | 19 |  |  | 0 |
tool_monitor_events.contextinstanceid | toolmonieven_con4_fkR
path | VARCHAR | 255 | √ |  | null |  |  |
depth | TINYINT | 3 |  |  | 0 |  |  |
locked | TINYINT | 3 |  |  | 0 |  |  | Whether this context and its children are locked

### 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_pat_ix | Performance | Asc | path

### Relationships