145 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| app_totara_competency_achievement_assignment_id_fk |
|
|
Cascade on delete | ||
| app_9e839cbed562110c8d6f8baa95277ddd_fk |
|
|
Cascade on delete | ||
| app_approval_workflow_stage_formview_workflow_stage_id_fk |
|
|
Cascade on delete | ||
| app_totara_criteria_item_criterion_id_fk |
|
|
Cascade on delete | ||
| app_engage_answer_option_questionid_fk |
|
|
Cascade on delete | ||
| app_totara_competency_configuration_change_assignment_id_fk |
|
|
Cascade on delete | ||
| app_engage_share_recipient_shareid_fk |
|
|
Cascade on delete | ||
| app_ml_recommender_users_user_id_fk |
|
|
Cascade on delete | ||
| app_goal_perform_status_subject_instance_id_fk |
|
|
Null on delete | ||
| app_goal_perform_status_activity_id_fk |
|
|
Null on delete | ||
| app_goal_perform_status_goal_personal_id_fk |
|
|
Cascade on delete | ||
| app_goal_perform_status_status_changer_relationship_id_fk |
|
|
Cascade on delete | ||
| app_goal_perform_status_goal_id_fk |
|
|
Cascade on delete | ||
| app_playlist_userid_fk |
|
|
Cascade on delete | ||
| app_perform_section_activity_id_fk |
|
|
Cascade on delete | ||
| app_totara_criteria_item_record_criterion_item_id_fk |
|
|
Cascade on delete | ||
| app_totara_mobile_compatible_courses_courseid_fk |
|
|
Cascade on delete | ||
| app_perform_track_assignment_track_id_fk |
|
|
Cascade on delete | ||
| app_approval_dashboard_pending_application_any_approval_id_fk |
|
|
Cascade on delete | ||
| app_78a5c38402cbb0009645bfa07df93bda_fk |
|
|
Cascade on delete | ||
| app_approval_dashboard_pending_application_any_user_id_fk |
|
|
Cascade on delete | ||
| app_approval_dashboard_application_any_approval_id_fk |
|
|
Cascade on delete | ||
| app_approval_dashboard_application_any_user_id_fk |
|
|
Cascade on delete | ||
| app_perform_participant_section_participant_instance_id_fk |
|
|
Cascade on delete | ||
| app_perform_participant_section_section_id_fk |
|
|
Restrict delete | ||
| app_totara_api_client_rate_limit_client_id_fk |
|
|
Cascade on delete | ||
| app_virtualmeeting_config_virtualmeetingid_fk |
|
|
Cascade on delete | ||
| app_engage_question_userid_fk |
|
|
Cascade on delete | ||
| app_user_tenantid_fk |
|
|
Restrict delete | ||
| app_pathway_criteria_group_criterion_criteria_group_id_fk |
|
|
Cascade on delete | ||
| app_totara_oauth2_access_token_client_provider_id_fk |
|
|
Cascade on delete | ||
| app_approval_dashboard_application_user_applicant_id_fk |
|
|
Cascade on delete | ||
| app_engage_survey_question_surveyid_fk |
|
|
Cascade on delete | ||
| app_approval_workflow_course_id_fk |
|
|
Restrict delete | ||
| app_approval_workflow_workflow_type_id_fk |
|
|
Restrict delete | ||
| app_approval_workflow_form_id_fk |
|
|
Restrict delete | ||
| app_totara_oauth2_client_provider_tenant_id_fk |
|
|
Cascade on delete | ||
| app_totara_api_client_settings_client_id_fk |
|
|
Cascade on delete | ||
| app_approval_dashboard_application_applicant_approval_id_fk |
|
|
Cascade on delete | ||
| app_totara_evidence_type_info_data_fieldid_fk |
|
|
Restrict delete | ||
| app_totara_evidence_type_info_data_evidenceid_fk |
|
|
Cascade on delete | ||
| app_perform_setting_activity_id_fk |
|
|
Cascade on delete | ||
| app_totara_competency_assignment_user_logs_assignment_id_fk |
|
|
Cascade on delete | ||
| app_perform_section_element_reference_referencing_element_id_fk |
|
|
Cascade on delete | ||
| app_virtualmeeting_auth_userid_fk |
|
|
Cascade on delete | ||
| app_totara_competency_assignment_users_assignment_id_fk |
|
|
Cascade on delete | ||
| app_approval_dashboard_draft_application_any_approval_id_fk |
|
|
Cascade on delete | ||
| app_approval_dashboard_draft_application_any_user_id_fk |
|
|
Cascade on delete | ||
| app_perform_section_relationship_core_relationship_id_fk |
|
|
Cascade on delete | ||
| app_perform_section_relationship_section_id_fk |
|
|
Restrict delete | ||
| app_totara_evidence_item_typeid_fk |
|
|
Restrict delete | ||
| app_totara_criteria_metadata_criterion_id_fk |
|
|
Cascade on delete | ||
| app_approval_form_version_form_id_fk |
|
|
Restrict delete | ||
| app_approval_workflow_version_form_version_id_fk |
|
|
Restrict delete | ||
| app_9986e417a326b2f6ad3d528ec761710b_fk |
|
|
Cascade on delete | ||
| app_engage_resource_userid_fk |
|
|
Cascade on delete | ||
| app_perform_track_activity_id_fk |
|
|
Cascade on delete | ||
| app_engage_share_ownerid_fk |
|
|
Cascade on delete | ||
| app_b456b827261a58f29560ec34f0298b90_fk |
|
|
Cascade on delete | ||
| app_perform_track_user_assignment_via_track_assignment_id_fk |
|
|
Cascade on delete | ||
| app_totara_core_relationship_resolver_relationship_id_fk |
|
|
Cascade on delete | ||
| app_reaction_userid_fk |
|
|
Cascade on delete | ||
| app_reaction_contextid_fk |
|
|
Cascade on delete | ||
| app_perform_subject_instance_track_user_assignment_id_fk |
|
|
Cascade on delete | ||
| app_totara_contentmarketplace_course_module_source_cm_id_fk |
|
|
Cascade on delete | ||
| app_perform_section_element_element_id_fk |
|
|
Cascade on delete | ||
| app_perform_section_element_section_id_fk |
|
|
Cascade on delete | ||
| app_perform_notification_recipient_core_relationship_id_fk |
|
|
Cascade on delete | ||
| app_perform_notification_recipient_notification_id_fk |
|
|
Cascade on delete | ||
| app_approval_dashboard_pending_application_user_applicant_id_fk |
|
|
Cascade on delete | ||
| app_067ad06917d11a9cedb82c60ad8f20a0_fk |
|
|
Cascade on delete | ||
| app_totara_competency_configuration_history_assignment_id_fk |
|
|
Cascade on delete | ||
| app_totara_evidence_type_info_field_typeid_fk |
|
|
Cascade on delete | ||
| app_engage_bookmark_userid_fk |
|
|
Cascade on delete | ||
| app_totara_msteams_subscription_msbotid_fk |
|
|
Cascade on delete | ||
| app_totara_msteams_subscription_msuserid_fk |
|
|
Cascade on delete | ||
| app_totara_msteams_subscription_mstenantid_fk |
|
|
Cascade on delete | ||
| app_totara_dashboard_tenantid_fk |
|
|
Restrict delete | ||
| app_approval_dashboard_draft_application_user_applicant_id_fk |
|
|
Cascade on delete | ||
| app_27567652f1bb73b50df380feff2f98ce_fk |
|
|
Restrict delete | ||
| app_approval_application_activity_workflow_stage_id_fk |
|
|
Restrict delete | ||
| app_approval_application_activity_application_id_fk |
|
|
Restrict delete | ||
| app_approval_application_activity_user_id_fk |
|
|
Restrict delete | ||
| app_totara_api_client_tenant_id_fk |
|
|
Cascade on delete | ||
| app_totara_api_client_user_id_fk |
|
|
Null on delete | ||
| app_lti_submission_history_ltiid_fk |
|
|
Cascade on delete | ||
| app_lti_submission_history_userid_fk |
|
|
Restrict delete | ||
| app_perform_notification_activity_id_fk |
|
|
Cascade on delete | ||
| app_engage_answer_choice_userid_fk |
|
|
Cascade on delete | ||
| app_totara_competency_pathway_achievement_pathway_id_fk |
|
|
Cascade on delete | ||
| app_perform_type_id_fk |
|
|
Restrict delete | ||
| app_49d7f8db2ec19b152580f45222d3993e_fk |
|
|
Cascade on delete | ||
| app_43f4fbb5215813f66b555a508047cc78_fk |
|
|
Cascade on delete | ||
| app_ml_recommender_interactions_interaction_type_id_fk |
|
|
Cascade on delete | ||
| app_ml_recommender_interactions_component_id_fk |
|
|
Cascade on delete | ||
| app_approval_workflow_stage_workflow_version_id_fk |
|
|
Restrict delete | ||
| app_totara_core_mention_userid_fk |
|
|
Cascade on delete | ||
| app_marketplace_linkedin_user_progress_user_id_fk |
|
|
Cascade on delete | ||
| app_totara_evidence_type_info_data_param_dataid_fk |
|
|
Cascade on delete | ||
| app_64bf298f0217a22233ee27f7341cafec_fk |
|
|
Cascade on delete | ||
| app_791773d7f8d22606cb1b340ad79bde6b_fk |
|
|
Cascade on delete | ||
| app_totara_mobile_webviews_deviceid_fk |
|
|
Cascade on delete | ||
| app_totara_mobile_webviews_sessionid_fk |
|
|
Cascade on delete | ||
| app_approval_application_action_workflow_stage_id_fk |
|
|
Restrict delete | ||
| app_approval_application_action_application_id_fk |
|
|
Restrict delete | ||
| app_approval_application_action_user_id_fk |
|
|
Restrict delete | ||
| app_perform_subject_static_instance_subject_instance_id_fk |
|
|
Cascade on delete | ||
| app_context_tenantid_fk |
|
|
Restrict delete | ||
| app_approval_application_owner_id_fk |
|
|
Restrict delete | ||
| app_approval_application_approval_id_fk |
|
|
Restrict delete | ||
| app_approval_application_creator_id_fk |
|
|
Restrict delete | ||
| app_approval_application_form_version_id_fk |
|
|
Restrict delete | ||
| app_approval_application_submitter_id_fk |
|
|
Restrict delete | ||
| app_approval_application_user_id_fk |
|
|
Restrict delete | ||
| app_approval_application_workflow_version_id_fk |
|
|
Restrict delete | ||
| app_perform_element_response_participant_instance_id_fk |
|
|
Cascade on delete | ||
| app_approval_approver_workflow_stage_approval_level_id_fk |
|
|
Restrict delete | ||
| app_approval_approver_approval_id_fk |
|
|
Restrict delete | ||
| app_approval_workflow_stage_approval_level_workflow_stage_id_fk |
|
|
Restrict delete | ||
| app_auth_oauth2_linked_login_userid_fk |
|
|
Restrict delete | ||
| app_auth_oauth2_linked_login_issuerid_fk |
|
|
Cascade on delete | ||
| app_perform_participant_instance_subject_instance_id_fk |
|
|
Cascade on delete | ||
| app_6568c1137536984e97adfecc2174646a_fk |
|
|
Cascade on delete | ||
| app_perform_element_linked_review_content_section_element_id_fk |
|
|
Cascade on delete | ||
| app_d08c853985bb9d27540e8d4299dcdd1b_fk |
|
|
Cascade on delete | ||
| app_pathway_perform_rating_subject_instance_id_fk |
|
|
Null on delete | ||
| app_pathway_perform_rating_competency_id_fk |
|
|
Cascade on delete | ||
| app_pathway_perform_rating_rater_relationship_id_fk |
|
|
Cascade on delete | ||
| app_pathway_perform_rating_activity_id_fk |
|
|
Null on delete | ||
| app_playlist_resource_playlistid_fk |
|
|
Cascade on delete | ||
| app_totara_competency_achievement_via_pathway_achievement_id_fk |
|
|
Cascade on delete | ||
| app_totara_competency_achievement_via_comp_achievement_id_fk |
|
|
Cascade on delete | ||
| app_virtualmeeting_userid_fk |
|
|
Cascade on delete | ||
| app_tenant_categoryid_fk |
|
|
Restrict delete | ||
| app_tenant_cohortid_fk |
|
|
Restrict delete | ||
| app_engage_resource_completion_userid_fk |
|
|
Cascade on delete | ||
| app_approval_workflow_stage_interaction_workflow_stage_id_fk |
|
|
Restrict delete | ||
| app_approval_application_submission_workflow_stage_id_fk |
|
|
Restrict delete | ||
| app_approval_application_submission_user_id_fk |
|
|
Restrict delete | ||
| app_approval_application_submission_application_id_fk |
|
|
Restrict delete | ||
| app_totara_api_client_oauth2_client_provider_client_id_fk |
|
|
Cascade on delete | ||
| app_266e292903e703cf6663d664b2d9892c_fk |
|
|
Cascade on delete | ||
| app_perform_track_user_assignment_track_id_fk |
|
|
Restrict delete | ||
| app_approval_course_fk |
|
|
Restrict delete | ||
| app_3e1459518b3fa204ad08ce14eb833f21_fk |
|
|
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]))) |