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]
admin_sticky_filters.[userId] user.[id]
aspen_lida_notifications_library.[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]
ce_campaign_extra_credit_activity_users_progress.[userId] user.[id]
ce_campaign_library_access.[libraryId] library.[libraryId]
ce_campaign_milestone_progress_entries.[userId] user.[id]
ce_campaign_milestone_users_progress.[userId] user.[id]
ce_user_campaign.[userId] user.[id]
ce_user_campaign_data.[userId] user.[id]
ce_user_completed_milestones.[userId] user.[id]
collection_spotlights.[libraryId] library.[libraryId]
component_ticket_link.[ticketId] ticket.[id]
donations_dedicate_type.[donationSettingId] donations.[id]
donations_earmark.[donationSettingId] donations.[id]
donations_value.[donationSettingId] donations.[id]
ebsco_research_starter_dismissals.[userId] user.[id]
ebscohost_database.[searchSettingId] search.[id]
event.[sublocationId] sublocation.[id]
event_event_field.[eventFieldId] event.[id]
event_event_field.[eventId] event.[id]
event_field_set_field.[eventFieldId] event.[id]
event_field_set_field.[eventFieldSetId] event.[id]
event_instance.[eventId] event.[id]
event_instance.[sublocationId] sublocation.[id]
event_library_map_values.[libraryId] library.[libraryId]
event_type.[eventFieldSetId] event.[id]
event_type_library.[eventTypeId] event.[id]
event_type_library.[libraryId] library.[libraryId]
event_type_location.[eventTypeId] event.[id]
greenhouse_cache.[libraryId] library.[libraryId]
grouped_work_record_item_url.[scopeId] scope.[id]
grouped_work_record_items.[subLocationCodeId] sublocation.[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_email_template.[libraryId] library.[libraryId]
library_events_facet_setting.[eventsFacetGroupId] event.[id]
library_events_facet_setting.[libraryId] library.[libraryId]
library_events_setting.[eventsFacetSettingsId] event.[id]
library_events_setting.[libraryId] library.[libraryId]
library_ill_item_type.[libraryId] library.[libraryId]
library_links.[libraryId] library.[libraryId]
library_open_archives_collection.[libraryId] library.[libraryId]
library_overdrive_scope.[libraryId] library.[libraryId]
library_overdrive_scope.[scopeId] scope.[id]
library_overdrive_settings.[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_custom_web_resource_page.[libraryId] library.[libraryId]
library_web_builder_grapes_page.[libraryId] library.[libraryId]
library_web_builder_portal_page.[libraryId] library.[libraryId]
library_web_builder_quick_poll.[libraryId] library.[libraryId]
library_web_builder_resource.[libraryId] library.[libraryId]
library_website_indexing.[libraryId] library.[libraryId]
library_year_in_review.[libraryId] library.[libraryId]
location.[libraryId] library.[libraryId]
location_cloud_library_scope.[scopeId] scope.[id]
location_overdrive_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_format_mapping.[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]
role_permissions.[roleId] roles.[roleId]
self_registration_sierra.[libraryId] library.[libraryId]
series_member.[seriesId] series.[id]
staff_members.[libraryId] library.[libraryId]
sublocation_ptype.[sublocationId] sublocation.[id]
system_message_dismissal.[userId] user.[id]
system_message_library.[libraryId] library.[libraryId]
two_factor_auth_codes.[userId] user.[id]
usage_by_user_agent.[userAgentId] user.[id]
user_account_summary.[userId] user.[id]
user_administration_locations.[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_messages.[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_page_defaults.[userId] user.[id]
user_palace_project_usage.[userId] user.[id]
user_payments.[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_summon_usage.[userId] user.[id]
user_vdx_request.[userId] user.[id]
user_website_usage.[userId] user.[id]
user_work_review.[userId] user.[id]
user_year_in_review.[userId] user.[id]
web_builder_custom_from_submission.[libraryId] library.[libraryId]
web_builder_custom_from_submission.[userId] user.[id]
web_builder_quick_poll_submission.[libraryId] library.[libraryId]
web_builder_quick_poll_submission.[userId] user.[id]
web_builder_resource_access_library.[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
aspen_lida_branded_settings
development_priorities
donations
greenhouse_settings
indexing_profiles
location
overdrive_api_product_formats
rosen_levelup_settings
self_reg_municipality_values_sierra
self_registration_form_sierra
self_registration_sierra
user_checkout
user_hold
user_messages

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

Table
Anomaly not detected