183 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 | ||
| series_categories_category_id |
|
|
Cascade on delete | ||
| series_categories_series_id |
|
|
Cascade on delete | ||
| notification_settings_notification_id_foreign |
|
|
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_series_id |
|
|
Null on delete | ||
| publications_doi_id_foreign |
|
|
Null on delete | ||
| publications_author_id |
|
|
Null on delete | ||
| press_settings_press_id_foreign |
|
|
Cascade on delete | ||
| spotlight_settings_spotlight_id_foreign |
|
|
Restrict 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 | ||
| 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 | ||
| submission_chapters_publication_id |
|
|
Cascade on delete | ||
| submission_chapters_doi_id_foreign |
|
|
Null on delete | ||
| submission_chapters_primary_contact_id_foreign |
|
|
Null on delete | ||
| submission_chapters_source_chapter_id_foreign |
|
|
Null on delete | ||
| email_templates_context_id_foreign |
|
|
Cascade on delete | ||
| navigation_menu_item_settings_navigation_menu_id |
|
|
Cascade on delete | ||
| submission_files_doi_id_foreign |
|
|
Null 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 | ||
| static_pages_context_id |
|
|
Cascade on delete | ||
| markets_publication_format_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 | ||
| identification_codes_publication_format_id |
|
|
Cascade on delete | ||
| publication_settings_publication_id_foreign |
|
|
Cascade on delete | ||
| announcement_types_context_id_foreign |
|
|
Cascade on delete | ||
| submission_chapter_settings_chapter_id_foreign |
|
|
Cascade on delete | ||
| notifications_context_id_foreign |
|
|
Cascade on delete | ||
| notifications_user_id_foreign |
|
|
Cascade on delete | ||
| publication_dates_publication_format_id |
|
|
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 | ||
| series_settings_series_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 | ||
| features_submission_id_foreign |
|
|
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 | ||
| user_group_settings_user_group_id_foreign |
|
|
Cascade on delete | ||
| category_settings_category_id_foreign |
|
|
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 | ||
| review_form_elements_review_form_id |
|
|
Cascade on delete | ||
| metrics_submission_representation_id_foreign |
|
|
Cascade on delete | ||
| metrics_submission_chapter_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_chapter_authors_author_id_foreign |
|
|
Cascade on delete | ||
| submission_chapter_authors_chapter_id_foreign |
|
|
Cascade on delete | ||
| submission_comments_submission_id |
|
|
Cascade on delete | ||
| submission_comments_author_id_foreign |
|
|
Cascade on delete | ||
| static_page_settings_static_page_id |
|
|
Cascade on delete | ||
| spotlights_press_id_foreign |
|
|
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 | ||
| 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 | ||
| publication_formats_publication_id |
|
|
Cascade on delete | ||
| publication_formats_doi_id_foreign |
|
|
Null 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 | ||
| publication_format_settings_publication_format_id |
|
|
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 | ||
| ustr_chapter_id_foreign |
|
|
Cascade on delete | ||
| ustr_submission_file_id_foreign |
|
|
Cascade on delete | ||
| ustr_submission_id_foreign |
|
|
Cascade on delete | ||
| ustr_context_id_foreign |
|
|
Cascade on delete | ||
| ustr_representation_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 | ||
| new_releases_submission_id |
|
|
Cascade on delete | ||
| user_settings_user_id_foreign |
|
|
Cascade 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_chapter_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 | ||
| 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_chapter_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_foreign |
|
|
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 | ||
| metrics_series_series_id_foreign |
|
|
Cascade on delete | ||
| metrics_series_context_id_foreign |
|
|
Cascade on delete | ||
| series_press_id |
|
|
Cascade on delete | ||
| series_review_form_id |
|
|
Null on delete | ||
| sales_rights_publication_format_id |
|
|
Cascade on delete | ||
| ust_context_id_foreign |
|
|
Cascade on delete | ||
| ust_representation_id_foreign |
|
|
Cascade on delete | ||
| ust_chapter_id_foreign |
|
|
Cascade on delete | ||
| ust_submission_file_id_foreign |
|
|
Cascade on delete | ||
| ust_submission_id_foreign |
|
|
Cascade on delete | ||
| ust_series_id_foreign |
|
|
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 | ||
| genre_settings_genre_id_foreign |
|
|
Cascade on delete | ||
| representatives_submission_id |
|
|
Cascade on delete | ||
| usti_context_id_foreign |
|
|
Cascade on delete | ||
| usti_chapter_id_foreign |
|
|
Cascade on delete | ||
| usti_submission_file_id_foreign |
|
|
Cascade on delete | ||
| usti_submission_id_foreign |
|
|
Cascade on delete | ||
| usti_representation_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 |
Check Constraints
| Table | Constraint Name | Constraint |
|---|