데이터베이스

테이블 (31)

admissions

  • hadm_id — INT — 기본 키 — NOT NULL
  • caregiver_id (caregiver_id2) — INTEGER — 외래 키 → chartevents.caregiver_id — NOT NULL
  • subject_id (subject_id2) — INT — 외래 키 → omr.subject_id — NOT NULL
  • chartdate — DATE — 외래 키 → omr.chartdate — NOT NULL
  • seq_num — INT — 외래 키 → omr.seq_num — NOT NULL
  • caregiver_id (caregiver_id22) — INTEGER — 외래 키 → omr.caregiver_id — NOT NULL
  • subject_id (subject_id22) — INT — 외래 키 → omr.subject_id — NOT NULL
  • chartdate (chartdate2) — DATE — 외래 키 → omr.chartdate — NOT NULL
  • seq_num (seq_num2) — INT — 외래 키 → omr.seq_num — NOT NULL
  • subject_id — INT — NOT NULL
  • admittime — DATETIME — NOT NULL
  • dischtime — DATETIME
  • deathtime — DATETIME
  • admission_type — STRING — NOT NULL
  • admit_provider_id — STRING
  • admission_location — STRING
  • discharge_location — STRING
  • insurance — STRING
  • language — STRING
  • marital_status — STRING
  • race — STRING
  • edregtime — DATETIME
  • edouttime — DATETIME
  • hospital_expire_flag — INT

caregiver

  • caregiver_id — INTEGER — 기본 키 — NOT NULL

chartevents

  • caregiver_id (caregiver_id2) — INTEGER — 외래 키 → caregiver.caregiver_id — NOT NULL
  • subject_id — INTEGER — NOT NULL
  • hadm_id — INTEGER — NOT NULL
  • stay_id — INTEGER — NOT NULL
  • caregiver_id — INTEGER
  • charttime — TIMESTAMP — NOT NULL
  • storetime — TIMESTAMP
  • itemid — INTEGER — NOT NULL
  • value — VARCHAR(200)
  • valuenum — FLOAT
  • valueuom — VARCHAR(20)
  • warning — SMALLINT

d_hcpcs

  • caregiver_id (caregiver_id2) — INTEGER — 외래 키 → admissions.caregiver_id — NOT NULL
  • subject_id (subject_id2) — INT — 외래 키 → admissions.subject_id — NOT NULL
  • chartdate — DATE — 외래 키 → admissions.chartdate — NOT NULL
  • seq_num — INT — 외래 키 → admissions.seq_num — NOT NULL
  • caregiver_id (caregiver_id22) — INTEGER — 외래 키 → admissions.caregiver_id — NOT NULL
  • subject_id (subject_id22) — INT — 외래 키 → admissions.subject_id — NOT NULL
  • chartdate (chartdate2) — DATE — 외래 키 → admissions.chartdate — NOT NULL
  • seq_num (seq_num2) — INT — 외래 키 → admissions.seq_num — NOT NULL
  • hadm_id — INT — 외래 키 → admissions.hadm_id — NOT NULL
  • hcpcs_cd — STRING — NOT NULL
  • hcpcs_desc — STRING
  • category — STRING

d_icd_diagnoses

  • icd_code — STRING — NOT NULL
  • icd_description — STRING
  • icd_version — STRING

d_icd_procedures

  • caregiver_id (caregiver_id2) — INTEGER — 외래 키 → admissions.caregiver_id — NOT NULL
  • subject_id (subject_id2) — INT — 외래 키 → admissions.subject_id — NOT NULL
  • chartdate — DATE — 외래 키 → admissions.chartdate — NOT NULL
  • seq_num — INT — 외래 키 → admissions.seq_num — NOT NULL
  • caregiver_id (caregiver_id22) — INTEGER — 외래 키 → admissions.caregiver_id — NOT NULL
  • subject_id (subject_id22) — INT — 외래 키 → admissions.subject_id — NOT NULL
  • chartdate (chartdate2) — DATE — 외래 키 → admissions.chartdate — NOT NULL
  • seq_num (seq_num2) — INT — 외래 키 → admissions.seq_num — NOT NULL
  • hadm_id — INT — 외래 키 → admissions.hadm_id — NOT NULL
  • icd_code — STRING — NOT NULL
  • icd_description — STRING
  • icd_version — STRING

