172 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| review_form_element_settings_review_form_element_id |
|
|
Cascade on delete | ||
| filters_filter_group_id_foreign |
|
|
Cascade on delete | ||
| sections_journal_id |
|
|
Cascade on delete | ||
| sections_review_form_id |
|
|
Null on delete | ||
| notification_settings_notification_id_foreign |
|
|
Cascade on delete | ||
| subscription_types_journal_id |
|
|
Cascade on delete | ||
| review_round_files_review_round_id_foreign |
|
|
Cascade on delete | ||
| review_round_files_submission_file_id_foreign |
|
|
Cascade on delete | ||
| review_round_files_submission_id_foreign |
|
|
Cascade on delete | ||
| publications_submission_id |
|
|
Cascade on delete | ||
| publications_primary_contact_id |
|
|
Null on delete | ||
| publications_section_id |
|
|
Null on delete | ||
| publications_doi_id_foreign |
|
|
Null on delete | ||
| review_rounds_submission_id_foreign |
|
|
Restrict delete | ||
| citations_publication |
|
|
Cascade on delete | ||
| library_files_context_id |
|
|
Cascade on delete | ||
| library_files_submission_id_foreign |
|
|
Cascade on delete | ||
| metrics_issue_context_id_foreign |
|
|
Cascade on delete | ||
| metrics_issue_issue_galley_id_foreign |
|
|
Cascade on delete | ||
| metrics_issue_issue_id_foreign |
|
|
Cascade on delete | ||
| navigation_menu_item_assignments_navigation_menu_item_id_foreign |
|
|
Cascade on delete | ||
| navigation_menu_item_assignments_navigation_menu_id_foreign |
|
|
Cascade on delete | ||
| filter_settings_filter_id_foreign |
|
|
Cascade on delete | ||
| categories_parent_id_foreign |
|
|
Null on delete | ||
| categories_context_id_foreign |
|
|
Cascade on delete | ||
| institutional_subscriptions_institution_id_foreign |
|
|
Cascade on delete | ||
| institutional_subscriptions_subscription_id |
|
|
Cascade on delete | ||
| email_templates_context_id_foreign |
|
|
Cascade on delete | ||
| navigation_menu_item_settings_navigation_menu_id |
|
|
Cascade on delete | ||
| submission_files_uploader_user_id_foreign |
|
|
Null on delete | ||
| submission_files_file_id_foreign |
|
|
Cascade on delete | ||
| submission_files_source_submission_file_id_foreign |
|
|
Cascade on delete | ||
| submission_files_genre_id_foreign |
|
|
Null on delete | ||
| submission_files_submission_id |
|
|
Cascade on delete | ||
| msm_context_id_foreign |
|
|
Cascade on delete | ||
| msm_submission_id_foreign |
|
|
Cascade on delete | ||
| journal_settings_journal_id |
|
|
Cascade on delete | ||
| static_pages_context_id |
|
|
Cascade on delete | ||
| genres_context_id_foreign |
|
|
Cascade on delete | ||
| msid_institution_id_foreign |
|
|
Cascade on delete | ||
| msid_context_id_foreign |
|
|
Cascade on delete | ||
| msid_submission_id_foreign |
|
|
Cascade on delete | ||
| user_group_stage_context_id |
|
|
Cascade on delete | ||
| user_group_stage_user_group_id |
|
|
Cascade on delete | ||
| submission_search_object_submission |
|
|
Cascade on delete | ||
| review_assignments_submission_id_foreign |
|
|
Restrict delete | ||
| review_assignments_review_round_id_foreign |
|
|
Restrict delete | ||
| review_assignments_review_form_id_foreign |
|
|
Restrict delete | ||
| review_assignments_reviewer_id_foreign |
|
|
Restrict delete | ||
| data_object_tombstone_settings_tombstone_id |
|
|
Cascade on delete | ||
| publication_settings_publication_id |
|
|
Cascade on delete | ||
| announcement_types_context_id_foreign |
|
|
Cascade on delete | ||
| notifications_context_id_foreign |
|
|
Cascade on delete | ||
| notifications_user_id_foreign |
|
|
Cascade on delete | ||
| announcement_type_settings_type_id_foreign |
|
|
Cascade on delete | ||
| notification_subscription_settings_context_foreign |
|
|
Cascade on delete | ||
| notification_subscription_settings_user_id_foreign |
|
|
Cascade on delete | ||
| submissions_context_id |
|
|
Cascade on delete | ||
| submissions_publication_id |
|
|
Null on delete | ||
| user_interests_user_id_foreign |
|
|
Cascade on delete | ||
| user_interests_controlled_vocab_entry_id_foreign |
|
|
Cascade on delete | ||
| doi_settings_doi_id_foreign |
|
|
Cascade on delete | ||
| access_keys_user_id_foreign |
|
|
Cascade on delete | ||
| review_form_settings_review_form_id |
|
|
Cascade on delete | ||
| authors_user_group_id_foreign |
|
|
Cascade on delete | ||
| authors_publication_id_foreign |
|
|
Cascade on delete | ||
| msgd_submission_id_foreign |
|
|
Cascade on delete | ||
| msgd_context_id_foreign |
|
|
Cascade on delete | ||
| msgm_submission_id_foreign |
|
|
Cascade on delete | ||
| msgm_context_id_foreign |
|
|
Cascade on delete | ||
| submission_file_revisions_file_id_foreign |
|
|
Cascade on delete | ||
| submission_file_revisions_submission_file_id_foreign |
|
|
Cascade on delete | ||
| issue_files_issue_id |
|
|
Cascade on delete | ||
| usi_institution_id_foreign |
|
|
Cascade on delete | ||
| review_files_review_id_foreign |
|
|
Cascade on delete | ||
| review_files_submission_file_id_foreign |
|
|
Cascade on delete | ||
| issue_settings_issue_id |
|
|
Cascade on delete | ||
| user_group_settings_user_group_id_foreign |
|
|
Cascade on delete | ||
| category_settings_category_id_foreign |
|
|
Cascade on delete | ||
| publication_galley_settings_galley_id |
|
|
Cascade on delete | ||
| library_file_settings_file_id_foreign |
|
|
Cascade on delete | ||
| email_templates_settings_email_id |
|
|
Cascade on delete | ||
| announcements_type_id_foreign |
|
|
Null on delete | ||
| user_user_groups_user_id |
|
|
Cascade on delete | ||
| user_user_groups_user_group_id_foreign |
|
|
Cascade on delete | ||
| publication_galleys_doi_id_foreign |
|
|
Null on delete | ||
| publication_galleys_submission_file_id_foreign |
|
|
Restrict delete | ||
| publication_galleys_publication_id |
|
|
Cascade on delete | ||
| review_form_elements_review_form_id |
|
|
Cascade on delete | ||
| metrics_submission_representation_id_foreign |
|
|
Cascade on delete | ||
| metrics_submission_submission_file_id_foreign |
|
|
Cascade on delete | ||
| metrics_submission_context_id_foreign |
|
|
Cascade on delete | ||
| metrics_submission_submission_id_foreign |
|
|
Cascade on delete | ||
| submission_comments_submission_id |
|
|
Cascade on delete | ||
| submission_comments_author_id_foreign |
|
|
Cascade on delete | ||
| subscription_type_settings_type_id |
|
|
Cascade on delete | ||
| static_page_settings_static_page_id |
|
|
Cascade on delete | ||
| email_log_users_email_log_id_foreign |
|
|
Cascade on delete | ||
| email_log_users_user_id_foreign |
|
|
Cascade on delete | ||
| institution_settings_institution_id_foreign |
|
|
Cascade on delete | ||
| institutions_context_id_foreign |
|
|
Cascade on delete | ||
| issue_galleys_settings_galley_id |
|
|
Cascade on delete | ||
| section_editors_context_id |
|
|
Cascade on delete | ||
| subeditor_submission_group_user_id |
|
|
Cascade on delete | ||
| subeditor_submission_group_user_group_id_foreign |
|
|
Cascade on delete | ||
| author_settings_author_id |
|
|
Cascade on delete | ||
| controlled_vocab_entries_controlled_vocab_id_foreign |
|
|
Cascade on delete | ||
| submission_file_settings_submission_file_id_foreign |
|
|
Cascade on delete | ||
| event_log_settings_log_id |
|
|
Cascade on delete | ||
| metrics_context_context_id_foreign |
|
|
Cascade on delete | ||
| data_object_tombstone_oai_set_objects_tombstone_id |
|
|
Cascade on delete | ||
| temporary_files_user_id |
|
|
Cascade on delete | ||
| review_form_responses_review_id_foreign |
|
|
Cascade on delete | ||
| review_form_responses_review_form_element_id_foreign |
|
|
Cascade on delete | ||
| stage_assignments_user_id |
|
|
Cascade on delete | ||
| stage_assignments_user_group_id |
|
|
Cascade on delete | ||
| stage_assignments_submission_id_foreign |
|
|
Cascade on delete | ||
| institution_ip_institution_id_foreign |
|
|
Cascade on delete | ||
| assignment_settings_navigation_menu_item_assignment_id |
|
|
Cascade on delete | ||
| submission_settings_submission_id_foreign |
|
|
Cascade on delete | ||
| user_settings_user_id_foreign |
|
|
Cascade on delete | ||
| custom_section_orders_section_id |
|
|
Cascade on delete | ||
| custom_section_orders_issue_id |
|
|
Cascade on delete | ||
| journals_current_issue_id_foreign |
|
|
Null on delete | ||
| c_v_e_s_entry_id |
|
|
Cascade on delete | ||
| submission_search_object_keywords_keyword_id |
|
|
Cascade on delete | ||
| submission_search_object_keywords_object_id_foreign |
|
|
Cascade on delete | ||
| usii_submission_id_foreign |
|
|
Cascade on delete | ||
| usii_submission_file_id_foreign |
|
|
Cascade on delete | ||
| usii_context_id_foreign |
|
|
Cascade on delete | ||
| usii_representation_id_foreign |
|
|
Cascade on delete | ||
| notes_user_id_foreign |
|
|
Cascade on delete | ||
| event_log_user_id_foreign |
|
|
Cascade on delete | ||
| dois_context_id_foreign |
|
|
Cascade on delete | ||
| custom_issue_orders_issue_id |
|
|
Cascade on delete | ||
| custom_issue_orders_journal_id |
|
|
Cascade on delete | ||
| query_participants_user_id_foreign |
|
|
Cascade on delete | ||
| query_participants_query_id_foreign |
|
|
Cascade on delete | ||
| msd_context_id_foreign |
|
|
Cascade on delete | ||
| msd_submission_id_foreign |
|
|
Cascade on delete | ||
| usir_submission_id_foreign |
|
|
Cascade on delete | ||
| usir_context_id_foreign |
|
|
Cascade on delete | ||
| usir_submission_file_id_foreign |
|
|
Cascade on delete | ||
| usir_representation_id_foreign |
|
|
Cascade on delete | ||
| completed_payments_context_id |
|
|
Cascade on delete | ||
| completed_payments_user_id |
|
|
Null on delete | ||
| announcement_settings_announcement_id_foreign |
|
|
Cascade on delete | ||
| msim_context_id_foreign |
|
|
Cascade on delete | ||
| msim_submission_id_foreign |
|
|
Cascade on delete | ||
| msim_institution_id_foreign |
|
|
Cascade on delete | ||
| subscriptions_journal_id |
|
|
Cascade on delete | ||
| subscriptions_user_id |
|
|
Cascade on delete | ||
| subscriptions_type_id |
|
|
Cascade on delete | ||
| ust_issue_id_foreign |
|
|
Cascade on delete | ||
| ust_context_id_foreign |
|
|
Cascade on delete | ||
| ust_representation_id_foreign |
|
|
Cascade on delete | ||
| ust_submission_file_id_foreign |
|
|
Cascade on delete | ||
| ust_submission_id_foreign |
|
|
Cascade on delete | ||
| ust_issue_galley_id_foreign |
|
|
Cascade on delete | ||
| issue_galleys_file_id |
|
|
Cascade on delete | ||
| issue_galleys_issue_id |
|
|
Cascade on delete | ||
| edit_decisions_editor_id |
|
|
Cascade on delete | ||
| edit_decisions_review_round_id_foreign |
|
|
Cascade on delete | ||
| edit_decisions_submission_id |
|
|
Cascade on delete | ||
| issues_journal_id |
|
|
Cascade on delete | ||
| issues_doi_id_foreign |
|
|
Null on delete | ||
| genre_settings_genre_id_foreign |
|
|
Cascade on delete | ||
| sessions_user_id |
|
|
Cascade on delete | ||
| publication_categories_category_id_foreign |
|
|
Cascade on delete | ||
| publication_categories_publication_id_foreign |
|
|
Cascade on delete | ||
| citation_settings_citation_id |
|
|
Cascade on delete | ||
| section_settings_section_id |
|
|
Cascade on delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|