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
accelerated_reading_isbn.[arBookId] accelerated_reading_titles.[arBookId]
accelerated_reading_subject_to_title.[arBookId] accelerated_reading_titles.[arBookId]
aspen_lida_notifications_library.[libraryId] library.[libraryId]
aspen_lida_quick_searches.[libraryId] library.[libraryId]
browse_category.[libraryId] library.[libraryId]
browse_category.[userId] user.[id]
browse_category_dismissal.[userId] user.[id]
browse_category_group_users.[userId] user.[id]
collection_spotlights.[libraryId] library.[libraryId]
component_ticket_link.[ticketId] ticket.[id]
development_task_developer_link.[userId] user.[id]
development_task_qa_link.[userId] user.[id]
development_task_ticket_link.[ticketId] ticket.[id]
donations_dedicate_type.[donationSettingId] donations.[id]
donations_earmark.[donationSettingId] donations.[id]
donations_form_fields.[donationSettingId] donations.[id]
donations_value.[donationSettingId] donations.[id]
ebsco_research_starter_dismissals.[userId] user.[id]
ebscohost_database.[searchSettingId] search.[id]
event_library_map_values.[libraryId] library.[libraryId]
greenhouse_cache.[libraryId] library.[libraryId]
grouped_work_record_item_url.[scopeId] scope.[id]
hold_request_confirmation.[userId] user.[id]
holiday.[libraryId] library.[libraryId]
hoopla_settings.[libraryId] library.[libraryId]
host_information.[libraryId] library.[libraryId]
javascript_snippet_library.[libraryId] library.[libraryId]
library.[donationSettingId] donations.[id]
library_cloud_library_scope.[libraryId] library.[libraryId]
library_cloud_library_scope.[scopeId] scope.[id]
library_combined_results_section.[libraryId] library.[libraryId]
library_events_setting.[libraryId] library.[libraryId]
library_links.[libraryId] library.[libraryId]
library_open_archives_collection.[libraryId] library.[libraryId]
library_records_to_include.[libraryId] library.[libraryId]
library_search_source.[libraryId] library.[libraryId]
library_sideload_scopes.[libraryId] library.[libraryId]
library_sideload_scopes.[sideLoadScopeId] sideloads.[id]
library_themes.[libraryId] library.[libraryId]
library_web_builder_basic_page.[libraryId] library.[libraryId]
library_web_builder_custom_form.[libraryId] library.[libraryId]
library_web_builder_portal_page.[libraryId] library.[libraryId]
library_web_builder_resource.[libraryId] library.[libraryId]
library_website_indexing.[libraryId] library.[libraryId]
location.[libraryId] library.[libraryId]
location_cloud_library_scope.[scopeId] scope.[id]
location_sideload_scopes.[sideLoadScopeId] sideloads.[id]
marriage.[personId] person.[personId]
materials_request.[libraryId] library.[libraryId]
materials_request_fields_to_display.[libraryId] library.[libraryId]
materials_request_form_fields.[libraryId] library.[libraryId]
materials_request_formats.[libraryId] library.[libraryId]
materials_request_status.[libraryId] library.[libraryId]
materials_request_usage.[libraryId] library.[libraryId]
obituary.[personId] person.[personId]
overdrive_account_cache.[userId] user.[id]
overdrive_api_product_availability.[libraryId] library.[libraryId]
pin_reset_token.[userId] user.[id]
placard_dismissal.[userId] user.[id]
placard_library.[libraryId] library.[libraryId]
redwood_user_contribution.[userId] user.[id]
role_permissions.[roleId] roles.[roleId]
staff_members.[libraryId] library.[libraryId]
system_message_dismissal.[userId] user.[id]
system_message_library.[libraryId] library.[libraryId]
two_factor_auth_codes.[userId] user.[id]
user_account_summary.[userId] user.[id]
user_axis360_usage.[userId] user.[id]
user_checkout.[userId] user.[id]
user_cloud_library_usage.[userId] user.[id]
user_ebsco_eds_usage.[userId] user.[id]
user_ebscohost_usage.[userId] user.[id]
user_events_entry.[userId] user.[id]
user_events_registrations.[userId] user.[id]
user_events_usage.[userId] user.[id]
user_hold.[userId] user.[id]
user_hoopla_usage.[userId] user.[id]
user_ils_usage.[userId] user.[id]
user_messages.[userId] user.[id]
user_not_interested.[userId] user.[id]
user_notification_tokens.[userId] user.[id]
user_notifications.[userId] user.[id]
user_open_archives_usage.[userId] user.[id]
user_overdrive_usage.[userId] user.[id]
user_payments.[userId] user.[id]
user_rbdigital_usage.[userId] user.[id]
user_reading_history_work.[userId] user.[id]
user_roles.[roleId] roles.[roleId]
user_roles.[userId] user.[id]
user_sideload_usage.[userId] user.[id]
user_vdx_request.[userId] user.[id]
user_website_usage.[userId] user.[id]
user_work_review.[userId] user.[id]
web_builder_custom_from_submission.[libraryId] library.[libraryId]
web_builder_custom_from_submission.[userId] user.[id]
web_builder_menu.[libraryId] library.[libraryId]

Tables without indexes

Table Rows
Anomaly not detected

Tables that contain a single column

Table Column
Anomaly not detected

Tables with incrementing column names, potentially indicating denormalization

Table
archive_requests
development_priorities
greenhouse_settings
location
overdrive_api_product_formats
rosen_levelup_settings
user_checkout
user_hold
user_messages

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

Table
Anomaly not detected