d_items

  • itemid — INTEGER — 기본 키 — NOT NULL
  • label — VARCHAR(100) — NOT NULL
  • abbreviation — VARCHAR(50) — NOT NULL
  • linksto — VARCHAR(30) — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • unitname — VARCHAR(50)
  • param_type — VARCHAR(20) — NOT NULL
  • lownormalvalue — FLOAT
  • highnormalvalue — FLOAT

d_labitems

  • item_id — INT — 기본 키 — NOT NULL
  • subject_id — INT — 외래 키 → labevents.subject_id — NOT NULL
  • caregiver_id (caregiver_id2) — INTEGER — 외래 키 → labevents.caregiver_id — NOT NULL
  • subject_id (subject_id2) — INT — 외래 키 → labevents.subject_id — NOT NULL
  • chartdate — DATE — 외래 키 → labevents.chartdate — NOT NULL
  • seq_num — INT — 외래 키 → labevents.seq_num — NOT NULL
  • caregiver_id (caregiver_id22) — INTEGER — 외래 키 → labevents.caregiver_id — NOT NULL
  • subject_id (subject_id22) — INT — 외래 키 → labevents.subject_id — NOT NULL
  • chartdate (chartdate2) — DATE — 외래 키 → labevents.chartdate — NOT NULL
  • seq_num (seq_num2) — INT — 외래 키 → labevents.seq_num — NOT NULL
  • hadm_id — INT — 외래 키 → labevents.hadm_id — NOT NULL
  • label — VARCHAR(100)
  • fluid — VARCHAR(80)
  • category — VARCHAR(50)
  • loinc_code — VARCHAR(50)

datetimeevents

  • subject_id (subject_id2) — INT — 외래 키 → patients.subject_id — NOT NULL
  • hadm_id (hadm_id2) — INT — 외래 키 → admissions.hadm_id — NOT NULL
  • stay_id (stay_id2) — INT — 외래 키 → icustays.stay_id — NOT NULL
  • caregiver_id — INT
  • charttime — TIMESTAMP — NOT NULL
  • storetime — TIMESTAMP
  • itemid (itemid2) — INTEGER — 외래 키 → d_items.itemid — NOT NULL
  • value — TIMESTAMP — NOT NULL
  • valueuom — VARCHAR(20)
  • warning — SMALLINT

diagnoses_icd

  • subject_id — INT — 기본 키 — NOT NULL
  • caregiver_id (caregiver_id2) — INTEGER — 외래 키 → admissions.caregiver_id — NOT NULL
  • subject_id (subject_id22) — INT — 외래 키 → admissions.subject_id — NOT NULL
  • chartdate — DATE — 외래 키 → admissions.chartdate — NOT NULL
  • seq_num (seq_num2) — INT — 외래 키 → admissions.seq_num — NOT NULL
  • caregiver_id (caregiver_id22) — INTEGER — 외래 키 → admissions.caregiver_id — NOT NULL
  • subject_id (subject_id222) — INT — 외래 키 → admissions.subject_id — NOT NULL
  • chartdate (chartdate2) — DATE — 외래 키 → admissions.chartdate — NOT NULL
  • seq_num (seq_num22) — INT — 외래 키 → admissions.seq_num — NOT NULL
  • hadm_id — INT — 외래 키 → admissions.hadm_id — NOT NULL
  • subject_id (subject_id2) — INT
  • gender — INT
  • seq_num — INT
  • icd_code — VARCHAR(80)
  • icd_versionicd_version — INT
  • long_title — VARCHAR(80)

