Tables Relationships Utility Tables Constraints Anomalies Columns Donate

SchemaSpy Analysis of ecandidat - Anomalies | Generated by SchemaSpy

Things that might not be 'quite right' about your schema: |

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

  Child Column | Implied Parent Column
  --- | ---
  fichier_fiabilisation.id_cand | candidature.id_cand
  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
  siscol_com_bdi.cod_com | siscol_commune.cod_com

  6 instances of anomaly detected

- Tables without indexes:
  Anomaly not detected

- Columns that are flagged as both 'nullable' and 'must be unique':
  Anomaly not detected

- Tables that contain a single column:

  Table | Column
  --- | ---
  batch_run | dat_last_check_run

  1 instance of anomaly detected

- Tables with incrementing column names, potentially indicating denormalization:
  Anomaly not detected

- Columns whose default value is the word 'NULL' or 'null', but the SQL NULL value may have been intended:
  Anomaly not detected