Constraints

392 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
quizgrad_qui2_fk
quiz_grades.quiz
quiz.id
Restrict delete
grou_cou3_fk
groups.courseid
course.id
Restrict delete
lessansw_les2_fk
lesson_answers.lessonid
lesson.id
Restrict delete
lessansw_pag2_fk
lesson_answers.pageid
lesson_pages.id
Restrict delete
scorscoedata_sco2_fk
scorm_scoes_data.scoid
scorm_scoes.id
Restrict delete
datareco_dat2_fk
data_records.dataid
data.id
Restrict delete
upgrlog_use2_fk
upgrade_log.userid
user.id
Restrict delete
bloczoolrepo_blo2_fk
block_zoola_reports.blockinstanceid
block_instances.id
Restrict delete
badgissu_bad2_fk
badge_issued.badgeid
badge.id
Restrict delete
badgissu_use2_fk
badge_issued.userid
user.id
Restrict delete
assisubm_ass4_fk
assignment_submissions.assignment
assignment.id
Restrict delete
bloczoolrepouser_use2_fk
block_zoola_reports_user.userid
user.id
Restrict delete
bloczoolrepouser_blo2_fk
block_zoola_reports_user.blockinstanceid
block_instances.id
Restrict delete
fileconv_sou2_fk
file_conversion.sourcefileid
files.id
Restrict delete
fileconv_des2_fk
file_conversion.destfileid
files.id
Restrict delete
compcour_com2_fk
competency_coursecomp.competencyid
competency.id
Restrict delete
compcour_cou3_fk
competency_coursecomp.courseid
course.id
Restrict delete
lessatte_pag2_fk
lesson_attempts.pageid
lesson_pages.id
Restrict delete
lessatte_ans2_fk
lesson_attempts.answerid
lesson_answers.id
Restrict delete
lessatte_les2_fk
lesson_attempts.lessonid
lesson.id
Restrict delete
badg_use3_fk
badge.usermodified
user.id
Restrict delete
badg_use4_fk
badge.usercreated
user.id
Restrict delete
badg_cou2_fk
badge.courseid
course.id
Restrict delete
gradoutc_sca2_fk
grade_outcomes.scaleid
scale.id
Restrict delete
gradoutc_cou2_fk
grade_outcomes.courseid
course.id
Restrict delete
gradoutc_use2_fk
grade_outcomes.usermodified
user.id
Restrict delete
localdcour_cou2_fk
local_ld_course.courseid
course.id
Restrict delete
localdcour_use2_fk
local_ld_course.userid
user.id
Restrict delete
bloczoolrepocoho_blo2_fk
block_zoola_reports_cohort.blockinstanceid
block_instances.id
Restrict delete
bloczoolrepocoho_coh2_fk
block_zoola_reports_cohort.cohortid
cohort.id
Restrict delete
localdimpologsstat_adh2_fk
local_ld_import_logs_status.adhoctaskid
task_adhoc.id
Restrict delete
qtypddmadrag_que2_fk
qtype_ddmarker_drags.questionid
question.id
Restrict delete
gradcatehist_par2_fk
grade_categories_history.parent
grade_categories.id
Restrict delete
gradcatehist_old2_fk
grade_categories_history.oldid
grade_categories.id
Restrict delete
gradcatehist_log2_fk
grade_categories_history.loggeduser
user.id
Restrict delete
gradcatehist_cou2_fk
grade_categories_history.courseid
course.id
Restrict delete
localdcourday_ldc2_fk
local_ld_course_day.ldcourseid
local_ld_course.id
Restrict delete
workelemold_wor2_fk
workshop_elements_old.workshopid
workshop.id
Restrict delete
courcomplcritcoml_use_fk
course_completion_crit_compl.userid
user.id
Restrict delete
courcomplcritcoml_cou_fk
course_completion_crit_compl.course
course.id
Restrict delete
courcomplcritcoml_cri_fk
course_completion_crit_compl.criteriaid
course_completion_criteria.id
Restrict delete
tagcorr_tag2_fk
tag_correlation.tagid
tag.id
Restrict delete
scorseqrule_sco3_fk
scorm_seq_ruleconds.scoid
scorm_scoes.id
Restrict delete
post_use2_fk
post.usermodified
user.id
Restrict delete
assifile_gra2_fk
assignfeedback_file.grade
assign_grades.id
Restrict delete
assifile_ass3_fk
assignfeedback_file.assignment
assign.id
Restrict delete
quesgaps_que2_fk
question_gapselect.questionid
question.id
Restrict delete
userpassrese_use2_fk
user_password_resets.userid
user.id
Restrict delete
feedvalu_ite4_fk
feedback_valuetmp.item
feedback_item.id
Restrict delete
feedsitemap_fee2_fk
feedback_sitecourse_map.feedbackid
feedback.id
Restrict delete
scorseqmapi_sco2_fk
scorm_seq_mapinfo.scoid
scorm_scoes.id
Restrict delete
scorseqmapi_obj2_fk
scorm_seq_mapinfo.objectiveid
scorm_seq_objective.id
Restrict delete
rolesort_rol2_fk
role_sortorder.roleid
role.id
Restrict delete
rolesort_con2_fk
role_sortorder.contextid
context.id
Restrict delete
rolesort_use2_fk
role_sortorder.userid
user.id
Restrict delete
choiopti_cho2_fk
choice_options.choiceid
choice.id
Restrict delete
lessbran_les2_fk
lesson_branch.lessonid
lesson.id
Restrict delete
lessbran_pag2_fk
lesson_branch.pageid
lesson_pages.id
Restrict delete
scorseqroll_sco3_fk
scorm_seq_rolluprule.scoid
scorm_scoes.id
Restrict delete
oautuserfielmapp_iss2_fk
oauth2_user_field_mapping.issuerid
oauth2_issuer.id
Restrict delete
authoautlinklogi_use3_fk
auth_oauth2_linked_login.usermodified
user.id
Restrict delete
authoautlinklogi_use4_fk
auth_oauth2_linked_login.userid
user.id
Restrict delete
authoautlinklogi_iss2_fk
auth_oauth2_linked_login.issuerid
oauth2_issuer.id
Restrict delete
rolecapa_mod2_fk
role_capabilities.modifierid
user.id
Restrict delete
rolecapa_con2_fk
role_capabilities.contextid
context.id
Restrict delete
rolecapa_rol2_fk
role_capabilities.roleid
role.id
Restrict delete
rolecapa_cap2_fk
role_capabilities.capability
capabilities.name
Restrict delete
survanal_sur2_fk
survey_analysis.survey
survey.id
Restrict delete
badgcritmet_use2_fk
badge_criteria_met.userid
user.id
Restrict delete
badgcritmet_cri2_fk
badge_criteria_met.critid
badge_criteria.id
Restrict delete
badgcritmet_iss2_fk
badge_criteria_met.issuedid
badge_issued.id
Restrict delete
workgrad_ass2_fk
workshop_grades.assessmentid
workshop_assessments.id
Restrict delete
qtypddma_que2_fk
qtype_ddmarker.questionid
question.id
Restrict delete
feeditem_tem2_fk
feedback_item.template
feedback_template.id
Restrict delete
feeditem_fee2_fk
feedback_item.feedback
feedback.id
Restrict delete
workasse_rev2_fk
workshop_assessments.reviewerid
user.id
Restrict delete
workasse_gra2_fk
workshop_assessments.gradinggradeoverby
user.id
Restrict delete
workasse_sub2_fk
workshop_assessments.submissionid
workshop_submissions.id
Restrict delete
enroflat_cou2_fk
enrol_flatfile.courseid
course.id
Restrict delete
enroflat_use2_fk
enrol_flatfile.userid
user.id
Restrict delete
enroflat_rol2_fk
enrol_flatfile.roleid
role.id
Restrict delete
assisubm_ass3_fk
assign_submission.assignment
assign.id
Restrict delete
survansw_sur2_fk
survey_answers.survey
survey.id
Restrict delete
survansw_que2_fk
survey_answers.question
survey_questions.id
Restrict delete
foruqueu_dis2_fk
forum_queue.discussionid
forum_discussions.id
Restrict delete
foruqueu_pos2_fk
forum_queue.postid
forum_posts.id
Restrict delete
tagarea_tag2_fk
tag_area.tagcollid
tag_coll.id
Restrict delete
backcont_use2_fk
backup_controllers.userid
user.id
Restrict delete
repoonedacce_use2_fk
repository_onedrive_access.usermodified
user.id
Restrict delete
ltitoolsett_too2_fk
lti_tool_settings.toolproxyid
lti_tool_proxies.id
Restrict delete
ltitoolsett_cou3_fk
lti_tool_settings.course
course.id
Restrict delete
ltitoolsett_cou4_fk
lti_tool_settings.coursemoduleid
lti.id
Restrict delete
assigrad_ass2_fk
assign_grades.assignment
assign.id
Restrict delete
courcate_par2_fk
course_categories.parent
course_categories.id
Restrict delete
portinstconf_ins2_fk
portfolio_instance_config.instance
portfolio_instance.id
Restrict delete
scorscoetrac_sco4_fk
scorm_scoes_track.scoid
scorm_scoes.id
Restrict delete
scorscoetrac_sco3_fk
scorm_scoes_track.scormid
scorm.id
Restrict delete
quizatte_qui2_fk
quiz_attempts.quiz
quiz.id
Restrict delete
quizatte_use2_fk
quiz_attempts.userid
user.id
Restrict delete
queshint_que2_fk
question_hints.questionid
question.id
Restrict delete
coho_con2_fk
cohort.contextid
context.id
Restrict delete
work_cou2_fk
workshop.course
course.id
Restrict delete
grougrou_gro4_fk
groupings_groups.groupid
groups.id
Restrict delete
grougrou_gro3_fk
groupings_groups.groupingid
groupings.id
Restrict delete
comptemp_com2_fk
competency_templatecomp.competencyid
competency.id
Restrict delete
comptemp_tem3_fk
competency_templatecomp.templateid
competency_template.id
Restrict delete
glosentrcate_cat2_fk
glossary_entries_categories.categoryid
glossary_categories.id
Restrict delete
glosentrcate_ent2_fk
glossary_entries_categories.entryid
glossary_entries.id
Restrict delete
rolealloswit_rol2_fk
role_allow_switch.roleid
role.id
Restrict delete
rolealloswit_all2_fk
role_allow_switch.allowswitch
role.id
Restrict delete
qtypddimdrop_que2_fk
qtype_ddimageortext_drops.questionid
question.id
Restrict delete
quescate_par2_fk
question_categories.parent
question_categories.id
Restrict delete
assifile_sub2_fk
assignsubmission_file.submission
assign_submission.id
Restrict delete
assifile_ass4_fk
assignsubmission_file.assignment
assign.id
Restrict delete
graditem_sca2_fk
grade_items.scaleid
scale.id
Restrict delete
graditem_cat2_fk
grade_items.categoryid
grade_categories.id
Restrict delete
graditem_cou2_fk
grade_items.courseid
course.id
Restrict delete
graditem_out2_fk
grade_items.outcomeid
grade_outcomes.id
Restrict delete
blocinst_par2_fk
block_instances.parentcontextid
context.id
Restrict delete
badgexte_bac2_fk
badge_external.backpackid
badge_backpack.id
Restrict delete
quesrespcoun_ana2_fk
question_response_count.analysisid
question_response_analysis.id
Restrict delete
gradgradhist_use4_fk
grade_grades_history.usermodified
user.id
Restrict delete
gradgradhist_use3_fk
grade_grades_history.userid
user.id
Restrict delete
gradgradhist_old2_fk
grade_grades_history.oldid
grade_grades.id
Restrict delete
gradgradhist_ite2_fk
grade_grades_history.itemid
grade_items.id
Restrict delete
gradgradhist_log2_fk
grade_grades_history.loggeduser
user.id
Restrict delete
gradgradhist_raw2_fk
grade_grades_history.rawscaleid
scale.id
Restrict delete
scorseqroll_rol2_fk
scorm_seq_rolluprulecond.rollupruleid
scorm_seq_rolluprule.id
Restrict delete
scorseqroll_sco4_fk
scorm_seq_rolluprulecond.scoid
scorm_scoes.id
Restrict delete
gradimpovalu_imp2_fk
grade_import_values.importer
user.id
Restrict delete
gradimpovalu_new2_fk
grade_import_values.newgradeitem
grade_import_newitem.id
Restrict delete
gradimpovalu_ite2_fk
grade_import_values.itemid
grade_items.id
Restrict delete
gradoutccour_out2_fk
grade_outcomes_courses.outcomeid
grade_outcomes.id
Restrict delete
gradoutccour_cou2_fk
grade_outcomes_courses.courseid
course.id
Restrict delete
worksubm_wor2_fk
workshop_submissions.workshopid
workshop.id
Restrict delete
worksubm_gra2_fk
workshop_submissions.gradeoverby
user.id
Restrict delete
worksubm_aut2_fk
workshop_submissions.authorid
user.id
Restrict delete
enroltilti2userresu_res2_fk
enrol_lti_lti2_user_result.resourcelinkid
enrol_lti_lti2_resource_link.id
Restrict delete
workcomm_wor2_fk
workshopform_comments.workshopid
workshop.id
Restrict delete
quesdatadefi_cat2_fk
question_dataset_definitions.category
question_categories.id
Restrict delete
file_use2_fk
files.userid
user.id
Restrict delete
file_ref2_fk
files.referencefileid
files_reference.id
Restrict delete
file_con3_fk
files.contextid
context.id
Restrict delete
wikisubw_wik2_fk
wiki_subwikis.wikiid
wiki.id
Restrict delete
quesdata_que2_fk
question_datasets.question
question.id
Restrict delete
quesdata_dat2_fk
question_datasets.datasetdefinition
question_dataset_definitions.id
Restrict delete
assiover_use2_fk
assign_overrides.userid
user.id
Restrict delete
assiover_gro2_fk
assign_overrides.groupid
groups.id
Restrict delete
assiover_ass2_fk
assign_overrides.assignid
assign.id
Restrict delete
userprivkey_use2_fk
user_private_key.userid
user.id
Restrict delete
feedcomp_fee4_fk
feedback_completedtmp.feedback
feedback.id
Restrict delete
wikilink_sub2_fk
wiki_links.subwikiid
wiki_subwikis.id
Restrict delete
wikilink_fro2_fk
wiki_links.frompageid
wiki_pages.id
Restrict delete
gradguidcrit_def2_fk
gradingform_guide_criteria.definitionid
grading_definitions.id
Restrict delete
evenqueu_use2_fk
events_queue.userid
user.id
Restrict delete
badgcrit_bad2_fk
badge_criteria.badgeid
badge.id
Restrict delete
quizsect_qui2_fk
quiz_sections.quizid
quiz.id
Restrict delete
forudige_for2_fk
forum_digests.forum
forum.id
Restrict delete
forudige_use2_fk
forum_digests.userid
user.id
Restrict delete
forusubs_for2_fk
forum_subscriptions.forum
forum.id
Restrict delete
assiusermapp_use2_fk
assign_user_mapping.userid
user.id
Restrict delete
assiusermapp_ass2_fk
assign_user_mapping.assignment
assign.id
Restrict delete
wikipage_sub2_fk
wiki_pages.subwikiid
wiki_subwikis.id
Restrict delete
worksubmold_wor2_fk
workshop_submissions_old.workshopid
workshop.id
Restrict delete
datacont_fie2_fk
data_content.fieldid
data_fields.id
Restrict delete
datacont_rec2_fk
data_content.recordid
data_records.id
Restrict delete
assieditcmnt_gra2_fk
assignfeedback_editpdf_cmnt.gradeid
assign_grades.id
Restrict delete
grou_cou4_fk
groupings.courseid
course.id
Restrict delete
rolename_con2_fk
role_names.contextid
context.id
Restrict delete
rolename_rol2_fk
role_names.roleid
role.id
Restrict delete
courcompl_use_fk
course_completions.userid
user.id
Restrict delete
courcompl_cou_fk
course_completions.course
course.id
Restrict delete
assionli_sub2_fk
assignsubmission_onlinetext.submission
assign_submission.id
Restrict delete
assionli_ass2_fk
assignsubmission_onlinetext.assignment
assign.id
Restrict delete
toolmonisubs_rul2_fk
tool_monitor_subscriptions.ruleid
tool_monitor_rules.id
Restrict delete
enroltiuser_use2_fk
enrol_lti_users.userid
user.id
Restrict delete
enroltiuser_too2_fk
enrol_lti_users.toolid
enrol_lti_tools.id
Restrict delete
gradrubrcrit_def2_fk
gradingform_rubric_criteria.definitionid
grading_definitions.id
Restrict delete
userpasshist_use2_fk
user_password_history.userid
user.id
Restrict delete
feedvalu_ite3_fk
feedback_value.item
feedback_item.id
Restrict delete
conflog_use2_fk
config_log.userid
user.id
Restrict delete
scorseqobje_sco2_fk
scorm_seq_objective.scoid
scorm_scoes.id
Restrict delete
rati_con2_fk
rating.contextid
context.id
Restrict delete
rati_use2_fk
rating.userid
user.id
Restrict delete
compmodu_com2_fk
competency_modulecomp.competencyid
competency.id
Restrict delete
compmodu_cmi2_fk
competency_modulecomp.cmid
course_modules.id
Restrict delete
graditemhist_cat2_fk
grade_items_history.categoryid
grade_categories.id
Restrict delete
graditemhist_cou2_fk
grade_items_history.courseid
course.id
Restrict delete
graditemhist_out2_fk
grade_items_history.outcomeid
grade_outcomes.id
Restrict delete
graditemhist_old2_fk
grade_items_history.oldid
grade_items.id
Restrict delete
graditemhist_log2_fk
grade_items_history.loggeduser
user.id
Restrict delete
graditemhist_sca2_fk
grade_items_history.scaleid
scale.id
Restrict delete
enroltitoolconsmap_too2_fk
enrol_lti_tool_consumer_map.toolid
enrol_lti_tools.id
Restrict delete
enroltitoolconsmap_con2_fk
enrol_lti_tool_consumer_map.consumerid
enrol_lti_lti2_consumer.id
Restrict delete
courcompcrit_min_fk
course_completion_criteria.moduleinstance
course_modules.id
Restrict delete
courcompcrit_cin_fk
course_completion_criteria.courseinstance
course.id
Restrict delete
courcompcrit_cou_fk
course_completion_criteria.course
course.id
Restrict delete
courmodu_gro2_fk
course_modules.groupingid
groupings.id
Restrict delete
courmodu_mod_fk
course_modules.module
modules.id
Restrict delete
courmodu_cou_fk
course_modules.course
course.id
Restrict delete
forupost_par2_fk
forum_posts.parent
forum_posts.id
Restrict delete
forupost_dis2_fk
forum_posts.discussion
forum_discussions.id
Restrict delete
toolrecycour_cou2_fk
tool_recyclebin_course.courseid
course.id
Restrict delete
glosalia_ent2_fk
glossary_alias.entryid
glossary_entries.id
Restrict delete
gradgrad_raw2_fk
grade_grades.rawscaleid
scale.id
Restrict delete
gradgrad_use4_fk
grade_grades.usermodified
user.id
Restrict delete
gradgrad_use3_fk
grade_grades.userid
user.id
Restrict delete
gradgrad_ite2_fk
grade_grades.itemid
grade_items.id
Restrict delete
scorscoe_sco2_fk
scorm_scoes.scorm
scorm.id
Restrict delete
chatmesscurr_cha2_fk
chat_messages_current.chatid
chat.id
Restrict delete
enroltitool_enr2_fk
enrol_lti_tools.enrolid
enrol.id
Restrict delete
enroltitool_con2_fk
enrol_lti_tools.contextid
context.id
Restrict delete
gradrubrleve_cri2_fk
gradingform_rubric_levels.criterionid
gradingform_rubric_criteria.id
Restrict delete
workaccu_wor2_fk
workshopform_accumulative.workshopid
workshop.id
Restrict delete
toolmonihist_sid2_fk
tool_monitor_history.sid
tool_monitor_subscriptions.id
Restrict delete
mnetenroenro_use2_fk
mnetservice_enrol_enrolments.userid
user.id
Restrict delete
mnetenroenro_hos2_fk
mnetservice_enrol_enrolments.hostid
mnet_host.id
Restrict delete
exteservfunc_ext2_fk
external_services_functions.externalserviceid
external_services.id
Restrict delete
taginst_con2_fk
tag_instance.contextid
context.id
Restrict delete
taginst_tag2_fk
tag_instance.tagid
tag.id
Restrict delete
userdevi_use2_fk
user_devices.userid
user.id
Restrict delete
quesddwt_que2_fk
question_ddwtos.questionid
question.id
Restrict delete
workasseold_sub2_fk
workshop_assessments_old.submissionid
workshop_submissions.id
Restrict delete
workasseold_wor2_fk
workshop_assessments_old.workshopid
workshop.id
Restrict delete
gradcate_cou2_fk
grade_categories.courseid
course.id
Restrict delete
gradcate_par2_fk
grade_categories.parent
grade_categories.id
Restrict delete
assiplugconf_ass2_fk
assign_plugin_config.assignment
assign.id
Restrict delete
quesattestep_que2_fk
question_attempt_steps.questionattemptid
question_attempts.id
Restrict delete
quesattestep_use2_fk
question_attempt_steps.userid
user.id
Restrict delete
lesspage_les2_fk
lesson_pages.lessonid
lesson.id
Restrict delete
assieditanno_gra2_fk
assignfeedback_editpdf_annot.gradeid
assign_grades.id
Restrict delete
worknume_wor2_fk
workshopform_numerrors.workshopid
workshop.id
Restrict delete
blocposi_con2_fk
block_positions.contextid
context.id
Restrict delete
blocposi_blo2_fk
block_positions.blockinstanceid
block_instances.id
Restrict delete
localdmodu_ldc2_fk
local_ld_module.ldcourseid
local_ld_course.id
Restrict delete
localdmodu_cou2_fk
local_ld_module.coursemoduleid
course_modules.id
Restrict delete
qtypmatcsubq_que2_fk
qtype_match_subquestions.questionid
question.id
Restrict delete
quesnume_que2_fk
question_numerical.question
question.id
Restrict delete
userinfodata_use_fk
user_info_data.userid
user.id
Restrict delete
userinfodata_fie_fk
user_info_data.fieldid
user_info_field.id
Restrict delete
forudisc_for2_fk
forum_discussions.forum
forum.id
Restrict delete
userinfofiel_cat_fk
user_info_field.categoryid
user_info_category.id
Restrict delete
workrubr_wor2_fk
workshopform_rubric.workshopid
workshop.id
Restrict delete
scorseqrule_rul2_fk
scorm_seq_rulecond.ruleconditionsid
scorm_seq_ruleconds.id
Restrict delete
scorseqrule_sco4_fk
scorm_seq_rulecond.scoid
scorm_scoes.id
Restrict delete
quesusag_con2_fk
question_usages.contextid
context.id
Restrict delete
chatmess_cha2_fk
chat_messages.chatid
chat.id
Restrict delete
gradarea_con2_fk
grading_areas.contextid
context.id
Restrict delete
rolecontleve_rol2_fk
role_context_levels.roleid
role.id
Restrict delete
scalhist_old2_fk
scale_history.oldid
scale.id
Restrict delete
scalhist_cou2_fk
scale_history.courseid
course.id
Restrict delete
scalhist_log2_fk
scale_history.loggeduser
user.id
Restrict delete
userenro_enr2_fk
user_enrolments.enrolid
enrol.id
Restrict delete
userenro_use2_fk
user_enrolments.userid
user.id
Restrict delete
userenro_mod2_fk
user_enrolments.modifierid
user.id
Restrict delete
lesstime_les2_fk
lesson_timer.lessonid
lesson.id
Restrict delete
qtypddimdrag_que2_fk
qtype_ddimageortext_drags.questionid
question.id
Restrict delete
localdmoduday_ldm2_fk
local_ld_module_day.ldmoduleid
local_ld_module.id
Restrict delete
roleassi_rol2_fk
role_assignments.roleid
role.id
Restrict delete
roleassi_use2_fk
role_assignments.userid
user.id
Restrict delete
roleassi_con2_fk
role_assignments.contextid
context.id
Restrict delete
portinstuser_use2_fk
portfolio_instance_user.userid
user.id
Restrict delete
portinstuser_ins2_fk
portfolio_instance_user.instance
portfolio_instance.id
Restrict delete
assicomm_ass2_fk
assignfeedback_comments.assignment
assign.id
Restrict delete
assicomm_gra2_fk
assignfeedback_comments.grade
assign_grades.id
Restrict delete
choiansw_opt2_fk
choice_answers.optionid
choice_options.id
Restrict delete
choiansw_cho2_fk
choice_answers.choiceid
choice.id
Restrict delete
groumemb_gro2_fk
groups_members.groupid
groups.id
Restrict delete
groumemb_use2_fk
groups_members.userid
user.id
Restrict delete
enroltilti2resolink_pri2_fk
enrol_lti_lti2_resource_link.primaryresourcelinkid
enrol_lti_lti2_resource_link.id
Restrict delete
enroltilti2resolink_con3_fk
enrol_lti_lti2_resource_link.contextid
enrol_lti_lti2_context.id
Restrict delete
enroltilti2resolink_con4_fk
enrol_lti_lti2_resource_link.consumerid
enrol_lti_lti2_consumer.id
Restrict delete
courcate_cat_fk
course.category
course_categories.id
Restrict delete
ques_mod2_fk
question.modifiedby
user.id
Restrict delete
ques_cre2_fk
question.createdby
user.id
Restrict delete
ques_cat2_fk
question.category
question_categories.id
Restrict delete
ques_par2_fk
question.parent
question.id
Restrict delete
qtypddmadrop_que2_fk
qtype_ddmarker_drops.questionid
question.id
Restrict delete
lessgrad_les2_fk
lesson_grades.lessonid
lesson.id
Restrict delete
workrubrold_wor2_fk
workshop_rubrics_old.workshopid
workshop.id
Restrict delete
backlogs_bac2_fk
backup_logs.backupid
backup_controllers.backupid
Restrict delete
quesansw_que2_fk
question_answers.question
question.id
Restrict delete
enroltilti2cont_con2_fk
enrol_lti_lti2_context.consumerid
enrol_lti_lti2_consumer.id
Restrict delete
workrubrleve_dim2_fk
workshopform_rubric_levels.dimensionid
workshopform_rubric.id
Restrict delete
gradoutchist_cou2_fk
grade_outcomes_history.courseid
course.id
Restrict delete
gradoutchist_log2_fk
grade_outcomes_history.loggeduser
user.id
Restrict delete
gradoutchist_sca2_fk
grade_outcomes_history.scaleid
scale.id
Restrict delete
gradoutchist_old2_fk
grade_outcomes_history.oldid
grade_outcomes.id
Restrict delete
portmahaqueu_tra2_fk
portfolio_mahara_queue.transferid
portfolio_tempdata.id
Restrict delete
oautendp_iss2_fk
oauth2_endpoint.issuerid
oauth2_issuer.id
Restrict delete
sess_use2_fk
sessions.userid
user.id
Restrict delete
quescalcopti_que2_fk
question_calculated_options.question
question.id
Restrict delete
feedcomp_fee3_fk
feedback_completed.feedback
feedback.id
Restrict delete
assiuserflag_use2_fk
assign_user_flags.userid
user.id
Restrict delete
assiuserflag_ass2_fk
assign_user_flags.assignment
assign.id
Restrict delete
gradguidcomm_def2_fk
gradingform_guide_comments.definitionid
grading_definitions.id
Restrict delete
gradsett_cou2_fk
grade_settings.courseid
course.id
Restrict delete
courformopti_cou2_fk
course_format_options.courseid
course.id
Restrict delete
logsstanlog_con2_fk
logstore_standard_log.contextid
context.id
Restrict delete
enroltilti2nonc_con2_fk
enrol_lti_lti2_nonce.consumerid
enrol_lti_lti2_consumer.id
Restrict delete
porttemp_ins2_fk
portfolio_tempdata.instance
portfolio_instance.id
Restrict delete
porttemp_use2_fk
portfolio_tempdata.userid
user.id
Restrict delete
filerefe_rep2_fk
files_reference.repositoryid
repository_instances.id
Restrict delete
courcompdefa_cou2_fk
course_completion_defaults.course
course.id
Restrict delete
courcompdefa_mod2_fk
course_completion_defaults.module
modules.id
Restrict delete
worknumemap_wor2_fk
workshopform_numerrors_map.workshopid
workshop.id
Restrict delete
blogexte_use2_fk
blog_external.userid
user.id
Restrict delete
tooluserstep_tou2_fk
tool_usertours_steps.tourid
tool_usertours_tours.id
Restrict delete
quizfeed_qui2_fk
quiz_feedback.quizid
quiz.id
Restrict delete
lessover_les2_fk
lesson_overrides.lessonid
lesson.id
Restrict delete
lessover_use2_fk
lesson_overrides.userid
user.id
Restrict delete
lessover_gro2_fk
lesson_overrides.groupid
groups.id
Restrict delete
evenqueuhand_que2_fk
events_queue_handlers.queuedeventid
events_queue.id
Restrict delete
evenqueuhand_han2_fk
events_queue_handlers.handlerid
events_handlers.id
Restrict delete
quesnumeunit_que2_fk
question_numerical_units.question
question.id
Restrict delete
quizslot_que2_fk
quiz_slots.questionid
question.id
Restrict delete
quizslot_qui2_fk
quiz_slots.quizid
quiz.id
Restrict delete
cohomemb_coh2_fk
cohort_members.cohortid
cohort.id
Restrict delete
cohomemb_use2_fk
cohort_members.userid
user.id
Restrict delete
workstocold_wor2_fk
workshop_stockcomments_old.workshopid
workshop.id
Restrict delete
quesatte_que3_fk
question_attempts.questionid
question.id
Restrict delete
quesatte_que4_fk
question_attempts.questionusageid
question_usages.id
Restrict delete
portlog_por2_fk
portfolio_log.portfolio
portfolio_instance.id
Restrict delete
portlog_use2_fk
portfolio_log.userid
user.id
Restrict delete
workcommold_wor2_fk
workshop_comments_old.workshopid
workshop.id
Restrict delete
workcommold_ass2_fk
workshop_comments_old.assessmentid
workshop_assessments.id
Restrict delete
courmoducompl_use_fk
course_modules_completion.userid
user.id
Restrict delete
courmoducompl_cou_fk
course_modules_completion.coursemoduleid
course_modules.id
Restrict delete
qtypddim_que2_fk
qtype_ddimageortext.questionid
question.id
Restrict delete
gradrubrfill_cri2_fk
gradingform_rubric_fillings.criterionid
gradingform_rubric_criteria.id
Restrict delete
gradrubrfill_ins2_fk
gradingform_rubric_fillings.instanceid
grading_instances.id
Restrict delete
gloscate_glo2_fk
glossary_categories.glossaryid
glossary.id
Restrict delete
chatuser_cha2_fk
chat_users.chatid
chat.id
Restrict delete
graddefi_are2_fk
grading_definitions.areaid
grading_areas.id
Restrict delete
graddefi_use3_fk
grading_definitions.usermodified
user.id
Restrict delete
graddefi_use4_fk
grading_definitions.usercreated
user.id
Restrict delete
gradguidfill_ins2_fk
gradingform_guide_fillings.instanceid
grading_instances.id
Restrict delete
gradguidfill_cri2_fk
gradingform_guide_fillings.criterionid
gradingform_guide_criteria.id
Restrict delete
badgmanuawar_iss3_fk
badge_manual_award.issuerid
user.id
Restrict delete
badgmanuawar_iss4_fk
badge_manual_award.issuerrole
role.id
Restrict delete
badgmanuawar_bad2_fk
badge_manual_award.badgeid
badge.id
Restrict delete
badgmanuawar_rec2_fk
badge_manual_award.recipientid
user.id
Restrict delete
quesmult_que2_fk
question_multianswer.question
question.id
Restrict delete
tag_tag2_fk
tag.tagcollid
tag_coll.id
Restrict delete
tag_use2_fk
tag.userid
user.id
Restrict delete
forudiscsubs_dis2_fk
forum_discussion_subs.discussion
forum_discussions.id
Restrict delete
forudiscsubs_use2_fk
forum_discussion_subs.userid
user.id
Restrict delete
forudiscsubs_for2_fk
forum_discussion_subs.forum
forum.id
Restrict delete
mnethost_app2_fk
mnet_host.applicationid
mnet_application.id
Restrict delete
toolrecycate_cat2_fk
tool_recyclebin_category.categoryid
course_categories.id
Restrict delete
workaggr_use2_fk
workshop_aggregations.userid
user.id
Restrict delete
workaggr_wor2_fk
workshop_aggregations.workshopid
workshop.id
Restrict delete
wikivers_pag2_fk
wiki_versions.pageid
wiki_pages.id
Restrict delete
quescalc_que2_fk
question_calculated.question
question.id
Restrict delete
rolealloassi_rol2_fk
role_allow_assign.roleid
role.id
Restrict delete
rolealloassi_all2_fk
role_allow_assign.allowassign
role.id
Restrict delete
filtacti_con2_fk
filter_active.contextid
context.id
Restrict delete
messmess_use2_fk
messageinbound_messagelist.userid
user.id
Restrict delete
enro_cou2_fk
enrol.courseid
course.id
Restrict delete
badgcritpara_cri2_fk
badge_criteria_param.critid
badge_criteria.id
Restrict delete
exteservuser_ext2_fk
external_services_users.externalserviceid
external_services.id
Restrict delete
exteservuser_use2_fk
external_services_users.userid
user.id
Restrict delete
filtconf_con2_fk
filter_config.contextid
context.id
Restrict delete
glosentr_glo2_fk
glossary_entries.glossaryid
glossary.id
Restrict delete
questrue_que2_fk
question_truefalse.question
question.id
Restrict delete
coursecomplaggrmeth_cou_fk
course_completion_aggr_methd.course
course.id
Restrict delete
assieditquic_use2_fk
assignfeedback_editpdf_quick.userid
user.id
Restrict delete
blogasso_blo2_fk
blog_association.blogid
post.id
Restrict delete
blogasso_con2_fk
blog_association.contextid
context.id
Restrict delete
toolcust_com2_fk
tool_customlang.componentid
tool_customlang_components.id
Restrict delete
enroltilti2toolprox_con2_fk
enrol_lti_lti2_tool_proxy.consumerid
enrol_lti_lti2_consumer.id
Restrict delete
extetoke_con2_fk
external_tokens.contextid
context.id
Restrict delete
extetoke_cre2_fk
external_tokens.creatorid
user.id
Restrict delete
extetoke_ext2_fk
external_tokens.externalserviceid
external_services.id
Restrict delete
extetoke_use2_fk
external_tokens.userid
user.id
Restrict delete
messdata_han2_fk
messageinbound_datakeys.handler
messageinbound_handlers.id
Restrict delete
quesattestepdata_att2_fk
question_attempt_step_data.attemptstepid
question_attempt_steps.id
Restrict delete
datafiel_dat2_fk
data_fields.dataid
data.id
Restrict delete
badgback_use2_fk
badge_backpack.userid
user.id
Restrict delete
scoraiccsess_use2_fk
scorm_aicc_session.userid
user.id
Restrict delete
scoraiccsess_sco2_fk
scorm_aicc_session.scormid
scorm.id
Restrict delete
gradinst_def2_fk
grading_instances.definitionid
grading_definitions.id
Restrict delete
gradinst_rat2_fk
grading_instances.raterid
user.id
Restrict delete
quesnumeopti_que2_fk
question_numerical_options.question
question.id
Restrict delete
rolealloover_rol2_fk
role_allow_override.roleid
role.id
Restrict delete
rolealloover_all2_fk
role_allow_override.allowoverride
role.id
Restrict delete
gradimponewi_imp2_fk
grade_import_newitem.importer
user.id
Restrict delete
workgradold_wor2_fk
workshop_grades_old.workshopid
workshop.id
Restrict delete
workgradold_ass2_fk
workshop_grades_old.assessmentid
workshop_assessments.id
Restrict delete
quizover_gro2_fk
quiz_overrides.groupid
groups.id
Restrict delete
quizover_use2_fk
quiz_overrides.userid
user.id
Restrict delete
quizover_qui2_fk
quiz_overrides.quiz
quiz.id
Restrict delete

Check Constraints

Table Constraint Name Constraint
None detected