drgcodes

  • subject_id — INT — 기본 키 — NOT NULL
  • caregiver_id (caregiver_id2) — INTEGER — 외래 키 → admissions.caregiver_id — NOT NULL
  • subject_id (subject_id22) — INT — 외래 키 → admissions.subject_id — NOT NULL
  • chartdate — DATE — 외래 키 → admissions.chartdate — NOT NULL
  • seq_num — INT — 외래 키 → admissions.seq_num — NOT NULL
  • caregiver_id (caregiver_id22) — INTEGER — 외래 키 → admissions.caregiver_id — NOT NULL
  • subject_id (subject_id222) — INT — 외래 키 → admissions.subject_id — NOT NULL
  • chartdate (chartdate2) — DATE — 외래 키 → admissions.chartdate — NOT NULL
  • seq_num (seq_num2) — INT — 외래 키 → admissions.seq_num — NOT NULL
  • hadm_id (hadm_id2) — INT — 외래 키 → admissions.hadm_id — NOT NULL
  • subject_id (subject_id2) — INT
  • hadm_id — INT
  • drg_type — VARCHAR(80)
  • drg_code — VARCHAR(80)
  • description — VARCHAR(80)
  • drg_severity — INT
  • drg_mortality — INT

emar (CopyOflabevents)

  • subject_id — INT — 기본 키 — NOT NULL
  • emar_id — VARCHAR(80) — 외래 키 → admissions.caregiver_id — NOT NULL
  • hadm_id — INT — 외래 키 → admissions.subject_id — NOT NULL
  • charttime (chartdate) — DATETIME — 외래 키 → admissions.chartdate — NOT NULL
  • poe_id — INT — 외래 키 → admissions.seq_num — NOT NULL
  • caregiver_id (caregiver_id22) — INTEGER — 외래 키 → admissions.caregiver_id — NOT NULL
  • pharmacy_id — INT — 외래 키 → admissions.subject_id — NOT NULL
  • discontinued — VARCHAR(80) — 외래 키 → admissions.chartdate — NOT NULL
  • complete — VARCHAR(80) — 외래 키 → admissions.seq_num — NOT NULL
  • hadm_id (hadm_id2) — INT — 외래 키 → admissions.hadm_id — NOT NULL

emar_detail

  • emar_id — VARCHAR(80) — 기본 키 — NOT NULL
  • subject_id — INT — 외래 키 → emar.subject_id — NOT NULL
  • emar_id (emar_id2) — VARCHAR(80) — 외래 키 → emar.emar_id — NOT NULL
  • hadm_id — INT — 외래 키 → emar.hadm_id — NOT NULL
  • charttime (chartdate) — DATETIME — 외래 키 → emar.charttime — NOT NULL
  • poe_id — INT — 외래 키 → emar.poe_id — NOT NULL
  • caregiver_id (caregiver_id22) — INTEGER — 외래 키 → emar.caregiver_id — NOT NULL
  • pharmacy_id (pharmacy_id2) — INT — 외래 키 → emar.pharmacy_id — NOT NULL
  • discontinued — VARCHAR(80) — 외래 키 → emar.discontinued — NOT NULL
  • complete — VARCHAR(80) — 외래 키 → emar.complete — NOT NULL
  • hadm_id (hadm_id2) — INT — 외래 키 → emar.hadm_id — NOT NULL
  • parent_field_ordinal — INT
  • administration_type — VARCHAR(80)
  • pharmacy_id — INT
  • barcode_verified — VARCHAR(80)
  • medication — VARCHAR(80)
  • dosage — VARCHAR(80)
  • dose_unit — VARCHAR(80)
  • route — VARCHAR(80)
  • frequency — VARCHAR(80)
  • starttime — DATETIME
  • stoptime — DATETIME
  • status — VARCHAR(80)

hpcsevents

  • subject_id — INT — 기본 키 — NOT NULL
  • caregiver_id (caregiver_id2) — INTEGER — 외래 키 → admissions.caregiver_id — NOT NULL
  • subject_id (subject_id22) — INT — 외래 키 → admissions.subject_id — NOT NULL
  • chartdate (chartdate2) — DATE — 외래 키 → admissions.chartdate — NOT NULL
  • seq_num (seq_num2) — INT — 외래 키 → admissions.seq_num — NOT NULL
  • caregiver_id (caregiver_id22) — INTEGER — 외래 키 → admissions.caregiver_id — NOT NULL
  • subject_id (subject_id222) — INT — 외래 키 → admissions.subject_id — NOT NULL
  • chartdate (chartdate22) — DATE — 외래 키 → admissions.chartdate — NOT NULL
  • seq_num (seq_num22) — INT — 외래 키 → admissions.seq_num — NOT NULL
  • hadm_id (hadm_id2) — INT — 외래 키 → admissions.hadm_id — NOT NULL
  • subject_id (subject_id2) — INT
  • hadm_id — INT
  • hcpcs_cd — VARCHAR(80)
  • chartdate — DATE
  • seq_num — INT

