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
tbl_bulkfinds.[category] lkp_lithic_category.[category]
tbl_contexts_bkup.[category] lkp_lithic_category.[category]
tbl_lithic_audit.[category] lkp_lithic_category.[category]
tbl_lithic_audit.[classification] lkp_lithic_classification.[classification]
tbl_lithic_audit.[raw_material] lkp_lithic_raw_material.[raw_material]
tbl_lithic_audit.[survival] lkp_lithic_survival.[survival]
tbl_pot.[category] lkp_lithic_category.[category]

Tables without indexes

Table Rows
lkp_finds_class 46
lkp_material 10
lkp_materialcategory 5
lkp_mirrortypes 13
lkp_period 8

Tables that contain a single column

Table Column
lkp_materialcategory
lkp_period

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