Constraints

496 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
quizgrad_qui2_fk
quiz_grades.quiz
quiz.id
Restrict delete
block_community_erd_user_id
block_community.userid
user.id
Restrict delete
grou_cou3_fk
groups.courseid
course.id
Restrict delete
toolpoliacce_pol2_fk
tool_policy_acceptances.policyversionid
tool_policy_versions.id
Restrict delete
toolpoliacce_use3_fk
tool_policy_acceptances.userid
user.id
Restrict delete
toolpoliacce_use4_fk
tool_policy_acceptances.usermodified
user.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
badgissu_bad2_fk
badge_issued.badgeid
badge.id
Restrict delete
badgissu_use2_fk
badge_issued.userid
user.id
Restrict delete
assisubm_ass6_fk
assignment_submissions.assignment
assignment.id
Restrict delete
fileconv_sou2_fk
file_conversion.sourcefileid
files.id
Restrict delete
fileconv_des2_fk
file_conversion.destfileid
files.id
Restrict delete
compcour_cou4_fk
competency_coursecomp.courseid
course.id
Restrict delete
compcour_com2_fk
competency_coursecomp.competencyid
competency.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
user_preferences_erd_user_id
user_preferences.userid
user.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
qtypessaopti_que_fk
qtype_essay_options.questionid
question.id
Restrict delete
messcont_use2_fk
message_contacts.userid
user.id
Restrict delete
message_contacts_erd_user_id
message_contacts.userid
user.id
Restrict delete
messcont_con2_fk
message_contacts.contactid
user.id
Restrict delete
messconvacti_con2_fk
message_conversation_actions.conversationid
message_conversations.id
Restrict delete
messconvacti_use2_fk
message_conversation_actions.userid
user.id
Restrict delete
qtyprandopti_que_fk
qtype_randomsamatch_options.questionid
question.id
Restrict delete
qtypddmadrag_que2_fk
qtype_ddmarker_drags.questionid
question.id
Restrict delete
tooldatactxi_pur2_fk
tool_dataprivacy_ctxinstance.purposeid
tool_dataprivacy_purpose.id
Restrict delete
tooldatactxi_con_fk
tool_dataprivacy_ctxinstance.contextid
context.id
Restrict delete
tooldatactxi_cat2_fk
tool_dataprivacy_ctxinstance.categoryid
tool_dataprivacy_category.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
rolealloview_rol2_fk
role_allow_view.roleid
role.id
Restrict delete
rolealloview_all2_fk
role_allow_view.allowview
role.id
Restrict delete
enroltilti2sharkey_res_fk
enrol_lti_lti2_share_key.resourcelinkid
enrol_lti_lti2_resource_link.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_ass2_fk
assignfeedback_file.assignment
assign.id
Restrict delete
quesgaps_que2_fk
question_gapselect.questionid
question.id
Restrict delete
quizoverregr_queslo2_fk
quiz_overview_regrades.questionusageid
quiz_overview_regrades.slot
question_attempts.questionusageid
question_attempts.slot
Restrict delete
qtypshoropti_que_fk
qtype_shortanswer_options.questionid
question.id
Restrict delete
userpassrese_use2_fk
user_password_resets.userid
user.id
Restrict delete
feedvalu_ite6_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
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
analindicalc_con2_fk
analytics_indicator_calc.contextid
context.id
Restrict delete
messpopunoti_not2_fk
message_popup_notifications.notificationid
notifications.id
Restrict delete
custdata_fie2_fk
customfield_data.fieldid
customfield_field.id
Restrict delete
custdata_con2_fk
customfield_data.contextid
context.id
Restrict delete
scorseqroll_sco3_fk
scorm_seq_rolluprule.scoid
scorm_scoes.id
Restrict delete
wiki_locks_erd_wikipageid
wiki_locks.pageid
wiki_pages.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
analtraisamp_mod2_fk
analytics_train_samples.modelid
analytics_models.id
Restrict delete
assisubm_ass2_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
analpred_mod2_fk
analytics_predictions.modelid
analytics_models.id
Restrict delete
analpred_con2_fk
analytics_predictions.contextid
context.id
Restrict delete
ltisgrad_gracou2_fk
ltiservice_gradebookservices.gradeitemid
grade_items.id
Restrict delete
ltisgrad_lti2_fk
ltiservice_gradebookservices.ltilinkid
lti.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_typ2_fk
lti_tool_settings.typeid
lti_types.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
course_categories_erd_course_id
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
user_lastaccess_erd_user_id
user_lastaccess.userid
user.id
Restrict delete
workbestsett_wor_fk
workshopeval_best_settings.workshopid
workshop.id
Restrict delete
quizatte_uni_fk
quiz_attempts.uniqueid
question_usages.id
Restrict delete
quizatte_qui2_fk
quiz_attempts.quiz
quiz.id
Restrict delete
quizatte_use2_fk
quiz_attempts.userid
user.id
Restrict delete
oautsystacco_iss_fk
oauth2_system_account.issuerid
oauth2_issuer.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
question_statistics_erd_question_id
question_statistics.questionid
question.id
Restrict delete
grougrou_gro4_fk
groupings_groups.groupid
groups.id
Restrict delete
grougrou_gro3_fk
groupings_groups.groupingid
groupings.id
Restrict delete
url_erd_courseid
url.course
course.id
Restrict delete
comptemp_com2_fk
competency_templatecomp.competencyid
competency.id
Restrict delete
comptemp_tem2_fk
competency_templatecomp.templateid
competency_template.id
Restrict delete
competency_templatecomp_erd_competency
competency_templatecomp.competencyid
competency.id
Restrict delete
badgexteiden_sit2_fk
badge_external_identifier.sitebackpackid
badge_backpack.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
enropayp_cou2_fk
enrol_paypal.courseid
course.id
Restrict delete
enropayp_ins2_fk
enrol_paypal.instanceid
enrol.id
Restrict delete
enropayp_use2_fk
enrol_paypal.userid
user.id
Restrict delete
enrol_paypal_erd_course_id
enrol_paypal.courseid
course.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
badgalig_bad2_fk
badge_alignment.badgeid
badge.id
Restrict delete
qtypddimdrop_que2_fk
qtype_ddimageortext_drops.questionid
question.id
Restrict delete
noti_use2_fk
notifications.useridto
user.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_ass6_fk
assignsubmission_file.assignment
assign.id
Restrict delete
messconvmemb_use2_fk
message_conversation_members.userid
user.id
Restrict delete
messconvmemb_con2_fk
message_conversation_members.conversationid
message_conversations.id
Restrict delete
taskadho_use2_fk
task_adhoc.userid
user.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
book_chapters_erd_book_id
book_chapters.bookid
book.id
Restrict delete
badgexte_bac2_fk
badge_external.backpackid
badge_backpack.id
Restrict delete
block_instances_erd_block_name
block_instances.blockname
block.name
Restrict delete
blocinst_par2_fk
block_instances.parentcontextid
context.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_sco6_fk
scorm_seq_rolluprulecond.scoid
scorm_scoes.id
Restrict delete
scorseqroll_rol2_fk
scorm_seq_rolluprulecond.rollupruleid
scorm_seq_rolluprule.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
even_sub2_fk
event.subscriptionid
event_subscriptions.id
Restrict delete
even_cat2_fk
event.categoryid
course_categories.id
Restrict delete
badgendo_bad2_fk
badge_endorsement.badgeid
badge.id
Restrict delete
tooldatactxe_con_fk
tool_dataprivacy_ctxexpired.contextid
context.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
analpredacti_pre2_fk
analytics_prediction_actions.predictionid
analytics_predictions.id
Restrict delete
analpredacti_use2_fk
analytics_prediction_actions.userid
user.id
Restrict delete
toolpoli_cur2_fk
tool_policy.currentversionid
tool_policy_versions.id
Restrict delete
file_use2_fk
files.userid
user.id
Restrict delete
file_ref2_fk
files.referencefileid
files_reference.id
Restrict delete
file_con2_fk
files.contextid
context.id
Restrict delete
competency_usercompcourse_erd_competency
competency_usercompcourse.competencyid
competency.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_fee6_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
message_read_erd_from_user_id
message_read.useridfrom
user.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
compcour_cou2_fk
competency_coursecompsetting.courseid
course.id
Restrict delete
message_popup_erd_message_id
message_popup.messageid
message.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_cou6_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
course_completions_erd_course_id
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
custcate_con2_fk
customfield_category.contextid
context.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
my_pages_erd_userid
my_pages.userid
user.id
Restrict delete
compmodu_com2_fk
competency_modulecomp.competencyid
competency.id
Restrict delete
competency_modulecomp_erd_competency
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
course_completion_criteria_erd_course_id
course_completion_criteria.course
course.id
Restrict delete
assieditrot_gra2_fk
assignfeedback_editpdf_rot.gradeid
assign_grades.id
Restrict delete
course_modules_erd_course_id
course_modules.course
course.id
Restrict delete
courmodu_gro2_fk
course_modules.groupingid
groupings.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
competency_usercomp_erd_competency
competency_usercomp.competencyid
competency.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
messconv_con2_fk
message_conversations.contextid
context.id
Restrict delete
mess_con2_fk
messages.conversationid
message_conversations.id
Restrict delete
mess_use2_fk
messages.useridfrom
user.id
Restrict delete
competency_erd_competency_framework
competency.competencyframeworkid
competency_framework.id
Restrict delete
resource_erd_courseid
resource.course
course.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
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
badgrela_bad2_fk
badge_related.badgeid
badge.id
Restrict delete
badgrela_rel2_fk
badge_related.relatedbadgeid
badge.id
Restrict delete
tooldatarequ_dpo2_fk
tool_dataprivacy_request.dpo
user.id
Restrict delete
tooldatarequ_req2_fk
tool_dataprivacy_request.requestedby
user.id
Restrict delete
tooldatarequ_use3_fk
tool_dataprivacy_request.userid
user.id
Restrict delete
tooldatarequ_use4_fk
tool_dataprivacy_request.usermodified
user.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
toolpolivers_pol2_fk
tool_policy_versions.policyid
tool_policy.id
Restrict delete
toolpolivers_use2_fk
tool_policy_versions.usermodified
user.id
Restrict delete
qtypmatcsubq_que2_fk
qtype_match_subquestions.questionid
question.id
Restrict delete
custfiel_cat2_fk
customfield_field.categoryid
customfield_category.id
Restrict delete
quesnume_que2_fk
question_numerical.question
question.id
Restrict delete
user_info_data_erd_userid
user_info_data.userid
user.id
Restrict delete
user_info_data_erd_user_id
user_info_data.userid
user.id
Restrict delete
label_erd_courseid
label.course
course.id
Restrict delete
analusedanal_mod2_fk
analytics_used_analysables.modelid
analytics_models.id
Restrict delete
quizslottags_slo2_fk
quiz_slot_tags.slotid
quiz_slots.id
Restrict delete
quizslottags_tag2_fk
quiz_slot_tags.tagid
tag.id
Restrict delete
forum_read_erd_post_id
forum_read.postid
forum_posts.id
Restrict delete
forum_read_erd_forum_id
forum_read.forumid
forum.id
Restrict delete
forum_read_erd_discussions_id
forum_read.discussionid
forum_discussions.id
Restrict delete
forudisc_for2_fk
forum_discussions.forum
forum.id
Restrict delete
user_info_field
user_info_field.categoryid
user_info_category.id
Restrict delete
page_erd_courseid
page.course
course.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_sco6_fk
scorm_seq_rulecond.scoid
scorm_scoes.id
Restrict delete
wiki_synonyms_erd_subwikiid
wiki_synonyms.subwikiid
wiki_subwikis.id
Restrict delete
wiki_synonyms_erd_pageid
wiki_synonyms.pageid
wiki_pages.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
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
rolecontleve_rol2_fk
role_context_levels.roleid
role.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
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
course_erd_category_id
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
backlogs_bac2_fk
backup_logs.backupid
backup_controllers.backupid
Restrict delete
quesansw_que2_fk
question_answers.question
question.id
Restrict delete
messcontrequ_req2_fk
message_contact_requests.requesteduserid
user.id
Restrict delete
messcontrequ_use2_fk
message_contact_requests.userid
user.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
course_published_erd_course_id
course_published.courseid
course.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
lti_submission_erd_lti_id
lti_submission.ltiid
lti.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
analmodelog_mod2_fk
analytics_models_log.modelid
analytics_models.id
Restrict delete
competency_userevidencecomp_erd_competency
competency_userevidencecomp.competencyid
competency.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
gradsett_cou2_fk
grade_settings.courseid
course.id
Restrict delete
gradguidcomm_def2_fk
gradingform_guide_comments.definitionid
grading_definitions.id
Restrict delete
courformopti_cou2_fk
course_format_options.courseid
course.id
Restrict delete
course_sections_erd_course_id
course_sections.course
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
log_erd_userid
log.userid
user.id
Restrict delete
blocrece_use2_fk
block_recentlyaccesseditems.userid
user.id
Restrict delete
blocrece_cmi2_fk
block_recentlyaccesseditems.cmid
course_modules.id
Restrict delete
blocrece_cou2_fk
block_recentlyaccesseditems.courseid
course.id
Restrict delete
qtypmultopti_que_fk
qtype_multichoice_options.questionid
question.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
analpredsamp_mod2_fk
analytics_predict_samples.modelid
analytics_models.id
Restrict delete
quesnumeunit_que2_fk
question_numerical_units.question
question.id
Restrict delete
quizslot_que3_fk
quiz_slots.questionid
question.id
Restrict delete
quizslot_que4_fk
quiz_slots.questioncategoryid
question_categories.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
quesatte_que3_fk
question_attempts.questionid
question.id
Restrict delete
quesatte_que4_fk
question_attempts.questionusageid
question_usages.id
Restrict delete
comm_use2_fk
comments.userid
user.id
Restrict delete
portlog_por2_fk
portfolio_log.portfolio
portfolio_instance.id
Restrict delete
portlog_use2_fk
portfolio_log.userid
user.id
Restrict delete
favo_use2_fk
favourite.userid
user.id
Restrict delete
favo_con2_fk
favourite.contextid
context.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
competency_plan_erd_competency_template
competency_plan.templateid
competency_template.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
competency_usercompplan_erd_competency
competency_usercompplan.competencyid
competency.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
qtypmatcopti_que_fk
qtype_match_options.questionid
question.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
analusedfile_mod2_fk
analytics_used_files.modelid
analytics_models.id
Restrict delete
analusedfile_fil2_fk
analytics_used_files.fileid
files.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
forum_track_prefs_erd_forum_id
forum_track_prefs.userid
forum.id
Restrict delete
messairndevi_use_fk
message_airnotifier_devices.userdeviceid
user_devices.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
competency_templatecohort_erd_competency_template
competency_templatecohort.templateid
competency_template.id
Restrict delete
folder_erd_courseid
folder.course
course.id
Restrict delete
competency_evidence_erd_competency_usercomp
competency_evidence.usercompetencyid
competency_usercomp.id
Restrict delete
competency_plancomp_erd_competency
competency_plancomp.competencyid
competency.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
messuserbloc_blo2_fk
message_users_blocked.blockeduserid
user.id
Restrict delete
messuserbloc_use2_fk
message_users_blocked.userid
user.id
Restrict delete
competency_relatedcomp_erd_competency
competency_relatedcomp.competencyid
competency.id
Restrict delete
glosentr_glo2_fk
glossary_entries.glossaryid
glossary.id
Restrict delete
questrue_que2_fk
question_truefalse.question
question.id
Restrict delete
lti_erd_lti_types_id
lti.typeid
lti_types.id
Restrict delete
course_completion_aggr_methd_erd_course_id
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
oautaccetoke_iss_fk
oauth2_access_token.issuerid
oauth2_issuer.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
messemaimess_use2_fk
message_email_messages.useridto
user.id
Restrict delete
messemaimess_con2_fk
message_email_messages.conversationid
message_conversations.id
Restrict delete
messemaimess_mes2_fk
message_email_messages.messageid
messages.id
Restrict delete
searinderequ_con2_fk
search_index_requests.contextid
context.id
Restrict delete
block_recent_activity_erd_user_id
block_recent_activity.userid
user.id
Restrict delete
ltiaccetoke_typ2_fk
lti_access_tokens.typeid
lti_types.id
Restrict delete
datafiel_dat2_fk
data_fields.dataid
data.id
Restrict delete
badgback_ext2_fk
badge_backpack.externalbackpackid
badge_external_backpack.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
tooldatapurp_pur2_fk
tool_dataprivacy_purposerole.purposeid
tool_dataprivacy_purpose.id
Restrict delete
tooldatapurp_rol2_fk
tool_dataprivacy_purposerole.roleid
role.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
tooldatactxl_pur2_fk
tool_dataprivacy_ctxlevel.purposeid
tool_dataprivacy_purpose.id
Restrict delete
tooldatactxl_cat2_fk
tool_dataprivacy_ctxlevel.categoryid
tool_dataprivacy_category.id
Restrict delete
messuseracti_use2_fk
message_user_actions.userid
user.id
Restrict delete
messuseracti_mes2_fk
message_user_actions.messageid
messages.id
Restrict delete
worksche_wor_fk
workshopallocation_scheduled.workshopid
workshop.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