Constraints

169 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_9e839cbed562110c8d6f8baa95277ddd_fk
app_approval_workflow_stage_interaction_transition.workflow_stage_interaction_id
app_approval_workflow_stage_interaction.id
Cascade on delete
app_approval_workflow_stage_formview_workflow_stage_id_fk
app_approval_workflow_stage_formview.workflow_stage_id
app_approval_workflow_stage.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_engage_share_recipient_shareid_fk
app_engage_share_recipient.shareid
app_engage_share.id
Cascade on delete
app_ml_recommender_users_user_id_fk
app_ml_recommender_users.user_id
app_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
app_perform.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
app_goal.id
Cascade on delete
app_228b20567ea6041068463a6a4203e4eb_fk
app_totara_useraction_scheduled_rule_audience_map.scheduled_rule_id
app_totara_useraction_scheduled_rule.id
Cascade on delete
app_totara_useraction_scheduled_rule_audience_map_cohort_id_fk
app_totara_useraction_scheduled_rule_audience_map.cohort_id
app_cohort.id
Cascade on delete
app_playlist_userid_fk
app_playlist.userid
app_user.id
Cascade on delete
app_perform_section_activity_id_fk
app_perform_section.activity_id
app_perform.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
app_course.id
Cascade on delete
app_perform_track_assignment_track_id_fk
app_perform_track_assignment.track_id
app_perform_track.id
Cascade on delete
app_approval_dashboard_pending_application_any_approval_id_fk
app_approval_dashboard_pending_application_any.approval_id
app_approval.id
Cascade on delete
app_78a5c38402cbb0009645bfa07df93bda_fk
app_approval_dashboard_pending_application_any.workflow_stage_approval_level_id
app_approval_workflow_stage_approval_level.id
Cascade on delete
app_approval_dashboard_pending_application_any_user_id_fk
app_approval_dashboard_pending_application_any.user_id
app_user.id
Cascade on delete
app_approval_dashboard_application_any_approval_id_fk
app_approval_dashboard_application_any.approval_id
app_approval.id
Cascade on delete
app_approval_dashboard_application_any_user_id_fk
app_approval_dashboard_application_any.user_id
app_user.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_totara_api_client_rate_limit_client_id_fk
app_totara_api_client_rate_limit.client_id
app_totara_api_client.id
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
app_user.id
Cascade on delete
app_user_tenantid_fk
app_user.tenantid
app_tenant.id
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_mfa_instance_config_user_id_fk
app_mfa_instance_config.user_id
app_user.id
Cascade on delete
app_perform_goal_activity_user_id_fk
app_perform_goal_activity.user_id
app_user.id
Restrict delete
app_perform_goal_activity_goal_id_fk
app_perform_goal_activity.goal_id
app_perform_goal.id
Cascade on delete
app_approval_dashboard_application_user_applicant_id_fk
app_approval_dashboard_application_user.applicant_id
app_user.id
Cascade on delete
app_engage_survey_question_surveyid_fk
app_engage_survey_question.surveyid
app_engage_survey.id
Cascade on delete
app_approval_workflow_course_id_fk
app_approval_workflow.course_id
app_course.id
Restrict delete
app_approval_workflow_workflow_type_id_fk
app_approval_workflow.workflow_type_id
app_approval_workflow_type.id
Restrict delete
app_approval_workflow_form_id_fk
app_approval_workflow.form_id
app_approval_form.id
Restrict delete
app_totara_oauth2_client_provider_tenant_id_fk
app_totara_oauth2_client_provider.tenant_id
app_tenant.id
Cascade on delete
app_totara_api_client_settings_client_id_fk
app_totara_api_client_settings.client_id
app_totara_api_client.id
Cascade on delete
app_approval_dashboard_application_applicant_approval_id_fk
app_approval_dashboard_application_applicant.approval_id
app_approval.id
Cascade on 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_perform_setting_activity_id_fk
app_perform_setting.activity_id
app_perform.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
app_user.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_approval_dashboard_draft_application_any_approval_id_fk
app_approval_dashboard_draft_application_any.approval_id
app_approval.id
Cascade on delete
app_approval_dashboard_draft_application_any_user_id_fk
app_approval_dashboard_draft_application_any.user_id
app_user.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_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_approval_form_version_form_id_fk
app_approval_form_version.form_id
app_approval_form.id
Restrict delete
app_approval_workflow_version_form_version_id_fk
app_approval_workflow_version.form_version_id
app_approval_form_version.id
Restrict delete
app_9986e417a326b2f6ad3d528ec761710b_fk
app_approval_dashboard_draft_application_applicant.approval_id
app_approval.id
Cascade on delete
app_engage_resource_userid_fk
app_engage_resource.userid
app_user.id
Cascade on delete
app_perform_track_activity_id_fk
app_perform_track.activity_id
app_perform.id
Cascade on delete
app_engage_share_ownerid_fk
app_engage_share.ownerid
app_user.id
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
app_perform_goal_user_id_fk
app_perform_goal.user_id
app_user.id
Restrict delete
app_perform_goal_category_id_fk
app_perform_goal.category_id
app_perform_goal_category.id
Restrict delete
app_perform_goal_context_id_fk
app_perform_goal.context_id
app_context.id
Cascade on delete
app_perform_goal_owner_id_fk
app_perform_goal.owner_id
app_user.id
Restrict 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_auth_ssosaml_saml_log_idp_id_fk
app_auth_ssosaml_saml_log.idp_id
app_auth_ssosaml_idp_config.id
Cascade on delete
app_auth_ssosaml_saml_log_user_id_fk
app_auth_ssosaml_saml_log.user_id
app_user.id
Cascade on delete
app_reaction_userid_fk
app_reaction.userid
app_user.id
Cascade on delete
app_reaction_contextid_fk
app_reaction.contextid
app_context.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_totara_contentmarketplace_course_module_source_cm_id_fk
app_totara_contentmarketplace_course_module_source.cm_id
app_course_modules.id
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_approval_dashboard_pending_application_user_applicant_id_fk
app_approval_dashboard_pending_application_user.applicant_id
app_user.id
Cascade on delete
app_067ad06917d11a9cedb82c60ad8f20a0_fk
app_approval_dashboard_pending_application_user.workflow_stage_approval_level_id
app_approval_workflow_stage_approval_level.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_mfa_totp_used_token_user_id_fk
app_mfa_totp_used_token.user_id
app_user.id
Cascade on delete
app_engage_bookmark_userid_fk
app_engage_bookmark.userid
app_user.id
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_auth_ssosaml_idp_users_idp_id_fk
app_auth_ssosaml_idp_users.idp_id
app_auth_ssosaml_idp_config.id
Cascade on delete
app_auth_ssosaml_idp_users_user_id_fk
app_auth_ssosaml_idp_users.user_id
app_user.id
Cascade on delete
app_totara_dashboard_tenantid_fk
app_totara_dashboard.tenantid
app_tenant.id
Restrict delete
app_approval_dashboard_draft_application_user_applicant_id_fk
app_approval_dashboard_draft_application_user.applicant_id
app_user.id
Cascade on delete
app_27567652f1bb73b50df380feff2f98ce_fk
app_approval_application_activity.workflow_stage_approval_level_id
app_approval_workflow_stage_approval_level.id
Restrict delete
app_approval_application_activity_workflow_stage_id_fk
app_approval_application_activity.workflow_stage_id
app_approval_workflow_stage.id
Restrict delete
app_approval_application_activity_application_id_fk
app_approval_application_activity.application_id
app_approval_application.id
Restrict delete
app_approval_application_activity_user_id_fk
app_approval_application_activity.user_id
app_user.id
Restrict delete
app_totara_api_client_tenant_id_fk
app_totara_api_client.tenant_id
app_tenant.id
Cascade on delete
app_totara_api_client_user_id_fk
app_totara_api_client.user_id
app_user.id
Null on delete
app_lti_submission_history_ltiid_fk
app_lti_submission_history.ltiid
app_lti.id
Cascade on delete
app_lti_submission_history_userid_fk
app_lti_submission_history.userid
app_user.id
Restrict delete
app_perform_notification_activity_id_fk
app_perform_notification.activity_id
app_perform.id
Cascade on delete
app_engage_answer_choice_userid_fk
app_engage_answer_choice.userid
app_user.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_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_report_builder_tenantid_fk
app_report_builder.tenantid
app_tenant.id
Cascade on delete
app_perform_goal_perform_status_change_subject_instance_id_fk
app_perform_goal_perform_status_change.subject_instance_id
app_perform_subject_instance.id
Cascade on delete
app_perform_goal_perform_status_change_subject_user_id_fk
app_perform_goal_perform_status_change.subject_user_id
app_user.id
Null on delete
app_perform_goal_perform_status_change_activity_id_fk
app_perform_goal_perform_status_change.activity_id
app_perform.id
Cascade on delete
app_b0c7a05dcaaac211c9772362116ef28f_fk
app_perform_goal_perform_status_change.status_changer_relationship_id
app_totara_core_relationship.id
Null on delete
app_d8f789d6c722c1ef7b59f0dc12972814_fk
app_perform_goal_perform_status_change.status_changer_user_id
app_user.id
Restrict delete
app_perform_goal_perform_status_change_goal_id_fk
app_perform_goal_perform_status_change.goal_id
app_perform_goal.id
Cascade on delete
app_approval_workflow_stage_workflow_version_id_fk
app_approval_workflow_stage.workflow_version_id
app_approval_workflow_version.id
Restrict delete
app_totara_core_mention_userid_fk
app_totara_core_mention.userid
app_user.id
Cascade on delete
app_marketplace_linkedin_user_progress_user_id_fk
app_marketplace_linkedin_user_progress.user_id
app_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_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_approval_application_action_workflow_stage_id_fk
app_approval_application_action.workflow_stage_id
app_approval_workflow_stage.id
Restrict delete
app_approval_application_action_application_id_fk
app_approval_application_action.application_id
app_approval_application.id
Restrict delete
app_approval_application_action_user_id_fk
app_approval_application_action.user_id
app_user.id
Restrict 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
app_tenant.id
Restrict delete
app_approval_application_owner_id_fk
app_approval_application.owner_id
app_user.id
Restrict delete
app_approval_application_approval_id_fk
app_approval_application.approval_id
app_approval.id
Restrict delete
app_approval_application_creator_id_fk
app_approval_application.creator_id
app_user.id
Restrict delete
app_approval_application_form_version_id_fk
app_approval_application.form_version_id
app_approval_form_version.id
Restrict delete
app_approval_application_submitter_id_fk
app_approval_application.submitter_id
app_user.id
Restrict delete
app_approval_application_user_id_fk
app_approval_application.user_id
app_user.id
Restrict delete
app_approval_application_workflow_version_id_fk
app_approval_application.workflow_version_id
app_approval_workflow_version.id
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_approval_approver_workflow_stage_approval_level_id_fk
app_approval_approver.workflow_stage_approval_level_id
app_approval_workflow_stage_approval_level.id
Restrict delete
app_approval_approver_approval_id_fk
app_approval_approver.approval_id
app_approval.id
Restrict delete
app_approval_workflow_stage_approval_level_workflow_stage_id_fk
app_approval_workflow_stage_approval_level.workflow_stage_id
app_approval_workflow_stage.id
Restrict delete
app_auth_oauth2_linked_login_userid_fk
app_auth_oauth2_linked_login.userid
app_user.id
Restrict delete
app_auth_oauth2_linked_login_issuerid_fk
app_auth_oauth2_linked_login.issuerid
app_oauth2_issuer.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
app_comp.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
app_perform.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_6a5a21593c9e85194cb109d3448e37b6_fk
app_totara_useraction_scheduled_rule_history.scheduled_rule_id
app_totara_useraction_scheduled_rule.id
Cascade on delete
app_virtualmeeting_userid_fk
app_virtualmeeting.userid
app_user.id
Cascade on delete
app_tenant_categoryid_fk
app_tenant.categoryid
app_course_categories.id
Restrict delete
app_tenant_cohortid_fk
app_tenant.cohortid
app_cohort.id
Restrict delete
app_engage_resource_completion_userid_fk
app_engage_resource_completion.userid
app_user.id
Cascade on delete
app_approval_workflow_stage_interaction_workflow_stage_id_fk
app_approval_workflow_stage_interaction.workflow_stage_id
app_approval_workflow_stage.id
Restrict delete
app_approval_application_submission_workflow_stage_id_fk
app_approval_application_submission.workflow_stage_id
app_approval_workflow_stage.id
Restrict delete
app_approval_application_submission_user_id_fk
app_approval_application_submission.user_id
app_user.id
Restrict delete
app_approval_application_submission_application_id_fk
app_approval_application_submission.application_id
app_approval_application.id
Restrict delete
app_totara_api_client_oauth2_client_provider_client_id_fk
app_totara_api_client_oauth2_client_provider.client_id
app_totara_api_client.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_auth_ssosaml_session_idp_id_fk
app_auth_ssosaml_session.idp_id
app_auth_ssosaml_idp_config.id
Cascade on delete
app_auth_ssosaml_session_user_id_fk
app_auth_ssosaml_session.user_id
app_user.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_approval_course_fk
app_approval.course
app_course.id
Restrict delete
app_3e1459518b3fa204ad08ce14eb833f21_fk
app_approval_workflow_stage_interaction_action.workflow_stage_interaction_id
app_approval_workflow_stage_interaction.id
Cascade on delete

Check Constraints

Table Constraint Name Constraint
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_oauth2_issuer app_oauth2_issuershow_default_branding_enum ((show_default_branding = ANY (ARRAY[0, 1])))
app_auth_oauth2_linked_login app_auth_oauth2_linked_loginconfirmed_enum ((confirmed = ANY (ARRAY[0, 1])))