icustays

  • stay_id — INT — 기본 키 — NOT NULL
  • subject_id (subject_id2) — INT — 외래 키 → patients.subject_id — NOT NULL
  • hadm_id (hadm_id2) — INT — 외래 키 → admissions.hadm_id — NOT NULL
  • first_careunit — VARCHAR(225)
  • last_careunit — VARCHAR(225)
  • intime — TIMESTAMP
  • outtime — TIMESTAMP
  • los — FLOAT

ingredientevents

  • subject_id (subject_id2) — INT — 외래 키 → patients.subject_id — NOT NULL
  • hadm_id (hadm_id2) — INT — 외래 키 → admissions.hadm_id — NOT NULL
  • stay_id (stay_id2) — INT — 외래 키 → icustays.stay_id
  • caregiver_id — INT
  • starttime — TIMESTAMP — NOT NULL
  • endtime — TIMASTAMP — NOT NULL
  • storetime — TIMESTAMP
  • itemid (itemid2) — INTEGER — 외래 키 → d_items.itemid — NOT NULL
  • amount — FLOAT
  • amountuom — VARCHAR(20)
  • rate — FLOAT
  • rateuom — VARCHAR(20)
  • orderid — INT — NOT NULL
  • linkorderid — INT
  • statusdescription — VARCHAR(20)
  • originalamount — FLOAT
  • originalrate — FLOAT

inputevents

  • subject_id (subject_id2) — INT — 외래 키 → patients.subject_id — NOT NULL
  • hadm_id (hadm_id2) — INT — 외래 키 → admissions.hadm_id — NOT NULL
  • stay_id (stay_id2) — INT — 외래 키 → icustays.stay_id
  • caregiver_id — INT
  • starttime — TIMASTAMP — NOT NULL
  • endtime — TIMESTAMP — NOT NULL
  • storetime — TIMASTAMP
  • itemid (itemid2) — INTEGER — 외래 키 → d_items.itemid — NOT NULL
  • amount — FLOAT
  • amountuom — VARCHAR(20)
  • rate — FLOAT
  • rateuom — VARCHAR(20)
  • orderid — INT — NOT NULL
  • linkorderid — INT
  • ordercategoryname — VARCHAR(50)
  • secondaryordercategoryname — VARCHAR(50)
  • ordercomponenttypescription — VARCHAR(100)
  • ordercategorydescription — VARCHAR(30)
  • patientweight — FLOAT
  • totalamount — FLOAT
  • totalamountuom — VARCHAR(50)
  • isopenbag — SMALLINT
  • countinueinnextdept — SMALLINT
  • statusdescription — VARCHAR(20)
  • originalamount — FLOAT
  • originalrate — FLOAT

labevents

  • subject_id — INT — 기본 키 — NOT NULL
  • caregiver_id (caregiver_id2) — INTEGER — 외래 키 → admissions.caregiver_id — NOT NULL
  • subject_id (subject_id2) — INT — 외래 키 → admissions.subject_id — NOT NULL
  • chartdate — DATE — 외래 키 → admissions.chartdate — NOT NULL
  • seq_num — INT — 외래 키 → admissions.seq_num — NOT NULL
  • caregiver_id (caregiver_id22) — INTEGER — 외래 키 → admissions.caregiver_id — NOT NULL
  • subject_id (subject_id22) — INT — 외래 키 → admissions.subject_id — NOT NULL
  • chartdate (chartdate2) — DATE — 외래 키 → admissions.chartdate — NOT NULL
  • seq_num (seq_num2) — INT — 외래 키 → admissions.seq_num — NOT NULL
  • hadm_id — INT — 외래 키 → admissions.hadm_id — NOT NULL
  • itemid (item_id) — INT
  • charttime — DATETIME
  • value — VARCHAR(80)
  • valuenum — FLOAT
  • valueuom — VARCHAR(80)

