MIMIC IV E-R

Tables (31)

admissions

  • hadm_id — INT NOT NULL — Primary key
  • admittime — TIMESTAMP NOT NULL
  • dischtime — TIMESTAMP — NOT NULL
  • deathtime — TIMESTAMP — NOT NULL
  • admission_type — VARCHAR(40) NOT NULL
  • admit_provider_id — VARCHAR(10) — NOT NULL
  • admission_location — VARCHAR(60) — NOT NULL
  • discharge_location — VARCHAR(60) — NOT NULL
  • insurance — VARCHAR(255) — NOT NULL
  • language — VARCHAR(10) — NOT NULL
  • marital_status — VARCHAR(30) — NOT NULL
  • race — VARCHAR(80) — NOT NULL
  • edregtime — TIMESTAMP — NOT NULL
  • edouttime — TIMESTAMP — NOT NULL
  • hospital_expire_flag — SMALLINT — NOT NULL
  • subject_id (Key) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL

caregiver

  • caregiver_id — INT NOT NUL L — Primary key

chartevents

  • stay_id — INT NOT NULL — Primary key
  • caregiver_id — INT
  • charttime — TIMESTAMP NOT NULL
  • storetime — TIMESTAMP
  • value — VARCHAR(200)
  • valuenum — FLOAT
  • valueuom — VARCHAR(20)
  • warning — SMALLINT

d_hcpcs

  • code — CHAR(5) NOT NULL — Primary key — NOT NULL
  • category — SMALLINT — NOT NULL
  • long_description — TEXT — NOT NULL
  • short_description — VARCHAR(180)

d_icd_diagnoses

  • icd_code — CHAR(7) NOT NULL — Primary key — NOT NULL
  • icd_version — SMALLINT NOT NULL — Primary key
  • long_title — VARCHAR(255) — NOT NULL

d_icd_procedures

  • icd_code — CHAR(7) NOT NULL — Primary key — NOT NULL
  • icd_version — SMALLINT NOT NULL — Primary key
  • long_title — VARCHAR(222) — NOT NULL

d_items

  • itemid (Field) — INT NOT NULL — Primary key
  • label (Field2) — VARCHAR(100) NOT NULL
  • abbreviation (Field3) — VARCHAR(50) NOT NULL
  • linksto (Field4) — VARCHAR(30) NOT NULL
  • category (Field5) — VARCHAR(50) NOT NULL
  • unitname (Field6) — VARCHAR(50)
  • param_type (Field7) — VARCHAR(20) NOT NULL
  • lownormalvalue (Field8) — FLOAT
  • highnormalvalue (Field9) — FLOAT

d_labitems

  • itemid — INT NOT NULL — Primary key — NOT NULL
  • label — VARCHAR(50)
  • fluid — VARCHAR(50)
  • category — VARCHAR(50)

datetimeevents (Untitled2)

  • itemid (Field7) — INT NOT NULL — Primary key
  • stay_id (Field3) — INT NOT NULL
  • caregiver_id (Field4) — INT
  • charttime (Field5) — TIMESTAMP NOT NULL
  • storetime (Field6) — TIMESTAMP
  • value (Field8) — TIMESTAMP NOT NULL
  • valueom (Field9) — TIMESTAMP NOT NULL
  • warning (Field10) — SMALLINT
  • itemid (Field) — INT NOT NULL — Foreign key → d_items.itemid
  • subject_id (Key) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL
  • stay_id (Field32) — INT NOT NULL — Foreign key → icustays.stay_id
  • hadm_id — INT NOT NULL — Foreign key → admissions.hadm_id

diagnoses_icd

  • hadm_id — INT NOT NULL — Primary key
  • seq_num — INT NOT NULL — Primary key
  • icd_code — CHAR(7) — Primary key — NOT NULL
  • icd_version — SMALLINT — Primary key
  • hadm_id (hadm_id2) — INT NOT NULL — Foreign key → admissions.hadm_id
  • subject_id (Key) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL

drgcodes

  • hadm_id — INT NOT NULL — Primary key
  • hadm_id (hadm_id2) — INT NOT NULL — Foreign key → admissions.hadm_id
  • drg_type — VARCHAR(4) — NOT NULL
  • drg_code — VARCHAR(10) NOT NULL
  • description — VARCHAR(195)
  • drg_severity — SMALLINT — NOT NULL
  • drg_mortality — SMALLINT — NOT NULL
  • subject_id (Key) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL

emar

  • emar_id — VARCHAR(25) NOT NULL — Primary key
  • emar_seq — INT NOT NULL
  • poe_id — VARCHAR(25) NOT NULL
  • pharmacy_id — INT
  • enter_provider_id — VARCHAR(10)
  • charttime — TIMESTAMP NOT NULL
  • medication — TEXT
  • event_txt — VARCHAR(100)
  • scheduletime — TIMESTAMP
  • storetime — TIMESTAMP NOT NULL
  • hadm_id — INT NOT NULL — Foreign key → admissions.hadm_id
  • subject_id (Key) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL

emar_detail (Untitled)

  • emar_id (Key2) — VARCHAR(25) NOT NULL — Primary key — NOT NULL
  • parent_field_ordinal (Key) — VARCHAR(10) — Primary key — NOT NULL
  • emar_seq (Field3) — INT NOT NULL
  • administration_type (Field5) — VARCHAR(50)
  • pharmacy_id (Field6) — INT
  • barcode_type (Field7) — VARCHAR(4)
  • reason_for_no_barcode (Field8) — TEXT
  • complete_dose_not_given (Field9) — VARCHAR(5)
  • dose_due (Field10) — VARCHAR(100)
  • dose_due_unit (Field11) — VARCHAR(50)
  • dose_given (Field12) — VARCHAR(255)
  • dose_given_unit (Field13) — VARCHAR(50)
  • will_remainder_of_dose_be_given (Field14) — VARCHAR(5)
  • product_amount_given (Field15) — VARCHAR(30)
  • product_unit (Field16) — VARCHAR(30)
  • product_code (Field17) — VARCHAR(30)
  • product_description (Field18) — VARCHAR(255)
  • product_description_other (Field19) — VARCHAR(255)
  • prior_infusion_rate (Field20) — VARCHAR(40)
  • infusion_rate (Field21) — VARCHAR(40)
  • infusion_rate_adjustment (Field22) — VARCHAR(50)
  • infusion_rate_adjustment_amount (Field23) — VARCHAR(30)
  • infusion_rate_unit (Field24) — VARCHAR(30)
  • route (Field25) — VARCHAR(10)
  • infusion_complete (Field26) — VARCHAR(1)
  • completion_interval (Field27) — VARCHAR(50)
  • new_iv_bag_hung (Field28) — VARCHAR(1)
  • continued_infusion_in_other_location (Field29) — VARCHAR(1)
  • restart_interval (Field30) — VARCHAR(2305)
  • side (Field31) — VARCHAR(10)
  • site (Field32) — VARCHAR(255)
  • non_formulary_visual_verification (Field33) — VARCHAR(1)
  • subject_id (Key3) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL
  • hadm_id — INT NOT NULL — Foreign key → admissions.hadm_id

hcpcsevents (Untitled8)

  • hadm_id (Key) — INT NOT NULL — Primary key — NOT NULL
  • hcpcs_cd (Key2) — CHAR(5) NOT NULL — Primary key — NOT NULL
  • seq_num (Key3) — INT NOT NULL — Primary key — NOT NULL
  • hadm_id — INT NOT NULL — Foreign key → admissions.hadm_id
  • hcpcs_cd — CHAR(5) NOT NULL — Foreign key → d_hcpcs.code — NOT NULL
  • chartdate (Field3) — DATE
  • short_description (Field6) — VARCHAR(180)
  • subject_id (Key4) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL

icustays (Untitled3)

  • stay_id (Field3) — INT NOT NULL — Primary key
  • first_careunit (Field4) — VARCHAR(255)
  • last_careunit (Field5) — VARCHAR(255)
  • intime (Field6) — TIMESTAMP
  • outtime (Field7) — TIMESTAMP
  • los (Field8) — FLOAT
  • subject_id (Key) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL
  • hadm_id — INT NOT NULL — Foreign key → admissions.hadm_id

