SchemaSpy Analysis of eicu.eicu_crd - 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
  admissiondrug	874,920
  admissiondx	626,858
  allergy	251,949
  apacheapsvar	171,177
  apachepatientresult	297,064
  apachepredvar	171,177
  careplancareprovider	502,765
  careplaneol	1,433
  careplangeneral	3,115,018
  careplangoal	504,139
  careplaninfectiousdisease	8,056
  customlab	1,082
  diagnosis	2,710,672
  hospital	208
  infusiondrug	4,803,719
  intakeoutput	12,030,289
  lab	39,132,531
  medication	7,301,853
  microlab	16,996
  note	2,254,179
  nurseassessment	15,602,498
  nursecare	8,311,132
  nursecharting	151,604,232
  pasthistory	1,149,180
  physicalexam	9,212,316
  respiratorycare	865,381
  respiratorycharting	20,168,176
  treatment	3,688,745
  vitalaperiodic	25,075,074
  vitalperiodic	146,671,642

  30 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:

  Table
  vitalperiodic

  1 instance of anomaly detected

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