microbiologyevents

  • microevent_id — INT — 기본 키 — NOT NULL
  • hadm_id — INT — 기본 키
  • subject_id (subject_id2) — INT — 외래 키 → patients.subject_id — NOT NULL
  • caregiver_id (caregiver_id2) — INTEGER — 외래 키 → chartevents.caregiver_id — NOT NULL
  • chartdate — DATE — NOT NULL
  • spec_type_desc — VARCHAR(10) — NOT NULL
  • test_name — VARCHAR(20) — NOT NULL
  • org_name — VARCHAR(20)
  • ab_name — VARCHAR(20)
  • dilution_text — VARCHAR(20)
  • interpretation — VARCHAR(20)

omr

  • subject_id — INT — 기본 키 — NOT NULL
  • chartdate — DATE — 기본 키 — NOT NULL
  • seq_num — INT — 기본 키 — NOT NULL
  • caregiver_id (caregiver_id2) — INTEGER — 외래 키 → admissions.caregiver_id — NOT NULL
  • subject_id (subject_id2) — INT — 외래 키 → admissions.subject_id — NOT NULL
  • chartdate (chartdate2) — DATE — 외래 키 → admissions.chartdate — NOT NULL
  • seq_num (seq_num2) — INT — 외래 키 → admissions.seq_num — NOT NULL
  • hadm_id — INT — 외래 키 → admissions.hadm_id — NOT NULL
  • storetime — TIMESTAMP
  • category — TEXT
  • result — TEXT

outputevents

  • subject_id (subject_id2) — INT — 외래 키 → patients.subject_id — NOT NULL
  • hadm_id (hadm_id2) — INT — 외래 키 → admissions.hadm_id — NOT NULL
  • stay_id (stay_id2) — INT — 외래 키 → icustays.stay_id — NOT NULL
  • caregiver_id — INT
  • charttime — TIMESTAMP — NOT NULL
  • storetime — TIMASTAMP — NOT NULL
  • itemid (itemid2) — INTEGER — 외래 키 → d_items.itemid — NOT NULL
  • value — FLOAT — NOT NULL
  • valueuom — VARCHAR(20)

patients

  • subject_id — INT — 기본 키 — NOT NULL
  • gender — VARCHAR(3) — NOT NULL
  • anchor_age — INT — NOT NULL
  • anchor_year — INT — NOT NULL
  • anchor_year_group — VARCHAR(10) — NOT NULL
  • dod — DATE

pharmacy

  • pharmacy_id — INT — 기본 키 — NOT NULL
  • subject_id — INT — 기본 키 — NOT NULL
  • hadm_id — INT — 기본 키 — NOT NULL
  • starttime — DATETIME
  • stoptime — DATETIME
  • medication — VARCHAR(30) — NOT NULL
  • proc_type — VARCHAR(30) — NOT NULL
  • status — VARCHAR(30) — NOT NULL
  • route — VARCHAR(30)
  • frequency — VARCHAR(30)

poe

  • poe_id — VARCHAR(20) — 기본 키 — NOT NULL
  • hadm_id — INT — 기본 키 — NOT NULL
  • subject_id — INT — 외래 키 → patients.subject_id — NOT NULL
  • poe_seq — VARCHAR(20) — NOT NULL
  • ordertime — DATETIME — NOT NULL
  • order_type — VARCHAR(20) — NOT NULL
  • order_subject — VARCHAR(20)
  • transaction_type — VARCHAR(20) — NOT NULL
  • order_status — VARCHAR(20) — NOT NULL
  • order_provider_id — VARCHAR(20)

poe_detail

  • poe_seq — INT — NOT NULL
  • field_name — VARCHAR(20) — NOT NULL
  • field_value — VARCHAR(20) — NOT NULL
  • poe_id (poe_id2) — VARCHAR(20) — 외래 키 → poe.poe_id — NOT NULL
  • hadm_id — INT — 외래 키 → poe.hadm_id — NOT NULL
  • subject_id (subject_id3) — INT — 외래 키 → patients.subject_id — NOT NULL
  • subject_id — INT — 외래 키 → poe.subject_id — NOT NULL