ingredientevents (Untitled4)

  • itemid (Field8) — INTEGER NOT NULL — Primary key
  • orderid (Field13) — INT NOT NULL — Primary key
  • subject_id (Field) — INT NOT NULL
  • hadm_id (Field2) — INT NOT NULL
  • stay_id (Field3) — INT NOT NULL
  • caregiver_id (Field4) — INT
  • starttime (Field5) — TIMESTAMP NOT NULL
  • endtime (Field6) — TIMESTAMP NOT NULL
  • storetime (Field7) — TIMESTAMP
  • amount (Field9) — FLOAT
  • amountuom (Field10) — VARCHAR(20)
  • rate (Field11) — FLOAT
  • rateuom (Field12) — VARCHAR(20)
  • linkorderid (Field14) — INT
  • statusdescription (Field15) — VARCHAR(20)
  • originalamount (Field16) — FLOAT
  • ariginalrate (Field17) — FLOAT

inputevents (Untitled5)

  • orderid (Field13) — INT NOT NULL — Primary key
  • itemid (Field8) — INT NOT NULL — Primary key
  • itemid (Field20) — INT NOT NULL — Foreign key → d_items.itemid
  • Fieldsubject_id (Field) — INT NOT NULL
  • caregiver_id (Field4) — INT
  • starttime (Field5) — TIMESTAMP NOT NULL
  • endtime (Field6) — TIMESTAMP NOT NULL
  • storetime (Field7) — TIMESTAMP
  • amount (Field9) — FLOAT
  • amountuom (Field10) — VARCHAR(20)
  • rate (Field11) — FLOAT
  • rateuom (Field12) — VARCHAR(20)
  • linkorderid (Field14) — INT
  • ordercategoryname (Field15) — VARCHAR(50)
  • secondaryordercategoryname (Field16) — VARCHAR(50)
  • ordercomponenttypedescription (Field17) — VARCHAR(100)
  • ordercategorydescription (Field18) — VARCHAR(30)
  • patientweight (Field19) — FLOAT
  • hadm_id — INT NOT NULL — Foreign key → admissions.hadm_id
  • subject_id (Key) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL
  • stay_id (Field3) — INT NOT NULL — Foreign key → icustays.stay_id

labevents (Untitled9)

  • labevent_id (Key) — INT NOT NULL — Primary key — NOT NULL
  • hadm_id (Field3) — INT
  • specimen_id (Field4) — INT NOT NULL
  • order_provider_id (Field6) — VARCHAR(10)
  • charttime (Field7) — TIMESTAMP(0)
  • storetime (Field8) — TIMESTAMP(0)
  • value (Field9) — VARCHAR(200)
  • valuenum (Field10) — DOUBLE PRECISION
  • valueuom (Field11) — VARCHAR(20)
  • ref_range_lower (Field12) — DOUBLE PRECISION
  • ref_range_upper (Field13) — DOUBLE PRECISION
  • flag (Field14) — VARCHAR(10)
  • priority (Field15) — VARCHAR(7)
  • comments (Field16) — TEXT
  • subject_id (Key2) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL
  • hadm_id — INT NOT NULL — Foreign key → admissions.hadm_id

microbiologyevents (Untitled10)

  • microevent_id (Key) — INT NOT NULL — Primary key — NOT NULL
  • micro_specimen_id (Field4) — INT NOT NULL
  • order_provider_id (Field5) — VARCHAR(10)
  • chartdate (Field6) — TIMESTAMP(0) NOT NULL
  • charttime (Field7) — TIMESTAMP(0)
  • spec_itemid (Field8) — INT NOT NULL
  • spec_type_desc (Field9) — VARCHAR(100) NOT NULL
  • test_seq (Field10) — INT NOT NULL
  • storedate (Field11) — TIMESTAMP(0)
  • storetime (Field12) — TIMESTAMP(0)
  • test_itemid (Field13) — INT
  • test_name (Field14) — VARCHAR(100)
  • org_itemid (Field15) — INT
  • org_name (Field16) — VARCHAR(100)
  • isolate_num (Field17) — SMALLINT
  • quantity (Field18) — VARCHAR(50)
  • ab_itemid (Field19) — INT
  • ab_name (Field20) — VARCHAR(30)
  • dilution_text (Field21) — VARCHAR(10)
  • dilution_comparison (Field22) — VARCHAR(20)
  • dilution_value (Field23) — DOUBLE PRECISION
  • interpretation (Field24) — VARCHAR(5)
  • comments (Field25) — TEXT
  • subject_id (Key2) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL
  • hadm_id — INT NOT NULL — Foreign key → admissions.hadm_id

