Constraints

94 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

app_totara_competency_achievement_assignment_id_fk

app_totara_competency_achievement.assignment_id

app_totara_competency_assignments.id

Cascade on delete

app_totara_core_relationship_resolver_relationship_id_fk

app_totara_core_relationship_resolver.relationship_id

app_totara_core_relationship.id

Cascade on delete

app_totara_criteria_item_criterion_id_fk

app_totara_criteria_item.criterion_id

app_totara_criteria.id

Cascade on delete

app_engage_answer_option_questionid_fk

app_engage_answer_option.questionid

app_engage_question.id

Cascade on delete

app_totara_competency_configuration_change_assignment_id_fk

app_totara_competency_configuration_change.assignment_id

app_totara_competency_assignments.id

Cascade on delete

app_reaction_userid_fk

app_reaction.userid

Cascade on delete

app_reaction_contextid_fk

app_reaction.contextid

Cascade on delete

app_engage_share_recipient_shareid_fk

app_engage_share_recipient.shareid

app_engage_share.id

Cascade on delete

app_perform_subject_instance_track_user_assignment_id_fk

app_perform_subject_instance.track_user_assignment_id

app_perform_track_user_assignment.id

Cascade on delete

app_ml_recommender_users_user_id_fk

app_ml_recommender_users.user_id

Cascade on delete

app_goal_perform_status_subject_instance_id_fk

app_goal_perform_status.subject_instance_id

app_perform_subject_instance.id

Null on delete

app_goal_perform_status_activity_id_fk

app_goal_perform_status.activity_id

Null on delete

app_goal_perform_status_goal_personal_id_fk

app_goal_perform_status.goal_personal_id

app_goal_personal.id

Cascade on delete

app_goal_perform_status_status_changer_relationship_id_fk

app_goal_perform_status.status_changer_relationship_id

app_totara_core_relationship.id

Cascade on delete

app_goal_perform_status_goal_id_fk

app_goal_perform_status.goal_id

Cascade on delete

app_playlist_userid_fk

app_playlist.userid

Cascade on delete

app_perform_section_element_element_id_fk

app_perform_section_element.element_id

app_perform_element.id

Cascade on delete

app_perform_section_element_section_id_fk

app_perform_section_element.section_id

app_perform_section.id

Cascade on delete

app_perform_notification_recipient_core_relationship_id_fk

app_perform_notification_recipient.core_relationship_id

app_totara_core_relationship.id

Cascade on delete

app_perform_notification_recipient_notification_id_fk

app_perform_notification_recipient.notification_id

app_perform_notification.id

Cascade on delete

app_perform_section_activity_id_fk

app_perform_section.activity_id

Cascade on delete

app_totara_competency_configuration_history_assignment_id_fk

app_totara_competency_configuration_history.assignment_id

app_totara_competency_assignments.id

Cascade on delete

app_totara_evidence_type_info_field_typeid_fk

app_totara_evidence_type_info_field.typeid

app_totara_evidence_type.id

Cascade on delete

app_totara_criteria_item_record_criterion_item_id_fk

app_totara_criteria_item_record.criterion_item_id

app_totara_criteria_item.id

Cascade on delete

app_totara_mobile_compatible_courses_courseid_fk

app_totara_mobile_compatible_courses.courseid

Cascade on delete

app_perform_track_assignment_track_id_fk

app_perform_track_assignment.track_id

app_perform_track.id

Cascade on delete

app_perform_participant_section_participant_instance_id_fk

app_perform_participant_section.participant_instance_id

app_perform_participant_instance.id

Cascade on delete

app_perform_participant_section_section_id_fk

app_perform_participant_section.section_id

app_perform_section.id

Restrict delete

app_engage_bookmark_userid_fk

app_engage_bookmark.userid

Cascade on delete

app_virtualmeeting_config_virtualmeetingid_fk

app_virtualmeeting_config.virtualmeetingid

app_virtualmeeting.id

Cascade on delete

app_engage_question_userid_fk

app_engage_question.userid

Cascade on delete

app_totara_msteams_subscription_msbotid_fk

app_totara_msteams_subscription.msbotid

app_totara_msteams_bot.id

Cascade on delete

app_totara_msteams_subscription_msuserid_fk

app_totara_msteams_subscription.msuserid

app_totara_msteams_user.id

Cascade on delete

app_totara_msteams_subscription_mstenantid_fk

app_totara_msteams_subscription.mstenantid

app_totara_msteams_tenant.id

Cascade on delete

app_user_tenantid_fk

