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_icd_diagnoses
- icd_code — VARCHAR(20)
- icd_version — INT
d_icd_procedures
- icd_code — VARCHAR(20)
- icd_version — 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
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