omr (Untitled11)

  • subject_id (Key) — INT NOT NULL — Primary key — NOT NULL
  • chartdate (Field2) — DATE NOT NULL
  • seq_num (Field3) — INT NOT NULL
  • result_name (Field4) — VARCHAR(100) NOT NULL
  • result_value (Field5) — TEXT NOT NULL

outputevents (Untitled6)

  • stay_id (Field3) — INT NOT NULL — Primary key
  • charttime (Field5) — TIMESTAMP(3) NOT NULL — Primary key
  • itemid (Field7) — INT NOT NULL — Primary key
  • itemid (Field10) — INT NOT NULL — Foreign key → d_items.itemid
  • caregiver_id (Field4) — INT
  • storetime (Field6) — TIMESTAMP(3) NOT NULL
  • value (Field8) — NOT NULL
  • valueuom (Field9) — VARCHAR(20)
  • hadm_id — INT NOT NULL — Foreign key → admissions.hadm_id
  • stay_id (Field32) — INT NOT NULL — Foreign key → icustays.stay_id
  • subject_id (Key) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL

patients (Untitled12)

  • subject_id (Key) — INT NOT NULL — Primary key — NOT NULL
  • gender (Field2) — CHAR(1) NOT NULL
  • anchor_age (Field3) — SMALLINT
  • anchor_year (Field4) — SMALLINT NOT NULL
  • anchor_year_group (Field5) — VARCHAR(20) NOT NULL
  • dod (Field6) — DATE

pharmacy (Untitled13)

  • pharmacy_id (Key) — INT NOT NULL — Primary key — NOT NULL
  • poe_id (Field4) — VARCHAR(25)
  • starttime (Field5) — TIMESTAMP(3)
  • stoptime (Field6) — TIMESTAMP(3)
  • medication (Field7) — TEXT
  • proc_type (Field8) — VARCHAR(50) NOT NULL
  • status (Field9) — VARCHAR(50)
  • entertime (Field10) — TIMESTAMP(3) NOT NULL
  • verifiedtime (Field11) — TIMESTAMP(3)
  • route (Field12) — VARCHAR(50)
  • frequency (Field13) — VARCHAR(50)
  • disp_sched (Field14) — VARCHAR(255)
  • infusion_type (Field15) — VARCHAR(15)
  • sliding_scale (Field16) — VARCHAR(1)
  • lockout_interval (Field17) — VARCHAR(50)
  • basal_rate (Field18) — REAL
  • one_hr_max (Field19) — VARCHAR(10)
  • doses_per_24_hrs (Field20) — REAL
  • duration (Field21) — REAL
  • duration_interval (Field22) — VARCHAR(50)
  • expiration_value (Field23) — INT
  • expiration_unit (Field24) — VARCHAR(50)
  • expirationdate (Field25) — TIMESTAMP(3)
  • dispensation (Field26) — VARCHAR(50)
  • fill_quantity (Field27) — VARCHAR(50)
  • subject_id (Key2) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL
  • hadm_id — INT NOT NULL — Foreign key → admissions.hadm_id

poe (Untitled14)

  • poe_id (Key) — VARCHAR(25) NOT NULL — Primary key — NOT NULL
  • poe_seq (Field2) — INT NOT NULL
  • subject_id (Field3) — INT NOT NULL
  • hadm_id (Field4) — INT
  • ordertime (Field5) — TIMESTAMP(0) NOT NULL
  • order_type (Field6) — VARCHAR(25) NOT NULL
  • order_subtype (Field7) — VARCHAR(50)
  • transaction_type (Field8) — VARCHAR(15)
  • discontinue_of_poe_id (Field9) — VARCHAR(25)
  • discontinued_by_poe_id (Field10) — VARCHAR(25)
  • order_provider_id (Field11) — VARCHAR(10)
  • order_status (Field12) — VARCHAR(15)
  • subject_id (Key2) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL
  • hadm_id — INT NOT NULL — Foreign key → admissions.hadm_id

