mdl42_erd Database

651 Foreign Key Constraints

Search:

Constraint Name

Child Column

Parent Column

Delete Rule

analindicalc_con2_fk

analytics_indicator_calc.contextid

context.id

Restrict delete

analmode_use2_fk

analytics_models.usermodified

user.id

Restrict delete

analmodelog_mod2_fk

analytics_models_log.modelid

analytics_models.id

Restrict delete

analmodelog_use2_fk

analytics_models_log.usermodified

user.id

Restrict delete

analpred_con2_fk

analytics_predictions.contextid

context.id

Restrict delete

analpred_mod2_fk

analytics_predictions.modelid

analytics_models.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

analpredsamp_mod2_fk

analytics_predict_samples.modelid

analytics_models.id

Restrict delete

analtraisamp_mod2_fk

analytics_train_samples.modelid

analytics_models.id

Restrict delete

analusedanal_mod2_fk

analytics_used_analysables.modelid

analytics_models.id

Restrict delete

analusedfile_fil2_fk

analytics_used_files.fileid

files.id

Restrict delete

analusedfile_mod2_fk

analytics_used_files.modelid

analytics_models.id

Restrict delete

assicomm_ass2_fk

assignfeedback_comments.assignment

assign.id

Restrict delete

assicomm_gra2_fk

assignfeedback_comments.grade

assign_grades.id

Restrict delete

assieditanno_gra2_fk

assignfeedback_editpdf_annot.gradeid

assign_grades.id

Restrict delete

assieditcmnt_gra2_fk

assignfeedback_editpdf_cmnt.gradeid

assign_grades.id

Restrict delete

assieditquic_use2_fk

assignfeedback_editpdf_quick.userid

user.id

Restrict delete

assieditrot_gra2_fk

assignfeedback_editpdf_rot.gradeid

assign_grades.id

Restrict delete

assifile_ass2_fk

assignfeedback_file.assignment

assign.id

Restrict delete

assifile_ass5_fk

assignsubmission_file.assignment

assign.id

Restrict delete

assifile_gra2_fk

assignfeedback_file.grade

assign_grades.id

Restrict delete

assifile_sub2_fk

assignsubmission_file.submission

assign_submission.id

Restrict delete

assigrad_ass2_fk

assign_grades.assignment

assign.id

Restrict delete

assionli_ass2_fk

assignsubmission_onlinetext.assignment

assign.id

Restrict delete

assionli_sub2_fk

assignsubmission_onlinetext.submission

assign_submission.id

Restrict delete

assiover_ass2_fk

assign_overrides.assignid

assign.id

Restrict delete

assiover_gro2_fk

assign_overrides.groupid

groups.id

Restrict delete

assiover_use2_fk

assign_overrides.userid

user.id

Restrict delete

assiplugconf_ass2_fk

assign_plugin_config.assignment

assign.id

Restrict delete

assisubm_ass2_fk

assign_submission.assignment

assign.id

Restrict delete

assiuserflag_ass2_fk

assign_user_flags.assignment

assign.id

Restrict delete

assiuserflag_use2_fk

assign_user_flags.userid

user.id

Restrict delete

assiusermapp_ass2_fk

assign_user_mapping.assignment

assign.id

Restrict delete

assiusermapp_use2_fk

assign_user_mapping.userid

user.id

Restrict delete

authltilinklogi_use2_fk

auth_lti_linked_login.userid

user.id

Restrict delete

authoautlinklogi_iss2_fk

auth_oauth2_linked_login.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

backcont_use2_fk

backup_controllers.userid

user.id

Restrict delete

backlogs_bac2_fk

backup_logs.backupid

backup_controllers.backupid

Restrict delete

backup_courses_erd_courseid

backup_courses.courseid

course.id

Restrict delete

badg_cou2_fk

badge.courseid

course.id

Restrict delete

badg_use3_fk

badge.usermodified

user.id

Restrict delete

badg_use4_fk

badge.usercreated

user.id

Restrict delete

badgalig_bad2_fk

badge_alignment.badgeid

badge.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

badgbackoaut_ext2_fk

badge_backpack_oauth2.externalbackpackid

badge_external_backpack.id

Restrict delete

badgbackoaut_iss2_fk

badge_backpack_oauth2.issuerid

oauth2_issuer.id

Restrict delete

Showing 1 to 50 of 651 entries

Check Constraints

Search:

Table	Constraint Name	Constraint
No data available in table

Showing 0 to 0 of 0 entries