Constraints

183 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
review_form_element_settings_review_form_element_id
review_form_element_settings.review_form_element_id
review_form_elements.review_form_element_id
Cascade on delete
filters_filter_group_id_foreign
filters.filter_group_id
filter_groups.filter_group_id
Cascade on delete
series_categories_category_id
series_categories.category_id
categories.category_id
Cascade on delete
series_categories_series_id
series_categories.series_id
series.series_id
Cascade on delete
notification_settings_notification_id_foreign
notification_settings.notification_id
notifications.notification_id
Cascade on delete
review_round_files_review_round_id_foreign
review_round_files.review_round_id
review_rounds.review_round_id
Cascade on delete
review_round_files_submission_file_id_foreign
review_round_files.submission_file_id
submission_files.submission_file_id
Cascade on delete
review_round_files_submission_id_foreign
review_round_files.submission_id
submissions.submission_id
Cascade on delete
publications_submission_id
publications.submission_id
submissions.submission_id
Cascade on delete
publications_series_id
publications.series_id
series.series_id
Null on delete
publications_doi_id_foreign
publications.doi_id
dois.doi_id
Null on delete
publications_author_id
publications.primary_contact_id
authors.author_id
Null on delete
press_settings_press_id_foreign
press_settings.press_id
presses.press_id
Cascade on delete
spotlight_settings_spotlight_id_foreign
spotlight_settings.spotlight_id
spotlights.spotlight_id
Restrict delete
review_rounds_submission_id_foreign
review_rounds.submission_id
submissions.submission_id
Restrict delete
citations_publication
citations.publication_id
publications.publication_id
Cascade on delete
library_files_context_id
library_files.context_id
presses.press_id
Cascade on delete
library_files_submission_id_foreign
library_files.submission_id
submissions.submission_id
Cascade on delete
navigation_menu_item_assignments_navigation_menu_item_id_foreign
navigation_menu_item_assignments.navigation_menu_item_id
navigation_menu_items.navigation_menu_item_id
Cascade on delete
navigation_menu_item_assignments_navigation_menu_id_foreign
navigation_menu_item_assignments.navigation_menu_id
navigation_menus.navigation_menu_id
Cascade on delete
filter_settings_filter_id_foreign
filter_settings.filter_id
filters.filter_id
Cascade on delete
categories_parent_id_foreign
categories.parent_id
categories.category_id
Null on delete
categories_context_id_foreign
categories.context_id
presses.press_id
Cascade on delete
submission_chapters_publication_id
submission_chapters.publication_id
publications.publication_id
Cascade on delete
submission_chapters_doi_id_foreign
submission_chapters.doi_id
dois.doi_id
Null on delete
submission_chapters_primary_contact_id_foreign
submission_chapters.primary_contact_id
authors.author_id
Null on delete
submission_chapters_source_chapter_id_foreign
submission_chapters.source_chapter_id
submission_chapters.chapter_id
Null on delete
email_templates_context_id_foreign
email_templates.context_id
presses.press_id
Cascade on delete
navigation_menu_item_settings_navigation_menu_id
navigation_menu_item_settings.navigation_menu_item_id
navigation_menu_items.navigation_menu_item_id
Cascade on delete
submission_files_doi_id_foreign
submission_files.doi_id
dois.doi_id
Null on delete
submission_files_uploader_user_id_foreign
submission_files.uploader_user_id
users.user_id
Null on delete
submission_files_file_id_foreign
submission_files.file_id
files.file_id
Cascade on delete
submission_files_source_submission_file_id_foreign
submission_files.source_submission_file_id
submission_files.submission_file_id
Cascade on delete
submission_files_genre_id_foreign
submission_files.genre_id
genres.genre_id
Null on delete
submission_files_submission_id
submission_files.submission_id
submissions.submission_id
Cascade on delete
msm_context_id_foreign
metrics_counter_submission_monthly.context_id
presses.press_id
Cascade on delete
msm_submission_id_foreign
metrics_counter_submission_monthly.submission_id
submissions.submission_id
Cascade on delete
static_pages_context_id
static_pages.context_id
presses.press_id
Cascade on delete
markets_publication_format_id
markets.publication_format_id
publication_formats.publication_format_id
Cascade on delete
genres_context_id_foreign
genres.context_id
presses.press_id
Cascade on delete
msid_institution_id_foreign
metrics_counter_submission_institution_daily.institution_id
institutions.institution_id
Cascade on delete
msid_context_id_foreign
metrics_counter_submission_institution_daily.context_id
presses.press_id
Cascade on delete
msid_submission_id_foreign
metrics_counter_submission_institution_daily.submission_id
submissions.submission_id
Cascade on delete
user_group_stage_context_id
user_group_stage.context_id
presses.press_id
Cascade on delete
user_group_stage_user_group_id
user_group_stage.user_group_id
user_groups.user_group_id
Cascade on delete
submission_search_object_submission
submission_search_objects.submission_id
submissions.submission_id
Cascade on delete
review_assignments_submission_id_foreign
review_assignments.submission_id
submissions.submission_id
Restrict delete
review_assignments_review_round_id_foreign
review_assignments.review_round_id
review_rounds.review_round_id
Restrict delete
review_assignments_review_form_id_foreign
review_assignments.review_form_id
review_forms.review_form_id
Restrict delete
review_assignments_reviewer_id_foreign
review_assignments.reviewer_id
users.user_id
Restrict delete
data_object_tombstone_settings_tombstone_id
data_object_tombstone_settings.tombstone_id
data_object_tombstones.tombstone_id
Cascade on delete
identification_codes_publication_format_id
identification_codes.publication_format_id
publication_formats.publication_format_id
Cascade on delete
publication_settings_publication_id_foreign
publication_settings.publication_id
publications.publication_id
Cascade on delete
announcement_types_context_id_foreign
announcement_types.context_id
presses.press_id
Cascade on delete
submission_chapter_settings_chapter_id_foreign
submission_chapter_settings.chapter_id
submission_chapters.chapter_id
Cascade on delete
notifications_context_id_foreign
notifications.context_id
presses.press_id
Cascade on delete
notifications_user_id_foreign
notifications.user_id
users.user_id
Cascade on delete
publication_dates_publication_format_id
publication_dates.publication_format_id
publication_formats.publication_format_id
Cascade on delete
announcement_type_settings_type_id_foreign
announcement_type_settings.type_id
announcement_types.type_id
Cascade on delete
notification_subscription_settings_context_foreign
notification_subscription_settings.context
presses.press_id
Cascade on delete
notification_subscription_settings_user_id_foreign
notification_subscription_settings.user_id
users.user_id
Cascade on delete
submissions_context_id
submissions.context_id
presses.press_id
Cascade on delete
submissions_publication_id
submissions.current_publication_id
publications.publication_id
Null on delete
user_interests_user_id_foreign
user_interests.user_id
users.user_id
Cascade on delete
user_interests_controlled_vocab_entry_id_foreign
user_interests.controlled_vocab_entry_id
controlled_vocab_entries.controlled_vocab_entry_id
Cascade on delete
doi_settings_doi_id_foreign
doi_settings.doi_id
dois.doi_id
Cascade on delete
access_keys_user_id_foreign
access_keys.user_id
users.user_id
Cascade on delete
review_form_settings_review_form_id
review_form_settings.review_form_id
review_forms.review_form_id
Cascade on delete
series_settings_series_id
series_settings.series_id
series.series_id
Cascade on delete
authors_user_group_id_foreign
authors.user_group_id
user_groups.user_group_id
Cascade on delete
authors_publication_id_foreign
authors.publication_id
publications.publication_id
Cascade on delete
msgd_submission_id_foreign
metrics_submission_geo_daily.submission_id
submissions.submission_id
Cascade on delete
msgd_context_id_foreign
metrics_submission_geo_daily.context_id
presses.press_id
Cascade on delete
msgm_submission_id_foreign
metrics_submission_geo_monthly.submission_id
submissions.submission_id
Cascade on delete
msgm_context_id_foreign
metrics_submission_geo_monthly.context_id
presses.press_id
Cascade on delete
submission_file_revisions_file_id_foreign
submission_file_revisions.file_id
files.file_id
Cascade on delete
submission_file_revisions_submission_file_id_foreign
submission_file_revisions.submission_file_id
submission_files.submission_file_id
Cascade on delete
features_submission_id_foreign
features.submission_id
submissions.submission_id
Cascade on delete
usi_institution_id_foreign
usage_stats_institution_temporary_records.institution_id
institutions.institution_id
Cascade on delete
review_files_review_id_foreign
review_files.review_id
review_assignments.review_id
Cascade on delete
review_files_submission_file_id_foreign
review_files.submission_file_id
submission_files.submission_file_id
Cascade on delete
user_group_settings_user_group_id_foreign
user_group_settings.user_group_id
user_groups.user_group_id
Cascade on delete
category_settings_category_id_foreign
category_settings.category_id
categories.category_id
Cascade on delete
library_file_settings_file_id_foreign
library_file_settings.file_id
library_files.file_id
Cascade on delete
email_templates_settings_email_id
email_templates_settings.email_id
email_templates.email_id
Cascade on delete
announcements_type_id_foreign
announcements.type_id
announcement_types.type_id
Null on delete
user_user_groups_user_id
user_user_groups.user_id
users.user_id
Cascade on delete
user_user_groups_user_group_id_foreign
user_user_groups.user_group_id
user_groups.user_group_id
Cascade on delete
review_form_elements_review_form_id
review_form_elements.review_form_id
review_forms.review_form_id
Cascade on delete
metrics_submission_representation_id_foreign
metrics_submission.representation_id
publication_formats.publication_format_id
Cascade on delete
metrics_submission_chapter_id_foreign
metrics_submission.chapter_id
submission_chapters.chapter_id
Cascade on delete
metrics_submission_submission_file_id_foreign
metrics_submission.submission_file_id
submission_files.submission_file_id
Cascade on delete
metrics_submission_context_id_foreign
metrics_submission.context_id
presses.press_id
Cascade on delete
metrics_submission_submission_id_foreign
metrics_submission.submission_id
submissions.submission_id
Cascade on delete
submission_chapter_authors_author_id_foreign
submission_chapter_authors.author_id
authors.author_id
Cascade on delete
submission_chapter_authors_chapter_id_foreign
submission_chapter_authors.chapter_id
submission_chapters.chapter_id
Cascade on delete
submission_comments_submission_id
submission_comments.submission_id
submissions.submission_id
Cascade on delete
submission_comments_author_id_foreign
submission_comments.author_id
users.user_id
Cascade on delete
static_page_settings_static_page_id
static_page_settings.static_page_id
static_pages.static_page_id
Cascade on delete
spotlights_press_id_foreign
spotlights.press_id
presses.press_id
Cascade on delete
email_log_users_email_log_id_foreign
email_log_users.email_log_id
email_log.log_id
Cascade on delete
email_log_users_user_id_foreign
email_log_users.user_id
users.user_id
Cascade on delete
institution_settings_institution_id_foreign
institution_settings.institution_id
institutions.institution_id
Cascade on delete
institutions_context_id_foreign
institutions.context_id
presses.press_id
Cascade on delete
section_editors_context_id
subeditor_submission_group.context_id
presses.press_id
Cascade on delete
subeditor_submission_group_user_id
subeditor_submission_group.user_id
users.user_id
Cascade on delete
subeditor_submission_group_user_group_id_foreign
subeditor_submission_group.user_group_id
user_groups.user_group_id
Cascade on delete
publication_formats_publication_id
publication_formats.publication_id
publications.publication_id
Cascade on delete
publication_formats_doi_id_foreign
publication_formats.doi_id
dois.doi_id
Null on delete
author_settings_author_id
author_settings.author_id
authors.author_id
Cascade on delete
controlled_vocab_entries_controlled_vocab_id_foreign
controlled_vocab_entries.controlled_vocab_id
controlled_vocabs.controlled_vocab_id
Cascade on delete
submission_file_settings_submission_file_id_foreign
submission_file_settings.submission_file_id
submission_files.submission_file_id
Cascade on delete
event_log_settings_log_id
event_log_settings.log_id
event_log.log_id
Cascade on delete
metrics_context_context_id_foreign
metrics_context.context_id
presses.press_id
Cascade on delete
publication_format_settings_publication_format_id
publication_format_settings.publication_format_id
publication_formats.publication_format_id
Cascade on delete
data_object_tombstone_oai_set_objects_tombstone_id
data_object_tombstone_oai_set_objects.tombstone_id
data_object_tombstones.tombstone_id
Cascade on delete
temporary_files_user_id
temporary_files.user_id
users.user_id
Cascade on delete
review_form_responses_review_id_foreign
review_form_responses.review_id
review_assignments.review_id
Cascade on delete
review_form_responses_review_form_element_id_foreign
review_form_responses.review_form_element_id
review_form_elements.review_form_element_id
Cascade on delete
ustr_chapter_id_foreign
usage_stats_unique_title_requests_temporary_records.chapter_id
submission_chapters.chapter_id
Cascade on delete
ustr_submission_file_id_foreign
usage_stats_unique_title_requests_temporary_records.submission_file_id
submission_files.submission_file_id
Cascade on delete
ustr_submission_id_foreign
usage_stats_unique_title_requests_temporary_records.submission_id
submissions.submission_id
Cascade on delete
ustr_context_id_foreign
usage_stats_unique_title_requests_temporary_records.context_id
presses.press_id
Cascade on delete
ustr_representation_id_foreign
usage_stats_unique_title_requests_temporary_records.representation_id
publication_formats.publication_format_id
Cascade on delete
stage_assignments_user_id
stage_assignments.user_id
users.user_id
Cascade on delete
stage_assignments_user_group_id
stage_assignments.user_group_id
user_groups.user_group_id
Cascade on delete
stage_assignments_submission_id_foreign
stage_assignments.submission_id
submissions.submission_id
Cascade on delete
institution_ip_institution_id_foreign
institution_ip.institution_id
institutions.institution_id
Cascade on delete
assignment_settings_navigation_menu_item_assignment_id
navigation_menu_item_assignment_settings.navigation_menu_item_assignment_id
navigation_menu_item_assignments.navigation_menu_item_assignment_id
Cascade on delete
submission_settings_submission_id_foreign
submission_settings.submission_id
submissions.submission_id
Cascade on delete
new_releases_submission_id
new_releases.submission_id
submissions.submission_id
Cascade on delete
user_settings_user_id_foreign
user_settings.user_id
users.user_id
Cascade on delete
c_v_e_s_entry_id
controlled_vocab_entry_settings.controlled_vocab_entry_id
controlled_vocab_entries.controlled_vocab_entry_id
Cascade on delete
submission_search_object_keywords_keyword_id
submission_search_object_keywords.keyword_id
submission_search_keyword_list.keyword_id
Cascade on delete
submission_search_object_keywords_object_id_foreign
submission_search_object_keywords.object_id
submission_search_objects.object_id
Cascade on delete
usii_chapter_id_foreign
usage_stats_unique_item_investigations_temporary_records.chapter_id
submission_chapters.chapter_id
Cascade on delete
usii_submission_id_foreign
usage_stats_unique_item_investigations_temporary_records.submission_id
submissions.submission_id
Cascade on delete
usii_submission_file_id_foreign
usage_stats_unique_item_investigations_temporary_records.submission_file_id
submission_files.submission_file_id
Cascade on delete
usii_context_id_foreign
usage_stats_unique_item_investigations_temporary_records.context_id
presses.press_id
Cascade on delete
usii_representation_id_foreign
usage_stats_unique_item_investigations_temporary_records.representation_id
publication_formats.publication_format_id
Cascade on delete
notes_user_id_foreign
notes.user_id
users.user_id
Cascade on delete
event_log_user_id_foreign
event_log.user_id
users.user_id
Cascade on delete
dois_context_id_foreign
dois.context_id
presses.press_id
Cascade on delete
query_participants_user_id_foreign
query_participants.user_id
users.user_id
Cascade on delete
query_participants_query_id_foreign
query_participants.query_id
queries.query_id
Cascade on delete
msd_context_id_foreign
metrics_counter_submission_daily.context_id
presses.press_id
Cascade on delete
msd_submission_id_foreign
metrics_counter_submission_daily.submission_id
submissions.submission_id
Cascade on delete
usir_submission_id_foreign
usage_stats_unique_item_requests_temporary_records.submission_id
submissions.submission_id
Cascade on delete
usir_context_id_foreign
usage_stats_unique_item_requests_temporary_records.context_id
presses.press_id
Cascade on delete
usir_chapter_id_foreign
usage_stats_unique_item_requests_temporary_records.chapter_id
submission_chapters.chapter_id
Cascade on delete
usir_submission_file_id_foreign
usage_stats_unique_item_requests_temporary_records.submission_file_id
submission_files.submission_file_id
Cascade on delete
usir_representation_id_foreign
usage_stats_unique_item_requests_temporary_records.representation_id
publication_formats.publication_format_id
Cascade on delete
completed_payments_context_id
completed_payments.context_id
presses.press_id
Cascade on delete
completed_payments_user_id_foreign
completed_payments.user_id
users.user_id
Null on delete
announcement_settings_announcement_id_foreign
announcement_settings.announcement_id
announcements.announcement_id
Cascade on delete
msim_context_id_foreign
metrics_counter_submission_institution_monthly.context_id
presses.press_id
Cascade on delete
msim_submission_id_foreign
metrics_counter_submission_institution_monthly.submission_id
submissions.submission_id
Cascade on delete
msim_institution_id_foreign
metrics_counter_submission_institution_monthly.institution_id
institutions.institution_id
Cascade on delete
metrics_series_series_id_foreign
metrics_series.series_id
series.series_id
Cascade on delete
metrics_series_context_id_foreign
metrics_series.context_id
presses.press_id
Cascade on delete
series_press_id
series.press_id
presses.press_id
Cascade on delete
series_review_form_id
series.review_form_id
review_forms.review_form_id
Null on delete
sales_rights_publication_format_id
sales_rights.publication_format_id
publication_formats.publication_format_id
Cascade on delete
ust_context_id_foreign
usage_stats_total_temporary_records.context_id
presses.press_id
Cascade on delete
ust_representation_id_foreign
usage_stats_total_temporary_records.representation_id
publication_formats.publication_format_id
Cascade on delete
ust_chapter_id_foreign
usage_stats_total_temporary_records.chapter_id
submission_chapters.chapter_id
Cascade on delete
ust_submission_file_id_foreign
usage_stats_total_temporary_records.submission_file_id
submission_files.submission_file_id
Cascade on delete
ust_submission_id_foreign
usage_stats_total_temporary_records.submission_id
submissions.submission_id
Cascade on delete
ust_series_id_foreign
usage_stats_total_temporary_records.series_id
series.series_id
Cascade on delete
edit_decisions_editor_id
edit_decisions.editor_id
users.user_id
Cascade on delete
edit_decisions_review_round_id_foreign
edit_decisions.review_round_id
review_rounds.review_round_id
Cascade on delete
edit_decisions_submission_id
edit_decisions.submission_id
submissions.submission_id
Cascade on delete
genre_settings_genre_id_foreign
genre_settings.genre_id
genres.genre_id
Cascade on delete
representatives_submission_id
representatives.submission_id
submissions.submission_id
Cascade on delete
usti_context_id_foreign
usage_stats_unique_title_investigations_temporary_records.context_id
presses.press_id
Cascade on delete
usti_chapter_id_foreign
usage_stats_unique_title_investigations_temporary_records.chapter_id
submission_chapters.chapter_id
Cascade on delete
usti_submission_file_id_foreign
usage_stats_unique_title_investigations_temporary_records.submission_file_id
submission_files.submission_file_id
Cascade on delete
usti_submission_id_foreign
usage_stats_unique_title_investigations_temporary_records.submission_id
submissions.submission_id
Cascade on delete
usti_representation_id_foreign
usage_stats_unique_title_investigations_temporary_records.representation_id
publication_formats.publication_format_id
Cascade on delete
sessions_user_id
sessions.user_id
users.user_id
Cascade on delete
publication_categories_category_id_foreign
publication_categories.category_id
categories.category_id
Cascade on delete
publication_categories_publication_id_foreign
publication_categories.publication_id
publications.publication_id
Cascade on delete
citation_settings_citation_id
citation_settings.citation_id
citations.citation_id
Cascade on delete

Check Constraints

Table Constraint Name Constraint