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
pgbench_accounts.[bid] pgbench_branches.[bid]
pgbench_history.[aid] pgbench_accounts.[aid]
pgbench_history.[bid] pgbench_branches.[bid]
pgbench_history.[tid] pgbench_tellers.[tid]
pgbench_tellers.[bid] pgbench_branches.[bid]
wagtailcore_page.[slug] cms_slugpage.[slug]

Tables without indexes

Table Rows
pgbench_history 10

Tables that contain a single column

Table Column
Anomaly not detected

Tables with incrementing column names, potentially indicating denormalization

Table
data_allegation
data_officer
lawsuit_lawsuit

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

Table
Anomaly not detected