# Constraints

### 679 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
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
datareco_use2_fk |
data_records.userid
user.id
| Restrict delete
h5plibrdepe_lib2_fk |
h5p_library_dependencies.libraryid
h5p_libraries.id
| Restrict delete
h5plibrdepe_req2_fk |
h5p_library_dependencies.requiredlibraryid
h5p_libraries.id
| Restrict delete
upgrlog_use2_fk |
upgrade_log.userid
user.id
| Restrict delete
stats_daily_erd_courseid |
stats_daily.courseid
course.id
| Restrict delete
reposche_use6_fk |
reportbuilder_schedule.usermodified
user.id
| Restrict delete
reposche_use4_fk |
reportbuilder_schedule.userviewas
user.id
| Restrict delete
reposche_use5_fk |
reportbuilder_schedule.usercreated
user.id
| Restrict delete
reposche_rep2_fk |
reportbuilder_schedule.reportid
reportbuilder_report.id
| Restrict delete
commcust_com2_fk |
communication_customlink.commid
communication.id
| Restrict delete
stats_monthly_erd_courseid |
stats_monthly.courseid
course.id
| Restrict delete
badgissu_bad2_fk |
badge_issued.badgeid
badge.id
| Restrict delete
badgissu_use2_fk |
badge_issued.userid
user.id
| Restrict delete
repofilt_use3_fk |
reportbuilder_filter.usercreated
user.id
| Restrict delete
repofilt_use4_fk |
reportbuilder_filter.usermodified
user.id
| Restrict delete
repofilt_rep2_fk |
reportbuilder_filter.reportid
reportbuilder_report.id
| Restrict delete
scoratte_sco2_fk |
scorm_attempt.scormid
scorm.id
| Restrict delete
scoratte_use2_fk |
scorm_attempt.userid
user.id
| Restrict delete
fileconv_sou2_fk |
file_conversion.sourcefileid
files.id
| Restrict delete
fileconv_use2_fk |
file_conversion.usermodified
user.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
compcour_use5_fk |
competency_coursecomp.usermodified
user.id
| Restrict delete
enroltiresolink_lti3_fk |
enrol_lti_resource_link.ltideploymentid
enrol_lti_deployment.id
| Restrict delete
enroltiresolink_lti4_fk |
enrol_lti_resource_link.lticontextid
enrol_lti_context.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
quesbankentr_own2_fk |
question_bank_entries.ownerid
user.id
| Restrict delete
quesbankentr_que2_fk |
question_bank_entries.questioncategoryid
question_categories.id
| Restrict delete
user_preferences_erd_userid |
user_preferences.userid
user.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
stats_user_daily_erd_courseid |
stats_user_daily.courseid
course.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
analmode_use2_fk |
analytics_models.usermodified
user.id
| Restrict delete
imscp_erd_courseid |
imscp.course
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
evensubs_cou2_fk |
event_subscriptions.courseid
course.id
| Restrict delete
evensubs_use2_fk |
event_subscriptions.userid
user.id
| Restrict delete
enroltilti2sharkey_res_fk |
enrol_lti_lti2_share_key.resourcelinkid
enrol_lti_lti2_resource_link.id
| Restrict delete
course_completion_crit_compl_erd_course_id |
course_completion_crit_compl.course
course.id
| Restrict delete
assiallomark_stu2_fk |
assign_allocated_marker.student
user.id
| Restrict delete
assiallomark_mar2_fk |
assign_allocated_marker.marker
user.id
| Restrict delete
assiallomark_ass2_fk |
assign_allocated_marker.assignment
assign.id
| Restrict delete
tagcorr_tag2_fk |
tag_correlation.tagid
tag.id
| Restrict delete
ltitypecate_typ2_fk |
lti_types_categories.typeid
lti_types.id
| Restrict delete
ltitypecate_cat2_fk |
lti_types_categories.categoryid
course_categories.id
| Restrict delete
scorseqrule_sco3_fk |
scorm_seq_ruleconds.scoid
scorm_scoes.id
| Restrict delete
post_use2_fk |
post.usermodified
user.id
| Restrict delete
post_cou3_fk |
post.courseid
course.id
| Restrict delete
post_cou4_fk |
post.coursemoduleid
course_modules.id
| Restrict delete
quesgaps_que2_fk |
question_gapselect.questionid
question.id
| Restrict delete
assifile_gra2_fk |
assignfeedback_file.grade
assign_grades.id
| Restrict delete
assifile_ass2_fk |
assignfeedback_file.assignment
assign.id
| Restrict delete
quizoverregr_queslo2_fk |
quiz_overview_regrades.questionusageid
question_attempts.questionusageid
| Restrict delete
userpassrese_use2_fk |
user_password_resets.userid
user.id
| Restrict delete
qtypshoropti_que_fk |
qtype_shortanswer_options.questionid
question.id
| Restrict delete
feedvalu_ite5_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
quizgraditem_qui2_fk |
quiz_grade_items.quizid
quiz.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
repoaudi_use4_fk |
reportbuilder_audience.usermodified
user.id
| Restrict delete
repoaudi_use3_fk |
reportbuilder_audience.usercreated
user.id
| Restrict delete
repoaudi_rep2_fk |
reportbuilder_audience.reportid
reportbuilder_report.id
| Restrict delete
aiactiregi_use2_fk |
ai_action_register.userid
user.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
scorseqroll_sco3_fk |
scorm_seq_rolluprule.scoid
scorm_scoes.id
| Restrict delete
custdata_fie2_fk |
customfield_data.fieldid
customfield_field.id
| Restrict delete
custdata_con2_fk |
customfield_data.contextid
context.id
| Restrict delete
wiki_locks_erd_wikipageid |
wiki_locks.pageid
wiki_pages.id
| Restrict delete
oautuserfielmapp_use2_fk |
oauth2_user_field_mapping.usermodified
user.id
| Restrict delete
oautuserfielmapp_iss2_fk |
oauth2_user_field_mapping.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
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
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
repocolu_use4_fk |
reportbuilder_column.usermodified
user.id
| Restrict delete
repocolu_rep2_fk |
reportbuilder_column.reportid
reportbuilder_report.id
| Restrict delete
repocolu_use3_fk |
reportbuilder_column.usercreated
user.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
infefile_use2_fk |
infected_files.userid
user.id
| Restrict delete
comptemp_use4_fk |
competency_template.usermodified
user.id
| Restrict delete
comptemp_con2_fk |
competency_template.contextid
context.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
grade_letters_erd_context |
grade_letters.contextid
context.id
| Restrict delete
paygpayp_pay_fk |
paygw_paypal.paymentid
payments.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
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
tooldatactxlctx_con2_fk |
tool_dataprivacy_ctxlst_ctx.contextlistid
tool_dataprivacy_contextlist.id
| Restrict delete
repoonedacce_use2_fk |
repository_onedrive_access.usermodified
user.id
| Restrict delete
h5p_mai2_fk |
h5p.mainlibraryid
h5p_libraries.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
user_lastaccess_erd_user_id |
user_lastaccess.userid
user.id
| Restrict delete
user_lastaccess_erd_userid |
user_lastaccess.userid
user.id
| Restrict delete
forugrad_for2_fk |
forum_grades.forum
forum.id
| Restrict delete
scorscoevalu_att2_fk |
scorm_scoes_value.attemptid
scorm_attempt.id
| Restrict delete
scorscoevalu_ele2_fk |
scorm_scoes_value.elementid
scorm_element.id
| Restrict delete
scorscoevalu_sco2_fk |
scorm_scoes_value.scoid
scorm_scoes.id
| Restrict delete
badgbackoaut_iss2_fk |
badge_backpack_oauth2.issuerid
oauth2_issuer.id
| Restrict delete
badgbackoaut_use3_fk |
badge_backpack_oauth2.usermodified
user.id
| Restrict delete
badgbackoaut_use4_fk |
badge_backpack_oauth2.userid
user.id
| Restrict delete
badgbackoaut_ext2_fk |
badge_backpack_oauth2.externalbackpackid
badge_external_backpack.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
backup_courses_erd_courseid |
backup_courses.courseid
course.id
| Restrict delete
oautsystacco_iss_fk |
oauth2_system_account.issuerid
oauth2_issuer.id
| Restrict delete
oautsystacco_use2_fk |
oauth2_system_account.usermodified
user.id
| Restrict delete
queshint_que2_fk |
question_hints.questionid
question.id
| Restrict delete
coho_con2_fk |
cohort.contextid
context.id
| Restrict delete
paymacco_con2_fk |
payment_accounts.contextid
context.id
| Restrict delete
work_cou2_fk |
workshop.course
course.id
| Restrict delete
quesstat_que2_fk |
question_statistics.questionid
question.id
| Restrict delete
question_statistics_erd_question_id |
question_statistics.questionid
question.id
| Restrict delete
h5paatte_h5p2_fk |
h5pactivity_attempts.h5pactivityid
h5pactivity.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
mnetsess_mne2_fk |
mnet_session.mnethostid
mnet_host.id
| Restrict delete
mnetsess_use2_fk |
mnet_session.userid
user.id
| Restrict delete
mnet_session_erd_userid |
mnet_session.userid
user.id
| Restrict delete
comptemp_com2_fk |
competency_templatecomp.competencyid
competency.id
| Restrict delete
comptemp_tem2_fk |
competency_templatecomp.templateid
competency_template.id
| Restrict delete
comptemp_use6_fk |
competency_templatecomp.usermodified
user.id
| Restrict delete
competency_templatecomp_erd_competency |
competency_templatecomp.competencyid
competency.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
badgexteiden_sit2_fk |
badge_external_identifier.sitebackpackid
badge_backpack.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
tooldatarqstctxl_req2_fk |
tool_dataprivacy_rqst_ctxlst.requestid
tool_dataprivacy_request.id
| Restrict delete
tooldatarqstctxl_con2_fk |
tool_dataprivacy_rqst_ctxlst.contextlistid
tool_dataprivacy_contextlist.id
| Restrict delete
assifile_sub2_fk |
assignsubmission_file.submission
assign_submission.id
| Restrict delete
assifile_ass5_fk |
assignsubmission_file.assignment
assign.id
| Restrict delete
taskadho_use2_fk |
task_adhoc.userid
user.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
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
contcont_con2_fk |
contentbank_content.contextid
context.id
| Restrict delete
contcont_use3_fk |
contentbank_content.usermodified
user.id
| Restrict delete
contcont_use4_fk |
contentbank_content.usercreated
user.id
| Restrict delete
book_chapters_erd_book_id |
book_chapters.bookid
book.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
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
quesrespanal_que2_fk |
question_response_analysis.questionid
question.id
| Restrict delete
mnet_service2rpc_erd_mnet_serviceid |
mnet_service2rpc.serviceid
mnet_service.id
| Restrict delete
toolbriccachacts_cou2_fk |
tool_brickfield_cache_acts.courseid
course.id
| Restrict delete
scorseqroll_rol2_fk |
scorm_seq_rolluprulecond.rollupruleid
scorm_seq_rolluprule.id
| Restrict delete
scorseqroll_sco5_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
gradimpovalu_use2_fk |
grade_import_values.userid
user.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
assimark_gra2_fk |
assign_mark.gradeid
assign_grades.id
| Restrict delete
assimark_ass2_fk |
assign_mark.assignment
assign.id
| Restrict delete
assimark_mar2_fk |
assign_mark.marker
user.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
scal_use2_fk |
scale.userid
user.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
gradduedrule_use2_fk |
gradepenalty_duedate_rule.usermodified
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
compuser_use8_fk |
competency_usercompcourse.usermodified
user.id
| Restrict delete
competency_usercompcourse_erd_competency |
competency_usercompcourse.competencyid
competency.id
| Restrict delete
toolbriccachchec_cou2_fk |
tool_brickfield_cache_check.courseid
course.id
| Restrict delete
enroltidepl_pla2_fk |
enrol_lti_deployment.platformid
enrol_lti_app_registration.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
h5paatteresu_att2_fk |
h5pactivity_attempts_results.attemptid
h5pactivity_attempts.id
| Restrict delete
userprivkey_use2_fk |
user_private_key.userid
user.id
| Restrict delete
h5pa_cou2_fk |
h5pactivity.course
course.id
| Restrict delete
feedcomp_fee5_fk |
feedback_completedtmp.feedback
feedback.id
| Restrict delete
custshar_use2_fk |
customfield_shared.usermodified
user.id
| Restrict delete
custshar_cat2_fk |
customfield_shared.categoryid
customfield_category.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
quizsebquiz_cmi_fk |
quizaccess_seb_quizsettings.cmid
course_modules.id
| Restrict delete
quizsebquiz_qui_fk |
quizaccess_seb_quizsettings.quizid
quiz.id
| Restrict delete
quizsebquiz_tem2_fk |
quizaccess_seb_quizsettings.templateid
quizaccess_seb_template.id
| Restrict delete
quizsebquiz_use2_fk |
quizaccess_seb_quizsettings.usermodified
user.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
repouserfilt_rep2_fk |
reportbuilder_user_filter.reportid
reportbuilder_report.id
| Restrict delete
repouserfilt_use3_fk |
reportbuilder_user_filter.usercreated
user.id
| Restrict delete
repouserfilt_use4_fk |
reportbuilder_user_filter.usermodified
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
enrolticont_lti2_fk |
enrol_lti_context.ltideploymentid
enrol_lti_deployment.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_use3_fk |
competency_coursecompsetting.usermodified
user.id
| Restrict delete
compcour_cou2_fk |
competency_coursecompsetting.courseid
course.id
| Restrict delete
qtypordeopti_que_fk |
qtype_ordering_options.questionid
question.id
| Restrict delete
paymgate_acc2_fk |
payment_gateways.accountid
payment_accounts.id
| Restrict delete
toolbricerro_res2_fk |
tool_brickfield_errors.resultid
tool_brickfield_results.id
| Restrict delete
message_popup_erd_message_id |
message_popup.messageid
message.id
| Restrict delete
repository_instance_config_erd_repository_instance |
repository_instance_config.instanceid
repository_instances.id
| Restrict delete
lti_types_config_erd_ltiid |
lti_types_config.typeid
lti.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_cou5_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
quesrefe_usi2_fk |
question_references.usingcontextid
context.id
| Restrict delete
quesrefe_que2_fk |
question_references.questionbankentryid
question_bank_entries.id
| Restrict delete
toolmfaauth_use2_fk |
tool_mfa_auth.userid
user.id
| Restrict delete
compuser_use12_fk |
competency_userevidence.usermodified
user.id
| Restrict delete
competency_userevidence_erd_competency_usercomp |
competency_userevidence.userid
user.id
| Restrict delete
course_completions_erd_course_id |
course_completions.course
course.id
| Restrict delete
smsmess_gat2_fk |
sms_messages.gatewayid
sms_gateways.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
paym_use2_fk |
payments.userid
user.id
| Restrict delete
paym_acc2_fk |
payments.accountid
payment_accounts.id
| Restrict delete
enroltiuser_lti2_fk |
enrol_lti_users.ltideploymentid
enrol_lti_deployment.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
userpasshist_use2_fk |
user_password_history.userid
user.id
| Restrict delete
gradrubrcrit_def2_fk |
gradingform_rubric_criteria.definitionid
grading_definitions.id
| Restrict delete
feedvalu_ite3_fk |
feedback_value.item
feedback_item.id
| Restrict delete
conflog_use2_fk |
config_log.userid
user.id
| Restrict delete
compfram_con2_fk |
competency_framework.contextid
context.id
| Restrict delete
compfram_use2_fk |
competency_framework.usermodified
user.id
| Restrict delete
compfram_sca2_fk |
competency_framework.scaleid
scale.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_sca2_fk |
rating.scaleid
scale.id
| Restrict delete
rati_use2_fk |
rating.userid
user.id
| Restrict delete
my_pages_erd_userid |
my_pages.userid
user.id
| Restrict delete
compmodu_use2_fk |
competency_modulecomp.usermodified
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
h5plibrcach_lib2_fk |
h5p_libraries_cachedassets.libraryid
h5p_libraries.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
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
glosalia_ent2_fk |
glossary_alias.entryid
glossary_entries.id
| Restrict delete
stats_user_weekly_erd_courseid |
stats_user_weekly.courseid
course.id
| Restrict delete
scorscoe_sco2_fk |
scorm_scoes.scorm
scorm.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
workaccu_wor2_fk |
workshopform_accumulative.workshopid
workshop.id
| Restrict delete
gradrubrleve_cri2_fk |
gradingform_rubric_levels.criterionid
gradingform_rubric_criteria.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
compuser_use6_fk |
competency_usercomp.usermodified
user.id
| Restrict delete
toolbriccont_are2_fk |
tool_brickfield_content.areaid
tool_brickfield_areas.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
h5pcontlibr_h5p2_fk |
h5p_contents_libraries.h5pid
h5p.id
| Restrict delete
h5pcontlibr_lib2_fk |
h5p_contents_libraries.libraryid
h5p_libraries.id
| Restrict delete
competency_erd_competency_framework |
competency.competencyframeworkid
competency_framework.id
| Restrict delete
comp_sca2_fk |
competency.scaleid
scale.id
| Restrict delete
comp_use2_fk |
competency.usermodified
user.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
quessetrefe_que2_fk |
question_set_references.questionscontextid
context.id
| Restrict delete
quessetrefe_usi2_fk |
question_set_references.usingcontextid
context.id
| Restrict delete
assiplugconf_ass2_fk |
assign_plugin_config.assignment
assign.id
| Restrict delete
tool_cohortroles_erd_cohort |
tool_cohortroles.cohortid
cohort.id
| Restrict delete
subs_cou2_fk |
subsection.course
course.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
authltilinklogi_use2_fk |
auth_lti_linked_login.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
toolbricarea_cou2_fk |
tool_brickfield_areas.courseid
course.id
| Restrict delete
toolbricarea_cat2_fk |
tool_brickfield_areas.categoryid
course_categories.id
| Restrict delete
toolbricarea_cmi2_fk |
tool_brickfield_areas.cmid
course_modules.id
| Restrict delete
toolbricarea_con2_fk |
tool_brickfield_areas.contextid
context.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
qban_cou2_fk |
qbank.course
course.id
| Restrict delete
label_erd_courseid |
label.course
course.id
| Restrict delete
analusedanal_mod2_fk |
analytics_used_analysables.modelid
analytics_models.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_use2_fk |
forum_discussions.usermodified
user.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
workshopform_rubric_erd_config_workshopid |
workshopform_rubric.workshopid
workshop.id
| Restrict delete
scorseqrule_rul2_fk |
scorm_seq_rulecond.ruleconditionsid
scorm_seq_ruleconds.id
| Restrict delete
scorseqrule_sco5_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
toolmonieven_con4_fk |
tool_monitor_events.contextinstanceid
context.instanceid
| Restrict delete
toolmonieven_con3_fk |
tool_monitor_events.contextid
context.id
| Restrict delete
toolmonieven_cou2_fk |
tool_monitor_events.courseid
course.id
| Restrict delete
scalhist_use2_fk |
scale_history.userid
user.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
gradarea_con2_fk |
grading_areas.contextid
context.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
stats_user_monthly_erd_courseid |
stats_user_monthly.courseid
course.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
choiansw_opt2_fk |
choice_answers.optionid
choice_options.id
| Restrict delete
choiansw_cho2_fk |
choice_answers.choiceid
choice.id
| Restrict delete
assicomm_ass2_fk |
assignfeedback_comments.assignment
assign.id
| Restrict delete
assicomm_gra2_fk |
assignfeedback_comments.grade
assign_grades.id
| Restrict delete
badgexteback_oau2_fk |
badge_external_backpack.oauth2_issuerid
oauth2_issuer.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
cour_ori2_fk |
course.originalcourseid
course.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_par2_fk |
question.parent
question.id
| Restrict delete
commuser_use2_fk |
communication_user.userid
user.id
| Restrict delete
commuser_com2_fk |
communication_user.commid
communication.id
| Restrict delete
stats_weekly_erd_courseid |
stats_weekly.courseid
course.id
| Restrict delete
qtypddmadrop_que2_fk |
qtype_ddmarker_drops.questionid
question.id
| Restrict delete
lessgrad_les2_fk |
lesson_grades.lessonid
lesson.id
| Restrict delete
toolmfasecr_use2_fk |
tool_mfa_secrets.userid
user.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
bigbreco_big2_fk |
bigbluebuttonbn_recordings.bigbluebuttonbnid
bigbluebuttonbn.id
| Restrict delete
bigbreco_use2_fk |
bigbluebuttonbn_recordings.usermodified
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
courpubl_cou2_fk |
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
book_cou2_fk |
book.course
course.id
| Restrict delete
oautendp_iss2_fk |
oauth2_endpoint.issuerid
oauth2_issuer.id
| Restrict delete
oautendp_use2_fk |
oauth2_endpoint.usermodified
user.id
| Restrict delete
competency_userevidencecomp_erd_competency |
competency_userevidencecomp.competencyid
competency.id
| Restrict delete
compuser_use14_fk |
competency_userevidencecomp.usermodified
user.id
| Restrict delete
analmodelog_use2_fk |
analytics_models_log.usermodified
user.id
| Restrict delete
analmodelog_mod2_fk |
analytics_models_log.modelid
analytics_models.id
| Restrict delete
sess_use2_fk |
sessions.userid
user.id
| Restrict delete
quescalcopti_que2_fk |
question_calculated_options.question
question.id
| Restrict delete
repoinst_con2_fk |
repository_instances.contextid
context.id
| Restrict delete
repoinst_use2_fk |
repository_instances.userid
user.id
| Restrict delete
feedcomp_cou2_fk |
feedback_completed.courseid
course.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_use2_fk |
logstore_standard_log.userid
user.id
| Restrict delete
logsstanlog_con2_fk |
logstore_standard_log.contextid
context.id
| Restrict delete
logsstanlog_rea2_fk |
logstore_standard_log.realuserid
user.id
| Restrict delete
logsstanlog_cou2_fk |
logstore_standard_log.courseid
course.id
| Restrict delete
logsstanlog_rel2_fk |
logstore_standard_log.relateduserid
user.id
| Restrict delete
shor_use2_fk |
shortlink.userid
user.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
toolbricresu_con2_fk |
tool_brickfield_results.contentid
tool_brickfield_content.id
| Restrict delete
toolbricresu_che2_fk |
tool_brickfield_results.checkid
tool_brickfield_checks.id
| Restrict delete
mnet_log_erd_mnetid |
mnet_log.hostid
mnet_host.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
tasklog_use2_fk |
task_log.userid
user.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
oautrefrtoke_iss2_fk |
oauth2_refresh_token.issuerid
oauth2_issuer.id
| Restrict delete
oautrefrtoke_use2_fk |
oauth2_refresh_token.userid
user.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_qui3_fk |
quiz_slots.quizid
quiz.id
| Restrict delete
quizslot_qui4_fk |
quiz_slots.quizgradeitemid
quiz_grade_items.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
portlog_tem2_fk |
portfolio_log.tempdataid
portfolio_tempdata.id
| Restrict delete
course_modules_completion_erd_course_modules |
course_modules_completion.coursemoduleid
course_modules.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
quesvers_que3_fk |
question_versions.questionbankentryid
question_bank_entries.id
| Restrict delete
quesvers_que4_fk |
question_versions.questionid
question.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
compplan_use3_fk |
competency_plan.usermodified
user.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
toolbricsumm_cou2_fk |
tool_brickfield_summary.courseid
course.id
| Restrict delete
compuser_use10_fk |
competency_usercompplan.usermodified
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
messairndevi_use_fk |
message_airnotifier_devices.userdeviceid
user_devices.id
| Restrict delete
forum_track_prefs_erd_forum_id |
forum_track_prefs.userid
forum.id
| Restrict delete
workaggr_use2_fk |
workshop_aggregations.userid
user.id
| Restrict delete
workaggr_wor2_fk |
workshop_aggregations.workshopid
workshop.id
| Restrict delete
aipoliregi_use_fk |
ai_policy_register.userid
user.id
| Restrict delete
wikivers_pag2_fk |
wiki_versions.pageid
wiki_pages.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
quescalc_que2_fk |
question_calculated.question
question.id
| Restrict delete
messmess_use2_fk |
messageinbound_messagelist.userid
user.id
| Restrict delete
filtacti_con2_fk |
filter_active.contextid
context.id
| Restrict delete
enro_rol2_fk |
enrol.roleid
role.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
comptemp_use8_fk |
competency_templatecohort.usermodified
user.id
| Restrict delete
folder_erd_courseid |
folder.course
course.id
| Restrict delete
compevid_act2_fk |
competency_evidence.actionuserid
user.id
| Restrict delete
compevid_con2_fk |
competency_evidence.contextid
context.id
| Restrict delete
competency_evidence_erd_competency_usercomp |
competency_evidence.usercompetencyid
competency_usercomp.id
| Restrict delete
compevid_use2_fk |
competency_evidence.usermodified
user.id
| Restrict delete
compplan_use5_fk |
competency_plancomp.usermodified
user.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
comprela_com2_fk |
competency_relatedcomp.competencyid
competency.id
| Restrict delete
comprela_rel2_fk |
competency_relatedcomp.relatedcompetencyid
competency.id
| Restrict delete
competency_relatedcomp_erd_competency |
competency_relatedcomp.competencyid
competency.id
| Restrict delete
comprela_use2_fk |
competency_relatedcomp.usermodified
user.id
| Restrict delete
matrroom_com2_fk |
matrix_room.commid
communication.id
| Restrict delete
reporepo_use3_fk |
reportbuilder_report.usercreated
user.id
| Restrict delete
reporepo_con2_fk |
reportbuilder_report.contextid
context.id
| Restrict delete
reporepo_use4_fk |
reportbuilder_report.usermodified
user.id
| Restrict delete
glosentr_glo2_fk |
glossary_entries.glossaryid
glossary.id
| Restrict delete
enroltiuserresolink_lti2_fk |
enrol_lti_user_resource_link.ltiuserid
enrol_lti_users.id
| Restrict delete
enroltiuserresolink_res2_fk |
enrol_lti_user_resource_link.resourcelinkid
enrol_lti_resource_link.id
| Restrict delete
block_rss_client_erd_userid |
block_rss_client.userid
user.id
| Restrict delete
questrue_que2_fk |
question_truefalse.question
question.id
| Restrict delete
comm_con2_fk |
communication.contextid
context.id
| Restrict delete
lti_erd_lti_types_id |
lti.typeid
lti_types.id
| Restrict delete
quizsebtemp_use2_fk |
quizaccess_seb_template.usermodified
user.id
| Restrict delete
course_completion_aggr_methd_erd_course_id |
course_completion_aggr_methd.course
course.id
| Restrict delete
blogasso_blo2_fk |
blog_association.blogid
post.id
| Restrict delete
blogasso_con2_fk |
blog_association.contextid
context.id
| Restrict delete
assieditquic_use2_fk |
assignfeedback_editpdf_quick.userid
user.id
| Restrict delete
bbbesimp_big_fk |
bbbext_simple.bigbluebuttonbnid
bigbluebuttonbn.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_use2_fk |
oauth2_access_token.usermodified
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
tooldatapurp_pur2_fk |
tool_dataprivacy_purposerole.purposeid
tool_dataprivacy_purpose.id
| Restrict delete
tooldatapurp_rol2_fk |
tool_dataprivacy_purposerole.roleid
role.id
| Restrict delete
tooldatapurp_use2_fk |
tool_dataprivacy_purposerole.usermodified
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
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
workshopform_rubric_config_erd_workshopid |
workshopform_rubric_config.workshopid
workshop.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
--- | --- | ---