# 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
--- | ---
fichier_fiabilisation.[id_comm] | commission.[id_comm]
fichier_fiabilisation.[id_fichier] | fichier.[id_fichier]
fichier_fiabilisation.[id_pj] | piece_justif.[id_pj]
pj_opi.[id_fichier] | fichier.[id_fichier]

### Tables without indexes

Table | Rows
--- | ---
Anomaly not detected

### Tables that contain a single column

Table | Column
--- | ---
batch_run |
z_individu_actif |

### Tables with incrementing column names, potentially indicating denormalization

Table
Anomaly not detected

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

Table
Anomaly not detected