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
jtbl_megastructure_geologicage.[megastructureid] tbl_megastructuredata.[megastructureid]
jtbl_tlkpmicrocarbonategrains.[microstructureid] tbl_microstructuredata.[microstructureid]
tbl_megastructuredata.[citationgroupid] tbl_citationgroup.[citationgroupid]
tbl_megastructuredata.[collectionid] tbl_collections.[collectionid]

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
tbl_query_builder_fields
tlkpmegageotimescale

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

Table
Anomaly not detected