context

0 rows


Description

one of these must be set

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
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
editor_atto_autosave.contextid Implied ConstraintR
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
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

Close relationships within degrees of separation