SchemaSpy Analysis of postgres.mimic - 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:
  Anomaly not detected

• Tables without indexes:

  Table	Rows
  chartevents_1	0
  chartevents_10	0
  chartevents_11	0
  chartevents_12	0
  chartevents_13	0
  chartevents_14	0
  chartevents_2	0
  chartevents_3	0
  chartevents_4	0
  chartevents_5	0
  chartevents_6	0
  chartevents_7	0
  chartevents_8	0
  chartevents_9	0

  14 instances of anomaly detected

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

• Tables that contain a single column:
  Anomaly not 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