데이터베이스
테이블 (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