333

Tables (27)

admissions

  • hadm_id — INT
  • subject_id — INT — Foreign key → patients.subject_id

chartevents

  • subject_id — INT — Foreign key
  • hadm_id — INT — Foreign key
  • stay_id — INT — Foreign key
  • itemid — INT — Foreign key → d_items.itemid

d_hcpcs

  • code — VARCHAR(50)

d_icd_diagnoses

  • icd_code — VARCHAR(20)
  • icd_version — INT

d_icd_procedures

  • icd_code — VARCHAR(20)
  • icd_version — INT

d_items

  • itemid — INT

d_labitems

  • itemid — INT

datetimeevents

  • stay_id — INT — Foreign key
  • itemid — INT — Foreign key → d_items.itemid
  • charttime — TIMESTAMP
  • subject_id — INT — Foreign key
  • hadm_id — INT — Foreign key

diagnoses_icd

  • hadm_id — INT — Foreign key
  • subject_id — INT — Foreign key
  • seq_num — INT
  • icd_code — VARCHAR(20)
  • icd_version — INT

drgcodes

  • subject_id — INT — Foreign key
  • hadm_id — INT — Foreign key

emar

  • emar_id — VARCHAR(100)
  • subject_id — INT — Foreign key
  • hadm_id — INT — Foreign key

emar_detail

  • emar_id — VARCHAR(100) — Foreign key → emar.emar_id
  • subject_id — INT — Foreign key
  • parent_field_ordinal — INT

hcpcsevents

  • hadm_id — INT — Foreign key
  • subject_id — INT — Foreign key
  • hcpcs_cd — VARCHAR(50) — Foreign key → d_hcpcs.code
  • seq_num — INT

icustays

  • stay_id — INT
  • subject_id — INT — Foreign key → patients.subject_id
  • hadm_id — INT — Foreign key → admissions.hadm_id

inputevents

  • orderid — INT
  • itemid — INT — Foreign key → d_items.itemid
  • subject_id — INT — Foreign key
  • hadm_id — INT — Foreign key
  • stay_id — INT — Foreign key

labevents

  • labevent_id — INT
  • subject_id — INT — Foreign key
  • hadm_id — INT
  • itemid — INT — Foreign key → d_labitems.itemid

microbiologyevents

  • microevent_id — INT
  • subject_id — INT — Foreign key
  • hadm_id — INT — Foreign key

outputevents

  • stay_id — INT — Foreign key
  • charttime — TIMESTAMP
  • itemid — INT — Foreign key → d_items.itemid
  • subject_id — INT — Foreign key
  • hadm_id — INT — Foreign key

patients

  • subject_id — INT

pharmacy

  • pharmacy_id — INT
  • subject_id — INT — Foreign key
  • hadm_id — INT — Foreign key

poe

  • poe_id — VARCHAR(100)
  • subject_id — INT — Foreign key
  • hadm_id — INT — Foreign key

poe_detail

  • poe_id — VARCHAR(100) — Foreign key → poe.poe_id
  • subject_id — INT — Foreign key
  • field_name — VARCHAR(100)

prescriptions

  • pharmacy_id — INT
  • subject_id — INT — Foreign key
  • hadm_id — INT — Foreign key
  • drug_type — VARCHAR(100)
  • drug — VARCHAR(255)

procedureevents

  • orderid — INT
  • subject_id — INT — Foreign key
  • hadm_id — INT — Foreign key
  • stay_id — INT — Foreign key
  • itemid — INT — Foreign key → d_items.itemid

procedures_icd

  • hadm_id — INT — Foreign key
  • subject_id — INT — Foreign key
  • seq_num — INT
  • icd_code — VARCHAR(20)
  • icd_version — INT

services

  • hadm_id — INT — Foreign key
  • subject_id — INT — Foreign key
  • transfertime — TIMESTAMP
  • curr_service — VARCHAR(100)

transfers

  • transfer_id — INT
  • subject_id — INT — Foreign key
  • hadm_id — INT