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]
aqbooksellers.[currency] currency.[currency]
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]
collections_tracking.[colId] collections.[colId]
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]
import_biblios.[isbn] social_data.[isbn]
item_circulation_alert_preferences.[categorycode] categories.[categorycode]
items.[cn_source] class_sources.[cn_source]
marc_matchers.[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]
reports_dictionary.[name] items_search_fields.[name]
saved_sql.[report_name] items_search_fields.[name]
search_field.[name] items_search_fields.[name]
search_history.[type] account_offset_types.[type]
sms_providers.[name] items_search_fields.[name]
statistics.[itemtype] itemtypes.[itemtype]
statistics.[type] account_offset_types.[type]
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

Tables with incrementing column names, potentially indicating denormalization

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

Table
Anomaly not detected