Anomalies


Things that might not be 'quite right' about your database and schema

Columns whose name and type imply a relationship to another table's primary key

Child Column Implied Parent Column
access_keys.[user_id] users.[user_id]
announcement_settings.[announcement_id] announcements.[announcement_id]
author_settings.[author_id] authors.[author_id]
authors.[publication_id] publications.[publication_id]
authors.[user_group_id] user_groups.[user_group_id]
category_settings.[category_id] categories.[category_id]
citation_settings.[citation_id] citations.[citation_id]
citations.[publication_id] publications.[publication_id]
completed_payments.[user_id] users.[user_id]
controlled_vocab_entries.[controlled_vocab_id] controlled_vocabs.[controlled_vocab_id]
controlled_vocab_entry_settings.[controlled_vocab_entry_id] controlled_vocab_entries.[controlled_vocab_entry_id]
custom_issue_orders.[issue_id] issues.[issue_id]
custom_issue_orders.[journal_id] journals.[journal_id]
custom_section_orders.[issue_id] issues.[issue_id]
custom_section_orders.[section_id] sections.[section_id]
edit_decisions.[review_round_id] review_rounds.[review_round_id]
edit_decisions.[submission_id] submissions.[submission_id]
email_log_users.[user_id] users.[user_id]
event_log.[user_id] users.[user_id]
filter_settings.[filter_id] filters.[filter_id]
filters.[filter_group_id] filter_groups.[filter_group_id]
genre_settings.[genre_id] genres.[genre_id]
institutional_subscription_ip.[subscription_id] subscriptions.[subscription_id]
institutional_subscriptions.[subscription_id] subscriptions.[subscription_id]
issue_files.[issue_id] issues.[issue_id]
issue_galleys.[issue_id] issues.[issue_id]
issue_settings.[issue_id] issues.[issue_id]
issues.[journal_id] journals.[journal_id]
item_views.[user_id] users.[user_id]
journal_settings.[journal_id] journals.[journal_id]
library_files.[submission_id] submissions.[submission_id]
metadata_description_settings.[metadata_description_id] metadata_descriptions.[metadata_description_id]
metrics.[pkp_section_id] sections.[section_id]
metrics.[submission_id] submissions.[submission_id]
navigation_menu_item_assignment_settings.[navigation_menu_item_assignment_id] navigation_menu_item_assignments.[navigation_menu_item_assignment_id]
navigation_menu_item_assignments.[navigation_menu_id] navigation_menus.[navigation_menu_id]
navigation_menu_item_assignments.[navigation_menu_item_id] navigation_menu_items.[navigation_menu_item_id]
navigation_menu_item_settings.[navigation_menu_item_id] navigation_menu_items.[navigation_menu_item_id]
notes.[user_id] users.[user_id]
notification_settings.[notification_id] notifications.[notification_id]
notification_subscription_settings.[user_id] users.[user_id]
notifications.[user_id] users.[user_id]
publication_categories.[category_id] categories.[category_id]
publication_categories.[publication_id] publications.[publication_id]
publication_galleys.[publication_id] publications.[publication_id]
publication_settings.[publication_id] publications.[publication_id]
publications.[section_id] sections.[section_id]
publications.[submission_id] submissions.[submission_id]
query_participants.[query_id] queries.[query_id]
query_participants.[user_id] users.[user_id]
review_assignments.[review_form_id] review_forms.[review_form_id]
review_assignments.[review_round_id] review_rounds.[review_round_id]
review_assignments.[submission_id] submissions.[submission_id]
review_files.[review_id] review_assignments.[review_id]
review_form_element_settings.[review_form_element_id] review_form_elements.[review_form_element_id]
review_form_elements.[review_form_id] review_forms.[review_form_id]
review_form_responses.[review_form_element_id] review_form_elements.[review_form_element_id]
review_form_responses.[review_id] review_assignments.[review_id]
review_form_settings.[review_form_id] review_forms.[review_form_id]
review_round_files.[review_round_id] review_rounds.[review_round_id]
review_round_files.[submission_id] submissions.[submission_id]
review_rounds.[submission_id] submissions.[submission_id]
section_settings.[section_id] sections.[section_id]
sections.[journal_id] journals.[journal_id]
sections.[review_form_id] review_forms.[review_form_id]
sessions.[user_id] users.[user_id]
stage_assignments.[submission_id] submissions.[submission_id]
stage_assignments.[user_group_id] user_groups.[user_group_id]
stage_assignments.[user_id] users.[user_id]
static_page_settings.[static_page_id] static_pages.[static_page_id]
subeditor_submission_group.[user_id] users.[user_id]
submission_comments.[author_id] authors.[author_id]
submission_comments.[submission_id] submissions.[submission_id]
submission_files.[genre_id] genres.[genre_id]
submission_files.[submission_id] submissions.[submission_id]
submission_files.[uploader_user_id] users.[user_id]
submission_search_object_keywords.[keyword_id] submission_search_keyword_list.[keyword_id]
submission_search_objects.[submission_id] submissions.[submission_id]
submission_settings.[submission_id] submissions.[submission_id]
submission_tombstones.[journal_id] journals.[journal_id]
submission_tombstones.[section_id] sections.[section_id]
submission_tombstones.[submission_id] submissions.[submission_id]
submissions.[current_publication_id] publications.[publication_id]
subscription_types.[journal_id] journals.[journal_id]
subscriptions.[journal_id] journals.[journal_id]
subscriptions.[user_id] users.[user_id]
temporary_files.[user_id] users.[user_id]
user_group_settings.[user_group_id] user_groups.[user_group_id]
user_group_stage.[user_group_id] user_groups.[user_group_id]
user_interests.[controlled_vocab_entry_id] controlled_vocab_entries.[controlled_vocab_entry_id]
user_interests.[user_id] users.[user_id]
user_settings.[user_id] users.[user_id]
user_user_groups.[user_group_id] user_groups.[user_group_id]
user_user_groups.[user_id] users.[user_id]
users.[auth_id] auth_sources.[auth_id]

Tables without indexes

Table Rows
site 0
usage_stats_temporary_records 19

Tables that contain a single column

Table Column
Anomaly not detected

Tables with incrementing column names, potentially indicating denormalization

Table
Anomaly not detected

Columns whose default value is the word 'NULL' or 'null'

Table
Anomaly not detected