Constraints

172 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
sections_journal_id
sections.journal_id
journals.journal_id
Cascade on delete
sections_review_form_id
sections.review_form_id
review_forms.review_form_id
Null on delete
notification_settings_notification_id_foreign
notification_settings.notification_id
notifications.notification_id
Cascade on delete
subscription_types_journal_id
subscription_types.journal_id
journals.journal_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_primary_contact_id
publications.primary_contact_id
authors.author_id
Null on delete
publications_section_id
publications.section_id
sections.section_id
Null on delete
publications_doi_id_foreign
publications.doi_id
dois.doi_id
Null on 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
journals.journal_id
Cascade on delete
library_files_submission_id_foreign
library_files.submission_id
submissions.submission_id
Cascade on delete
metrics_issue_context_id_foreign
metrics_issue.context_id
journals.journal_id
Cascade on delete
metrics_issue_issue_galley_id_foreign
metrics_issue.issue_galley_id
issue_galleys.galley_id
Cascade on delete
metrics_issue_issue_id_foreign
metrics_issue.issue_id
issues.issue_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
journals.journal_id
Cascade on delete
institutional_subscriptions_institution_id_foreign
institutional_subscriptions.institution_id
institutions.institution_id
Cascade on delete
institutional_subscriptions_subscription_id
institutional_subscriptions.subscription_id
subscriptions.subscription_id
Cascade on delete
email_templates_context_id_foreign
email_templates.context_id
journals.journal_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_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
journals.journal_id
Cascade on delete
msm_submission_id_foreign
metrics_counter_submission_monthly.submission_id
submissions.submission_id
Cascade on delete
journal_settings_journal_id
journal_settings.journal_id
journals.journal_id
Cascade on delete
static_pages_context_id
static_pages.context_id
journals.journal_id
Cascade on delete
genres_context_id_foreign
genres.context_id
journals.journal_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
journals.journal_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
journals.journal_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
publication_settings_publication_id
publication_settings.publication_id
publications.publication_id
Cascade on delete
announcement_types_context_id_foreign
announcement_types.context_id
journals.journal_id
Cascade on delete
notifications_context_id_foreign
notifications.context_id
journals.journal_id
Cascade on delete
notifications_user_id_foreign
notifications.user_id
users.user_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
journals.journal_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
journals.journal_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
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
journals.journal_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
journals.journal_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
issue_files_issue_id
issue_files.issue_id
issues.issue_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
issue_settings_issue_id
issue_settings.issue_id
issues.issue_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
publication_galley_settings_galley_id
publication_galley_settings.galley_id
publication_galleys.galley_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
publication_galleys_doi_id_foreign
publication_galleys.doi_id
dois.doi_id
Null on delete
publication_galleys_submission_file_id_foreign
publication_galleys.submission_file_id
submission_files.submission_file_id
Restrict delete
publication_galleys_publication_id
publication_galleys.publication_id
publications.publication_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_galleys.galley_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
journals.journal_id
Cascade on delete
metrics_submission_submission_id_foreign
metrics_submission.submission_id
submissions.submission_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
subscription_type_settings_type_id
subscription_type_settings.type_id
subscription_types.type_id
Cascade on delete
static_page_settings_static_page_id
static_page_settings.static_page_id
static_pages.static_page_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
journals.journal_id
Cascade on delete
issue_galleys_settings_galley_id
issue_galley_settings.galley_id
issue_galleys.galley_id
Cascade on delete
section_editors_context_id
subeditor_submission_group.context_id
journals.journal_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
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
journals.journal_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
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
user_settings_user_id_foreign
user_settings.user_id
users.user_id
Cascade on delete
custom_section_orders_section_id
custom_section_orders.section_id
sections.section_id
Cascade on delete
custom_section_orders_issue_id
custom_section_orders.issue_id
issues.issue_id
Cascade on delete
journals_current_issue_id_foreign
journals.current_issue_id
issues.issue_id
Null 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_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
journals.journal_id
Cascade on delete
usii_representation_id_foreign
usage_stats_unique_item_investigations_temporary_records.representation_id
publication_galleys.galley_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
journals.journal_id
Cascade on delete
custom_issue_orders_issue_id
custom_issue_orders.issue_id
issues.issue_id
Cascade on delete
custom_issue_orders_journal_id
custom_issue_orders.journal_id
journals.journal_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
journals.journal_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
journals.journal_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_galleys.galley_id
Cascade on delete
completed_payments_context_id
completed_payments.context_id
journals.journal_id
Cascade on delete
completed_payments_user_id
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
journals.journal_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
subscriptions_journal_id
subscriptions.journal_id
journals.journal_id
Cascade on delete
subscriptions_user_id
subscriptions.user_id
users.user_id
Cascade on delete
subscriptions_type_id
subscriptions.type_id
subscription_types.type_id
Cascade on delete
ust_issue_id_foreign
usage_stats_total_temporary_records.issue_id
issues.issue_id
Cascade on delete
ust_context_id_foreign
usage_stats_total_temporary_records.context_id
journals.journal_id
Cascade on delete
ust_representation_id_foreign
usage_stats_total_temporary_records.representation_id
publication_galleys.galley_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_issue_galley_id_foreign
usage_stats_total_temporary_records.issue_galley_id
issue_galleys.galley_id
Cascade on delete
issue_galleys_file_id
issue_galleys.file_id
issue_files.file_id
Cascade on delete
issue_galleys_issue_id
issue_galleys.issue_id
issues.issue_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
issues_journal_id
issues.journal_id
journals.journal_id
Cascade on delete
issues_doi_id_foreign
issues.doi_id
dois.doi_id
Null on delete
genre_settings_genre_id_foreign
genre_settings.genre_id
genres.genre_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
section_settings_section_id
section_settings.section_id
sections.section_id
Cascade on delete

Check Constraints

Table Constraint Name Constraint