| SchemaSpy Analysis of mimic.mimiciii | Generated by SchemaSpy |
| Generated by SchemaSpy on Thu Oct 12 12:29 EDT 2017 | |
| Database Type: PostgreSQL - 9.5.9 |
|
XML Representation Insertion Order Deletion Order (for database loading/purging scripts) |
| Table | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| admissions | 18 | 1 | 19 | 58,976 | Hospital admissions associated with an ICU stay. |
| callout | 2 | 24 | 34,499 | Record of when patients were ready for discharge (called out), and the actual time of their discharge (or more generally, their outcome). | |
| caregivers | 7 | 4 | 7,567 | List of caregivers associated with an ICU stay. | |
| chartevents | 5 | 15 | 330,712,483 | Events occuring on a patient chart. | |
| chartevents_1 | 15 | 38,033,561 | Partition of chartevents. Should not be directly queried. | ||
| chartevents_10 | 15 | 9,584,888 | Partition of chartevents. Should not be directly queried. | ||
| chartevents_11 | 15 | 470,141 | Partition of chartevents. Should not be directly queried. | ||
| chartevents_12 | 15 | 265,413 | Partition of chartevents. Should not be directly queried. | ||
| chartevents_13 | 15 | 39,066,570 | Partition of chartevents. Should not be directly queried. | ||
| chartevents_14 | 15 | 100,075,138 | Partition of chartevents. Should not be directly queried. | ||
| chartevents_2 | 15 | 13,116,197 | Partition of chartevents. Should not be directly queried. | ||
| chartevents_3 | 15 | 38,657,533 | Partition of chartevents. Should not be directly queried. | ||
| chartevents_4 | 15 | 9,374,587 | Partition of chartevents. Should not be directly queried. | ||
| chartevents_5 | 15 | 18,201,026 | Partition of chartevents. Should not be directly queried. | ||
| chartevents_6 | 15 | 28,014,688 | Partition of chartevents. Should not be directly queried. | ||
| chartevents_7 | 15 | 255,967 | Partition of chartevents. Should not be directly queried. | ||
| chartevents_8 | 15 | 34,322,082 | Partition of chartevents. Should not be directly queried. | ||
| chartevents_9 | 15 | 1,274,692 | Partition of chartevents. Should not be directly queried. | ||
| cptevents | 2 | 12 | 573,146 | Events recorded in Current Procedural Terminology. | |
| d_cpt | 9 | 134 | High-level dictionary of the Current Procedural Terminology. | ||
| d_icd_diagnoses | 1 | 4 | 14,710 | Dictionary of the International Classification of Diseases, 9th Revision (Diagnoses). | |
| d_icd_procedures | 1 | 4 | 3,898 | Dictionary of the International Classification of Diseases, 9th Revision (Procedures). | |
| d_items | 8 | 10 | 12,487 | Dictionary of non-laboratory-related charted items. | |
| d_labitems | 1 | 6 | 753 | Dictionary of laboratory-related items. | |
| datetimeevents | 5 | 14 | 4,485,937 | Events relating to a datetime. | |
| diagnoses_icd | 3 | 5 | 651,047 | Diagnoses relating to a hospital admission coded using the ICD9 system. | |
| drgcodes | 2 | 8 | 125,557 | Hospital stays classified using the Diagnosis-Related Group system. | |
| icustays | 8 | 2 | 12 | 61,532 | List of ICU admissions. |
| inputevents_cv | 4 | 22 | 17,527,935 | Events relating to fluid input for patients whose data was originally stored in the CareVue database. | |
| inputevents_mv | 5 | 31 | 3,618,991 | Events relating to fluid input for patients whose data was originally stored in the MetaVision database. | |
| labevents | 3 | 9 | 27,854,055 | Events relating to laboratory tests. | |
| microbiologyevents | 5 | 16 | 631,726 | Events relating to microbiology tests. | |
| noteevents | 3 | 11 | 2,083,180 | Notes associated with hospital stays. | |
| outputevents | 5 | 13 | 4,349,218 | Outputs recorded during the ICU stay. | |
| patients | 19 | 8 | 46,520 | Patients associated with an admission to the ICU. | |
| prescriptions | 3 | 19 | 4,156,450 | Medicines prescribed. | |
| procedureevents_mv | 5 | 25 | 258,066 | Procedure start and stop times recorded for MetaVision patients. | |
| procedures_icd | 3 | 5 | 240,095 | Procedures relating to a hospital admission coded using the ICD9 system. | |
| services | 2 | 6 | 73,343 | Hospital services that patients were under during their hospital stay. | |
| transfers | 3 | 13 | 261,897 | Location of patients during their hospital stay. | |
| 40 Tables | 534 | 728,556,685 | |||
| 0 Views | 0 |