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

{{#impliedConstraints}} {{/impliedConstraints}} {{^impliedConstraints}} {{/impliedConstraints}}
Child Column Implied Parent Column
{{childTable.name}}.{{childColumns}} {{parentTable.name}}.{{parentColumns}}
Anomaly not detected

Tables without indexes

{{#displayNumRows}} {{/displayNumRows}} {{#unIndexedTables}} {{#displayNumRows}} {{/displayNumRows}} {{/unIndexedTables}} {{^unIndexedTables}} {{/unIndexedTables}}
TableRows
{{name}}{{numRows}}
Anomaly not detected

Tables that contain a single column

{{#oneColumnTables}} {{#columns}} {{/columns}} {{/oneColumnTables}} {{^oneColumnTables}} {{/oneColumnTables}}
Table Column
{{name}}{{name}}
Anomaly not detected

Tables with incrementing column names, potentially indicating denormalization

{{#incrementingColumnNames}} {{/incrementingColumnNames}} {{^incrementingColumnNames}} {{/incrementingColumnNames}}
Table
{{name}}
Anomaly not detected

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

{{#uniqueNullables}} {{/uniqueNullables}} {{^uniqueNullables}} {{/uniqueNullables}}
Table
{{table.name}}.{{name}}
Anomaly not detected