poe_detail

  • poe_id — VARCHAR(25) NOT NULL — Primary key — NOT NULL
  • field_name — VARCHAR(255) NOT NULL — Primary key — NOT NULL
  • poe_id (Key2) — VARCHAR(25) NOT NULL — Foreign key → poe.poe_id — NOT NULL
  • poe_seq (poe_se) — INT NOT NULL
  • field_value — TEXT
  • subject_id (Key) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL

prescriptions

  • pharmacy_id — INT NOT NULL — Primary key — NOT NULL
  • drug_type — VARCHAR(20) NOT NULL — Primary key — NOT NULL
  • drug — VARCHAR(255) NOT NULL — Primary key — NOT NULL
  • poe_id — VARCHAR(25)
  • poe_seq — INT
  • order_provider_id — VARCHAR(10)
  • starttime — TIMESTAMP(3)
  • stoptime — TIMESTAMP(3)
  • formulary_drug_cd — VARCHAR(50)
  • gsn — VARCHAR(255)
  • ndc — VARCHAR(25)
  • prod_strength — VARCHAR(255)
  • form_rx — VARCHAR(25)
  • dose_val_rx — VARCHAR(100)
  • dose_unit_rx — VARCHAR(50)
  • form_val_disp — VARCHAR(50)
  • form_unit_disp — VARCHAR(50)
  • doses_per_24_hrs — REAL
  • route — VARCHAR(50)
  • subject_id (Key) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL
  • hadm_id — INT NOT NULL — Foreign key → admissions.hadm_id

procedureevents (Untitled7)

  • orderid (Field14) — INT — Primary key
  • caregiver_id (Field4) — INT
  • starttime (Field5) — TIMESTAMP NOT NULL
  • endtime (Field6) — TIMESTAMP NOT NULL
  • storetime (Field7) — TIMESTAMP NOT NULL
  • value (Field10) — FLOAT
  • valueuom (Field11) — VARCHAR(20)
  • location (Field12) — VARCHAR(100)
  • locationcategory (Field13) — VARCHAR(50)
  • linkorderid (Field15) — INT
  • ordercategoryname (Field16) — VARCHAR(50)
  • ordercategorydescription (Field17) — VARCHAR(30)
  • patientweight (Field18) — FLOAT
  • isopenbag (Field19) — SMALLINT
  • continueinnextdept (Field20) — SMALLINT
  • statusdescription (Field21) — VARCHAR(20)
  • itemid (Field) — INT NOT NULL — Foreign key → d_items.itemid
  • subject_id (Key) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL
  • stay_id (Field3) — INT NOT NULL — Foreign key → icustays.stay_id
  • hadm_id — INT NOT NULL — Foreign key → admissions.hadm_id

procedures_icd

  • hadm_id — INT NOT NULL — Primary key — NOT NULL
  • seq_num — INT NOT NULL — Primary key — NOT NULL
  • icd_code — VARCHAR(7) — Primary key — NOT NULL
  • icd_version — SMALLINT — Primary key — NOT NULL
  • hadm_id (hadm_id2) — INT NOT NULL — Foreign key → admissions.hadm_id
  • chartdate — DATE NOT NULL
  • subject_id (Key) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL

provider

  • provider_id — VARCHAR(10) NOT NULL — Primary key

services

  • hadm_id — INT NOT NULL — Primary key — NOT NULL
  • transfertime — TIMESTAMP NOT NULL — Primary key — NOT NULL
  • curr_service — VARCHAR(10) — Primary key — NOT NULL
  • hadm_id (hadm_id2) — INT NOT NULL — Foreign key → admissions.hadm_id
  • prev_service — VARCHAR(10)
  • subject_id (Key) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL

transfers

  • transfer_id — INT NOT NULL — Primary key
  • hadm_id — INT
  • eventtype — VARCHAR(10)
  • careunit — VARCHAR(255)
  • intime — TIMESTAMP
  • outtime — TIMESTAMP
  • subject_id (Key) — INT NOT NULL — Foreign key → patients.subject_id — NOT NULL