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
batiment_groupe_dpe_representatif_logement.[identifiant_dpe] dpe_logement.[identifiant_dpe]
local.[parcelle_id] parcelle.[parcelle_id]

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
adresse_metrique
batiment_groupe_adresse
batiment_groupe_bdtopo_bat
batiment_groupe_dvf
batiment_groupe_ffo_bat
parcelle_unifiee_metrique
proprietaire

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

Table
Anomaly not detected