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
competency_evidence.contextid Implied ConstraintR
competency_framework.contextid Implied ConstraintR
competency_template.contextid Implied ConstraintR
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
message_conversations.contextid messconv_con2_fkR
payment_accounts.contextid Implied ConstraintR
question_categories.contextid Implied ConstraintR
question_usages.contextid quesusag_con2_fkR
rating.contextid rati_con2_fkR
repository_instances.contextid Implied ConstraintR
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
tool_dataprivacy_ctxexpired.contextid tooldatactxe_con_fkR
tool_dataprivacy_ctxinstance.contextid tooldatactxi_con_fkR
tool_monitor_events.contextid Implied ConstraintR
tool_monitor_events.contextinstanceid Implied ConstraintR
contextlevel BIGINT 19 0
instanceid BIGINT 19 0
path VARCHAR 255 √ null
depth TINYINT 3 0
locked TINYINT 3 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
cont_conins2_uix Must be unique Asc/Asc contextlevel + instanceid
cont_ins2_ix Performance Asc instanceid
cont_pat2_ix Performance Asc path

Relationships

Close relationships within degrees of separation