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
additional_fields.[name] items_search_fields.[name]
aqbookseller_interfaces.[name] items_search_fields.[name]
auth_header.[authtypecode] auth_types.[authtypecode]
biblio.[frameworkcode] biblio_framework.[frameworkcode]
biblioitems.[cn_source] class_sources.[cn_source]
biblioitems.[itemtype] itemtypes.[itemtype]
borrower_files.[file_name] items_search_fields.[name]
borrower_modifications.[categorycode] categories.[categorycode]
branch_transfer_limits.[itemtype] itemtypes.[itemtype]
courses.[course_name] items_search_fields.[name]
deletedbiblio.[frameworkcode] biblio_framework.[frameworkcode]
deletedbiblioitems.[cn_source] class_sources.[cn_source]
deletedbiblioitems.[itemtype] itemtypes.[itemtype]
deletedborrowers.[categorycode] categories.[categorycode]
deleteditems.[cn_source] class_sources.[cn_source]
erm_agreements.[name] items_search_fields.[name]
erm_documents.[file_name] items_search_fields.[name]
erm_eholdings_packages.[name] items_search_fields.[name]
erm_eholdings_titles.[publisher_name] items_search_fields.[name]
erm_licenses.[name] items_search_fields.[name]
item_circulation_alert_preferences.[categorycode] categories.[categorycode]
items.[cn_source] class_sources.[cn_source]
localization.[code] borrower_attribute_types.[code]
message_queue.[letter_code] borrower_attribute_types.[code]
misc_files.[file_name] items_search_fields.[name]
oauth_access_tokens.[client_id] api_keys.[client_id]
overduerules.[categorycode] categories.[categorycode]
patron_lists.[name] items_search_fields.[name]
pseudonymized_transactions.[categorycode] categories.[categorycode]
pseudonymized_transactions.[itemtype] itemtypes.[itemtype]
reports_dictionary.[name] items_search_fields.[name]
saved_sql.[report_name] items_search_fields.[name]
search_field.[name] items_search_fields.[name]
search_filters.[name] items_search_fields.[name]
sms_providers.[name] items_search_fields.[name]
statistics.[categorycode] categories.[categorycode]
statistics.[itemtype] itemtypes.[itemtype]
subscription.[itemtype] itemtypes.[itemtype]
suggestions.[currency] currency.[currency]
suggestions.[isbn] social_data.[isbn]
tags_all.[term] tags_approval.[term]

Tables without indexes

Table Rows
browser 0

Tables that contain a single column

Table Column
message_transport_types message_transport_type

Tables with incrementing column names, potentially indicating denormalization

Table
aqbooksellers
aqorders
borrower_modifications
borrowers
branches
deletedborrowers
overduerules
pseudonymized_transactions
subscription
subscription_numberpatterns

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

Table
Anomaly not detected