prescription

  • prescription_id — 기본 키 — NOT NULL
  • subject_id — INT — 외래 키 → patients.subject_id — NOT NULL
  • poe_id — VARCHAR(20) — 외래 키 → poe.poe_id — NOT NULL
  • hadm_id — INT — 외래 키 → poe.hadm_id — NOT NULL
  • subject_id (subject_id2) — INT — 외래 키 → poe.subject_id — NOT NULL
  • order_provider_id — VARCHAR(20)
  • starttime — DATETIME — NOT NULL
  • stoptime — DATETIME
  • drug — VARCHAR(20) — NOT NULL
  • formulary_drug_cd — VARCHAR(20)
  • dose_val_rx — VARCHAR(20)
  • dose_unit_rx — VARCHAR(20)
  • route — VARCHAR(20)

procedureevents

  • subject_id (subject_id2) — INT — 외래 키 → patients.subject_id — NOT NULL
  • hadm_id (hadm_id2) — INT — 외래 키 → admissions.hadm_id — NOT NULL
  • stay_id (stay_id2) — INT — 외래 키 → icustays.stay_id — NOT NULL
  • caregiver_id — INT
  • starttime — TIMASTAMP — NOT NULL
  • endtime — TIMESTAMP — NOT NULL
  • storetime — TIMESTAMP — NOT NULL
  • itemid (itemid2) — INTEGER — 외래 키 → d_items.itemid — NOT NULL
  • value — FLOAT
  • valueuom — VARCHAR(20)
  • location — VARCHAR(100)
  • locationcategory — VARCHAR(50)
  • orderid — INT
  • linkorderid — INT
  • ordercategoryname — VARCHAR(50)
  • ordercategorydescription — VARCHAR(30)
  • patientweight — FLOAT
  • isopenbag — SMALLINT
  • continueinnextdept — SMALLINT
  • statusdescription — VARCHAR(20)
  • originalamount — FLOAT
  • originalrate — FLOAT

procedures_icd

  • hadm_id — INTEGER — 기본 키 — NOT NULL
  • seq_num — INTEGER — 기본 키 — NOT NULL
  • subject_id — INTEGER — NOT NULL
  • chartdate — DATE — NOT NULL
  • icd_code — VARCHAR(7)
  • icd_version — SMALLINT

provider

  • caregiver_id (caregiver_id2) — INTEGER — 외래 키 → d_icd_procedures.caregiver_id — NOT NULL
  • subject_id (subject_id2) — INT — 외래 키 → d_icd_procedures.subject_id — NOT NULL
  • chartdate — DATE — 외래 키 → d_icd_procedures.chartdate — NOT NULL
  • seq_num — INT — 외래 키 → d_icd_procedures.seq_num — NOT NULL
  • caregiver_id (caregiver_id22) — INTEGER — 외래 키 → d_icd_procedures.caregiver_id — NOT NULL
  • subject_id (subject_id22) — INT — 외래 키 → d_icd_procedures.subject_id — NOT NULL
  • chartdate (chartdate2) — DATE — 외래 키 → d_icd_procedures.chartdate — NOT NULL
  • seq_num (seq_num2) — INT — 외래 키 → d_icd_procedures.seq_num — NOT NULL
  • hadm_id — INT — 외래 키 → d_icd_procedures.hadm_id — NOT NULL
  • provider_id — INT — NOT NULL
  • name — STRING — NOT NULL
  • specialty — STRING
  • hospital_id — INT

services

  • subject_id — INTEGER — NOT NULL
  • hadm_id — INTEGER — NOT NULL
  • transfertime — TIMESTAMP — NOT NULL
  • prev_service — VARCHAR(10)
  • curr_service — VARCHAR(10)

transfers

  • subject_id — INTEGER — NOT NULL
  • hadm_id — INTEGER
  • transfer_id — INTEGER — NOT NULL
  • eventtype — VARCHAR(10)
  • careunit — VARCHAR(255)
  • intime — TIMESTAMP
  • outtime — TIMESTAMP