app_user.tenantid

Restrict delete

app_totara_dashboard_tenantid_fk

app_totara_dashboard.tenantid

Restrict delete

app_pathway_criteria_group_criterion_criteria_group_id_fk

app_pathway_criteria_group_criterion.criteria_group_id

app_pathway_criteria_group.id

Cascade on delete

app_totara_oauth2_access_token_client_provider_id_fk

app_totara_oauth2_access_token.client_provider_id

app_totara_oauth2_client_provider.id

Cascade on delete

app_lti_submission_history_ltiid_fk

app_lti_submission_history.ltiid

Cascade on delete

app_lti_submission_history_userid_fk

app_lti_submission_history.userid

Restrict delete

app_perform_notification_activity_id_fk

app_perform_notification.activity_id

Cascade on delete

app_engage_answer_choice_userid_fk

app_engage_answer_choice.userid

Cascade on delete

app_engage_survey_question_surveyid_fk

app_engage_survey_question.surveyid

app_engage_survey.id

Cascade on delete

app_totara_competency_pathway_achievement_pathway_id_fk

app_totara_competency_pathway_achievement.pathway_id

app_totara_competency_pathway.id

Cascade on delete

app_perform_type_id_fk

app_perform.type_id

app_perform_type.id

Restrict delete

app_totara_evidence_type_info_data_fieldid_fk

app_totara_evidence_type_info_data.fieldid

app_totara_evidence_type_info_field.id

Restrict delete

app_totara_evidence_type_info_data_evidenceid_fk

app_totara_evidence_type_info_data.evidenceid

app_totara_evidence_item.id

Cascade on delete

app_49d7f8db2ec19b152580f45222d3993e_fk

app_perform_subject_instance_manual_participant.core_relationship_id

app_totara_core_relationship.id

Cascade on delete

app_43f4fbb5215813f66b555a508047cc78_fk

app_perform_subject_instance_manual_participant.subject_instance_id

app_perform_subject_instance.id

Cascade on delete

app_ml_recommender_interactions_interaction_type_id_fk

app_ml_recommender_interactions.interaction_type_id

app_ml_recommender_interaction_types.id

Cascade on delete

app_ml_recommender_interactions_component_id_fk

app_ml_recommender_interactions.component_id

app_ml_recommender_components.id

Cascade on delete

app_perform_setting_activity_id_fk

app_perform_setting.activity_id

Cascade on delete

app_totara_competency_assignment_user_logs_assignment_id_fk

app_totara_competency_assignment_user_logs.assignment_id

app_totara_competency_assignments.id

Cascade on delete

app_perform_section_element_reference_referencing_element_id_fk

app_perform_section_element_reference.referencing_element_id

app_perform_element.id

Cascade on delete

app_virtualmeeting_auth_userid_fk

app_virtualmeeting_auth.userid

Cascade on delete

app_totara_core_mention_userid_fk

app_totara_core_mention.userid

Cascade on delete

app_marketplace_linkedin_user_progress_user_id_fk

app_marketplace_linkedin_user_progress.user_id

Cascade on delete

app_totara_evidence_type_info_data_param_dataid_fk

app_totara_evidence_type_info_data_param.dataid

app_totara_evidence_type_info_data.id

Cascade on delete

app_64bf298f0217a22233ee27f7341cafec_fk

app_perform_manual_relation_selection_progress.manual_relation_selection_id

app_perform_manual_relation_selection.id

Cascade on delete

app_791773d7f8d22606cb1b340ad79bde6b_fk

app_perform_manual_relation_selection_progress.subject_instance_id

app_perform_subject_instance.id

Cascade on delete

app_totara_competency_assignment_users_assignment_id_fk

app_totara_competency_assignment_users.assignment_id

app_totara_competency_assignments.id

Cascade on delete

app_totara_mobile_webviews_deviceid_fk

app_totara_mobile_webviews.deviceid

app_totara_mobile_devices.id

Cascade on delete

app_totara_mobile_webviews_sessionid_fk

app_totara_mobile_webviews.sessionid

app_sessions.id

Cascade on delete

app_perform_subject_static_instance_subject_instance_id_fk

app_perform_subject_static_instance.subject_instance_id

app_perform_subject_instance.id

Cascade on delete

app_context_tenantid_fk

app_context.tenantid

Restrict delete

app_perform_element_response_participant_instance_id_fk

app_perform_element_response.participant_instance_id

app_perform_participant_instance.id

Cascade on delete

app_perform_section_relationship_core_relationship_id_fk

