Anomalies

Columns whose name and type imply a relationship to another table's primary key

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

Tables without indexes

| Table | {{#displayNumRows}} Rows | {{/displayNumRows}} | --- | --- | {{#unIndexedTables}} | {{name}} | {{#displayNumRows}} {{numRows}} | {{/displayNumRows}} {{/unIndexedTables}} {{^unIndexedTables}} | Anomaly not detected | {{/unIndexedTables}}

Tables that contain a single column

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

Tables with incrementing column names, potentially indicating denormalization

Table
{{#incrementingColumnNames}}
{{/incrementingColumnNames}} {{^incrementingColumnNames}}
{{/incrementingColumnNames}}

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

Table
{{#uniqueNullables}}
{{/uniqueNullables}} {{^uniqueNullables}}
{{/uniqueNullables}}