Constraints

145 Foreign Key Constraints

Search:

Constraint Name

Child Column

Parent Column

Delete Rule

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_266e292903e703cf6663d664b2d9892c_fk

app_perform_element_linked_review_content_response.participant_instance_id

app_perform_participant_instance.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_3e1459518b3fa204ad08ce14eb833f21_fk

app_approval_workflow_stage_interaction_action.workflow_stage_interaction_id

app_approval_workflow_stage_interaction.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_49d7f8db2ec19b152580f45222d3993e_fk

app_perform_subject_instance_manual_participant.core_relationship_id

app_totara_core_relationship.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_6568c1137536984e97adfecc2174646a_fk

app_perform_manual_relation_selector.manual_relation_select_progress_id

app_perform_manual_relation_selection_progress.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_791773d7f8d22606cb1b340ad79bde6b_fk

app_perform_manual_relation_selection_progress.subject_instance_id

app_perform_subject_instance.id

Cascade on delete

app_9986e417a326b2f6ad3d528ec761710b_fk

app_approval_dashboard_draft_application_applicant.approval_id

app_approval.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_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

Restrict 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_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

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_approval_id_fk

app_approval_application.approval_id

app_approval.id

Restrict delete

app_approval_application_creator_id_fk

app_approval_application.creator_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_owner_id_fk

app_approval_application.owner_id

Restrict delete

app_approval_application_submission_application_id_fk

app_approval_application_submission.application_id

app_approval_application.id

Restrict delete

app_approval_application_submission_user_id_fk

app_approval_application_submission.user_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_submitter_id_fk

app_approval_application.submitter_id

Restrict delete

app_approval_application_user_id_fk

app_approval_application.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_approval_approver_approval_id_fk

app_approval_approver.approval_id

app_approval.id

Restrict 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_course_fk

app_approval.course

Restrict 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

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_approval_dashboard_application_user_applicant_id_fk

app_approval_dashboard_application_user.applicant_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

Cascade on delete

app_approval_dashboard_draft_application_user_applicant_id_fk

app_approval_dashboard_draft_application_user.applicant_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_approval_dashboard_pending_application_any_user_id_fk

app_approval_dashboard_pending_application_any.user_id

Cascade on delete

app_approval_dashboard_pending_application_user_applicant_id_fk

app_approval_dashboard_pending_application_user.applicant_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_course_id_fk

app_approval_workflow.course_id

Restrict delete

app_approval_workflow_form_id_fk

app_approval_workflow.form_id

app_approval_form.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_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_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_workflow_stage_workflow_version_id_fk

app_approval_workflow_stage.workflow_version_id

app_approval_workflow_version.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_approval_workflow_workflow_type_id_fk

app_approval_workflow.workflow_type_id

app_approval_workflow_type.id

Restrict delete

Showing 1 to 50 of 145 entries

Check Constraints

Search:

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

Showing 1 to 5 of 5 entries