app_perform_section_relationship.core_relationship_id

app_totara_core_relationship.id

Cascade on delete

app_perform_section_relationship_section_id_fk

app_perform_section_relationship.section_id

app_perform_section.id

Restrict delete

app_auth_oauth2_linked_login_userid_fk

app_auth_oauth2_linked_login.userid

Restrict delete

app_auth_oauth2_linked_login_issuerid_fk

app_auth_oauth2_linked_login.issuerid

app_oauth2_issuer.id

Cascade on delete

app_totara_evidence_item_typeid_fk

app_totara_evidence_item.typeid

app_totara_evidence_type.id

Restrict delete

app_totara_criteria_metadata_criterion_id_fk

app_totara_criteria_metadata.criterion_id

app_totara_criteria.id

Cascade on delete

app_perform_participant_instance_subject_instance_id_fk

app_perform_participant_instance.subject_instance_id

app_perform_subject_instance.id

Cascade on delete

app_6568c1137536984e97adfecc2174646a_fk

app_perform_manual_relation_selector.manual_relation_select_progress_id

app_perform_manual_relation_selection_progress.id

Cascade on delete

app_perform_element_linked_review_content_section_element_id_fk

app_perform_element_linked_review_content.section_element_id

app_perform_section_element.id

Cascade on delete

app_d08c853985bb9d27540e8d4299dcdd1b_fk

app_perform_element_linked_review_content.subject_instance_id

app_perform_subject_instance.id

Cascade on delete

app_pathway_perform_rating_subject_instance_id_fk

app_pathway_perform_rating.subject_instance_id

app_perform_subject_instance.id

Null on delete

app_pathway_perform_rating_competency_id_fk

app_pathway_perform_rating.competency_id

Cascade on delete

app_pathway_perform_rating_rater_relationship_id_fk

app_pathway_perform_rating.rater_relationship_id

app_totara_core_relationship.id

Cascade on delete

app_pathway_perform_rating_activity_id_fk

app_pathway_perform_rating.activity_id

Null on delete

app_playlist_resource_playlistid_fk

app_playlist_resource.playlistid

app_playlist.id

Cascade on delete

app_totara_competency_achievement_via_pathway_achievement_id_fk

app_totara_competency_achievement_via.pathway_achievement_id

app_totara_competency_pathway_achievement.id

Cascade on delete

app_totara_competency_achievement_via_comp_achievement_id_fk

app_totara_competency_achievement_via.comp_achievement_id

app_totara_competency_achievement.id

Cascade on delete

app_virtualmeeting_userid_fk

app_virtualmeeting.userid

Cascade on delete

app_tenant_categoryid_fk

app_tenant.categoryid

app_course_categories.id

Restrict delete

app_tenant_cohortid_fk

app_tenant.cohortid

Restrict delete

app_engage_resource_completion_userid_fk

app_engage_resource_completion.userid

Cascade on delete

app_engage_resource_userid_fk

app_engage_resource.userid

Cascade on delete

app_perform_track_activity_id_fk

app_perform_track.activity_id

Cascade on delete

app_266e292903e703cf6663d664b2d9892c_fk

app_perform_element_linked_review_content_response.participant_instance_id

app_perform_participant_instance.id

Cascade on delete

app_perform_track_user_assignment_track_id_fk

app_perform_track_user_assignment.track_id

app_perform_track.id

Restrict delete

app_engage_share_ownerid_fk

app_engage_share.ownerid

Cascade on delete

app_b456b827261a58f29560ec34f0298b90_fk

app_perform_track_user_assignment_via.track_user_assignment_id

app_perform_track_user_assignment.id

Cascade on delete

app_perform_track_user_assignment_via_track_assignment_id_fk

app_perform_track_user_assignment_via.track_assignment_id

app_perform_track_assignment.id

Cascade on delete

Check Constraints

Table	Constraint Name	Constraint
app_oauth2_issuer	app_oauth2_issuershow_default_branding_enum	((show_default_branding = ANY (ARRAY[0, 1])))
app_report_builder_filters	app_report_builder_filtersfilteringrequired_enum	((filteringrequired = ANY (ARRAY[0, 1])))
app_totara_cloudfiledir_sync	app_totara_cloudfiledir_synclocalproblem_enum	((localproblem = ANY (ARRAY[0, 1])))
app_user	app_usermnethostid_enum	((mnethostid = 1))
app_auth_oauth2_linked_login	app_auth_oauth2_linked_loginconfirmed_enum	((confirmed = ANY (ARRAY[0, 1])))