MIMIC4-1조(최종완성본))
테이블 (31)
mimiciv_hosp.admissions (1)
- hadm_id — INTEGER — 기본 키 — NOT NULL
- admittime — TIMESTAMP — NOT NULL
- dischtime — TIMESTAMP
- deathtime — TIMESTAMP
- admission_type — VARCHAR(40) — NOT NULL
- admit_provider_id — VARCHAR(10)
- admission_location — VARCHAR(60)
- discharge_location — VARCHAR(60)
- insurance — VARCHAR(255)
- language — VARCHAR(25)
- marital_status — VARCHAR(30)
- race — VARCHAR(80)
- edregtime — TIMESTAMP
- edouttime — TIMESTAMP
- hospital_expire_flag — SMALLINT
- subject_id — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
mimiciv_hosp.d_hcpcs (2)
- code — CHAR(5) — 기본 키 — NOT NULL
- category — SMALLINT
- long_description — TEXT
- short_description — VARCHAR(180)
mimiciv_hosp.d_icd_diagnoses (4)
- icd_code — CHAR(7) — 기본 키 — NOT NULL
- icd_version — SMALLINT — 기본 키 — NOT NULL
- long_title — VARCHAR(255)
mimiciv_hosp.d_icd_procedures (5)
- icd_code — CHAR(7) — 기본 키 — NOT NULL
- icd_version — SMALLINT — 기본 키 — NOT NULL
- long_title — VARCHAR(222)
mimiciv_hosp.d_labitems (6)
- itemid — INTEGER — 기본 키 — NOT NULL
- label — VARCHAR(50)
- fluid — VARCHAR(50)
- category — VARCHAR(50)
mimiciv_hosp.diagnoses_icd (3)
- seq_num — INTEGER — 기본 키 — NOT NULL
- icd_code — CHAR(7) — 기본 키
- icd_version — SMALLINT — 기본 키
- hadm_id — INTEGER — 외래 키 → mimiciv_hosp.admissions.hadm_id — NOT NULL
- subject_id (subject_id2) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
mimiciv_hosp.drgcodes (7)
- hadm_id — INTEGER — 외래 키 → mimiciv_hosp.admissions.hadm_id — NOT NULL
- drg_type — VARCHAR(4)
- drg_code — VARCHAR(10) — NOT NULL
- description — VARCHAR(195)
- drg_severity — SMALLINT
- drg_mortality — SMALLINT
- subject_id (subject_id2) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
mimiciv_hosp.emar (9)
- emar_id — VARCHAR(25) — 기본 키 — NOT NULL
- subject_id — INTEGER — NOT NULL
- hadm_id — INTEGER
- emar_seq — INTEGER — NOT NULL
- poe_id — VARCHAR(25) — NOT NULL
- pharmacy_id — INTEGER
- enter_provider_id — VARCHAR(10)
- charttime — TIMESTAMP — NOT NULL
- medication — TEXT
- event_txt — VARCHAR(100)
- scheduletime — TIMESTAMP
- storetime — TIMESTAMP — NOT NULL
mimiciv_hosp.emar_detail (8)
- parent_field_ordinal — VARCHAR(10) — 기본 키
- emar_id — VARCHAR(25) — 외래 키 → mimiciv_hosp.emar.emar_id — NOT NULL
- emar_seq — INTEGER — NOT NULL
- administration_type — VARCHAR(50)
- pharmacy_id — INTEGER
- barcode_type — VARCHAR(4)
- reason_for_no_barcode — TEXT
- complete_dose_not_given — VARCHAR(5)
- dose_due — VARCHAR(100)
- dose_due_unit — VARCHAR(50)
- dose_given — VARCHAR(255)
- dose_given_unit — VARCHAR(50)
- will_remainder_of_dose_be_given — VARCHAR(5)
- product_amount_given — VARCHAR(30)
- product_unit — VARCHAR(30)
- product_code — VARCHAR(30)
- product_description — VARCHAR(255)
- product_description_other — VARCHAR(255)
- prior_infusion_rate — VARCHAR(40)
- infusion_rate — VARCHAR(40)
- infusion_rate_adjustment — VARCHAR(50)
- infusion_rate_adjustment_amount — VARCHAR(30)
- infusion_rate_unit — VARCHAR(30)
- route — VARCHAR(10)
- infusion_complete — VARCHAR(1)
- completion_interval — VARCHAR(50)
- new_iv_bag_hung — VARCHAR(1)
- continued_infusion_in_other_location — VARCHAR(1)
- restart_interval — VARCHAR(2305)
- side — VARCHAR(10)
- site — VARCHAR(255)
- non_formulary_visual_verification — VARCHAR(1)
- subject_id (subject_id2) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
mimiciv_hosp.hcpcsevents (10)
- seq_num — INTEGER — 기본 키 — NOT NULL
- hadm_id — INTEGER — 외래 키 → mimiciv_hosp.admissions.hadm_id — NOT NULL
- hcpcs_cd — CHAR(5) — 외래 키 → mimiciv_hosp.d_hcpcs.code — NOT NULL
- chartdate — DATE
- short_description — VARCHAR(180)
- subject_id (subject_id2) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
mimiciv_hosp.labevents (11)
- labevent_id — INTEGER — 기본 키 — NOT NULL
- hadm_id — INTEGER
- specimen_id — INTEGER — NOT NULL
- order_provider_id — VARCHAR(10)
- charttime — TIMESTAMP(0)
- storetime — TIMESTAMP(0)
- value — VARCHAR(200)
- valuenum — DOUBLE PRECISION
- valueuom — VARCHAR(20)
- ref_range_lower — DOUBLE PRECISION
- ref_range_upper — DOUBLE PRECISION
- flag — VARCHAR(10)
- priority — VARCHAR(7)
- comments — TEXT
- subject_id (subject_id2) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
- itemid (itemid2) — INTEGER — 외래 키 → mimiciv_hosp.d_labitems.itemid — NOT NULL
mimiciv_hosp.microbiologyevents (12)
- microevent_id — INTEGER — 기본 키 — NOT NULL
- micro_specimen_id — INTEGER — NOT NULL
- order_provider_id — VARCHAR(10)
- chartdate — TIMESTAMP(0) — NOT NULL
- charttime — TIMESTAMP(0)
- spec_itemid — INTEGER — NOT NULL
- spec_type_desc — VARCHAR(100) — NOT NULL
- test_seq — INTEGER — NOT NULL
- storedate — TIMESTAMP(0)
- storetime — TIMESTAMP(0)
- test_itemid — INTEGER
- test_name — VARCHAR(100)
- org_itemid — INTEGER
- org_name — VARCHAR(100)
- isolate_num — SMALLINT
- quantity — VARCHAR(50)
- ab_itemid — INTEGER
- ab_name — VARCHAR(30)
- dilution_text — VARCHAR(10)
- dilution_comparison — VARCHAR(20)
- dilution_value — DOUBLE PRECISION
- interpretation — VARCHAR(5)
- comments — TEXT
- subject_id (subject_id2) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
- hadm_id (hadm_id2) — INTEGER — 외래 키 → mimiciv_hosp.admissions.hadm_id — NOT NULL
mimiciv_hosp.omr (13)
- subject_id — INTEGER — 기본 키 — NOT NULL
- chartdate — DATE — 기본 키 — NOT NULL
- seq_num — INTEGER — 기본 키 — NOT NULL
- result_name — VARCHAR(100) — NOT NULL
- result_value — TEXT — NOT NULL
mimiciv_hosp.patients (14)
- subject_id — INTEGER — 기본 키 — NOT NULL
- gender — CHAR(1) — NOT NULL
- anchor_age — SMALLINT
- anchor_year — SMALLINT — NOT NULL
- anchor_year_group — VARCHAR(20) — NOT NULL
- dod — DATE
mimiciv_hosp.pharmacy (15)
- pharmacy_id — INTEGER — 기본 키 — NOT NULL
- poe_id — VARCHAR(25)
- starttime — TIMESTAMP(3)
- stoptime — TIMESTAMP(3)
- medication — TEXT
- proc_type — VARCHAR(50) — NOT NULL
- status — VARCHAR(50)
- entertime — TIMESTAMP(3) — NOT NULL
- verifiedtime — TIMESTAMP(3)
- route — VARCHAR(50)
- frequency — VARCHAR(50)
- disp_sched — VARCHAR(255)
- infusion_type — VARCHAR(15)
- sliding_scale — VARCHAR(1)
- lockout_interval — VARCHAR(50)
- basal_rate — REAL
- one_hr_max — VARCHAR(10)
- doses_per_24_hrs — REAL
- duration — REAL
- duration_interval — VARCHAR(50)
- expiration_value — INTEGER
- expiration_unit — VARCHAR(50)
- expirationdate — TIMESTAMP(3)
- dispensation — VARCHAR(50)
- fill_quantity — VARCHAR(50)
- subject_id (subject_id2) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
- hadm_id (hadm_id2) — INTEGER — 외래 키 → mimiciv_hosp.admissions.hadm_id — NOT NULL
mimiciv_hosp.poe (17)
- poe_id — VARCHAR(25) — 기본 키 — NOT NULL
- poe_seq — INTEGER — NOT NULL
- ordertime — TIMESTAMP(0) — NOT NULL
- order_type — VARCHAR(25) — NOT NULL
- order_subtype — VARCHAR(50)
- transaction_type — VARCHAR(15)
- discontinue_of_poe_id — VARCHAR(25)
- discontinued_by_poe_id — VARCHAR(25)
- order_provider_id — VARCHAR(10)
- order_status — VARCHAR(15)
- subject_id (subject_id2) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
- hadm_id (hadm_id2) — INTEGER — 외래 키 → mimiciv_hosp.admissions.hadm_id — NOT NULL
mimiciv_hosp.poe_detail (16)
- field_name — VARCHAR(255) — 기본 키 — NOT NULL
- poe_id — VARCHAR(25) — 외래 키 → mimiciv_hosp.poe.poe_id — NOT NULL
- poe_seq — INTEGER — NOT NULL
- field_value — TEXT
- subject_id (subject_id2) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
mimiciv_hosp.prescriptions (18)
- pharmacy_id — INTEGER — 기본 키 — NOT NULL
- drug_type — VARCHAR(20) — 기본 키 — NOT NULL
- drug — VARCHAR(255) — 기본 키 — NOT NULL
- poe_id — VARCHAR(25)
- poe_seq — INTEGER
- 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 (subject_id2) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
- hadm_id (hadm_id2) — INTEGER — 외래 키 → mimiciv_hosp.admissions.hadm_id — NOT NULL
mimiciv_hosp.procedures_icd (19)
- seq_num — INTEGER — 기본 키 — NOT NULL
- icd_code — VARCHAR(7) — 기본 키
- icd_version — SMALLINT — 기본 키
- hadm_id — INTEGER — 외래 키 → mimiciv_hosp.admissions.hadm_id — NOT NULL
- chartdate — DATE — NOT NULL
- subject_id (subject_id2) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
mimiciv_hosp.provider (20)
- provider_id — VARCHAR(10) — NOT NULL
mimiciv_hosp.services (21)
- transfertime — TIMESTAMP — 기본 키 — NOT NULL
- curr_service — VARCHAR(10) — 기본 키
- hadm_id — INTEGER — 외래 키 → mimiciv_hosp.admissions.hadm_id — NOT NULL
- prev_service — VARCHAR(10)
- subject_id (subject_id2) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
mimiciv_hosp.transfers (22)
- subject_id — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
- hadm_id — INTEGER
- eventtype — VARCHAR(10)
- careunit — VARCHAR(255)
- intime — TIMESTAMP
- outtime — TIMESTAMP
- transfer_id — INTEGER — NOT NULL
mimiciv_icu.caregiver (31)
- caregiver_id — INTEGER — 기본 키 — NOT NULL
mimiciv_icu.chartevents (32)
- subject_id — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
- caregiver_id — INTEGER
- storetime — TIMESTAMP
- value — VARCHAR(200)
- valuenum — FLOAT
- valueuom — VARCHAR(20)
- warning — SMALLINT
- hadm_id (hadm_id2) — INTEGER — 외래 키 → mimiciv_hosp.admissions.hadm_id — NOT NULL
- stay_id (stay_id2) — INTEGER — 외래 키 → mimiciv_icu.icustays.stay_id — NOT NULL
- itemid (itemid2) — INTEGER — 외래 키 → mimiciv_icu.d_items.itemid — NOT NULL
- charttime — TIMESTAMP — NOT NULL
mimiciv_icu.d_items (34)
- 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
mimiciv_icu.datetimeevents (33)
- itemid — INTEGER — 기본 키 — NOT NULL
- charttime — TIMESTAMP — 기본 키 — NOT NULL
- stay_id — INTEGER — 외래 키 → mimiciv_icu.icustays.stay_id — NOT NULL
- caregiver_id — INTEGER
- storetime — TIMESTAMP
- value — TIMESTAMP — NOT NULL
- valueuom — VARCHAR(20)
- warning — SMALLINT
- subject_id (subject_id2) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
- hadm_id (hadm_id2) — INTEGER — 외래 키 → mimiciv_hosp.admissions.hadm_id — NOT NULL
- itemid (itemid2) — INTEGER — 외래 키 → mimiciv_icu.d_items.itemid — NOT NULL
mimiciv_icu.icustays (35)
- stay_id — INTEGER — 기본 키 — NOT NULL
- first_careunit — VARCHAR(255)
- last_careunit — VARCHAR(255)
- intime — TIMESTAMP
- outtime — TIMESTAMP
- los — FLOAT
- subject_id (subject_id2) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
- hadm_id (hadm_id2) — INTEGER — 외래 키 → mimiciv_hosp.admissions.hadm_id — NOT NULL
mimiciv_icu.ingredientevents (36)
- subject_id — INTEGER — NOT NULL
- hadm_id — INTEGER — NOT NULL
- stay_id — INTEGER
- caregiver_id — INTEGER
- endtime — TIMESTAMP — NOT NULL
- storetime — TIMESTAMP
- amount — FLOAT
- amountuom — VARCHAR(20)
- rate — FLOAT
- rateuom — VARCHAR(20)
- linkorderid — INTEGER
- statusdescription — VARCHAR(20)
- originalamount — FLOAT
- originalrate — FLOAT
- orderid — INTEGER — NOT NULL
- itemid — INTEGER — NOT NULL
- starttime — TIMESTAMP — NOT NULL
mimiciv_icu.inputevents (37)
- orderid — INTEGER — 기본 키 — NOT NULL
- itemid — INTEGER — 외래 키 → mimiciv_icu.d_items.itemid — NOT NULL
- caregiver_id — INTEGER
- starttime — TIMESTAMP — NOT NULL
- endtime — TIMESTAMP — NOT NULL
- storetime — TIMESTAMP
- amount — FLOAT
- amountuom — VARCHAR(20)
- rate — FLOAT
- rateuom — VARCHAR(20)
- linkorderid — INTEGER
- ordercategoryname — VARCHAR(50)
- secondaryordercategoryname — VARCHAR(50)
- ordercomponenttypedescription — VARCHAR(100)
- ordercategorydescription — VARCHAR(30)
- patientweight — FLOAT
- totalamount — FLOAT
- totalamountuom — VARCHAR(50)
- isopenbag — SMALLINT
- continueinnextdept — SMALLINT
- statusdescription — VARCHAR(20)
- originalamount — FLOAT
- originalrate — FLOAT
- subject_id (subject_id2) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
- hadm_id (hadm_id2) — INTEGER — 외래 키 → mimiciv_hosp.admissions.hadm_id — NOT NULL
- stay_id (stay_id2) — INTEGER — 외래 키 → mimiciv_icu.icustays.stay_id — NOT NULL
mimiciv_icu.outputevents (38)
- charttime — TIMESTAMP(3) — 기본 키 — NOT NULL
- itemid — INTEGER — 기본 키 — NOT NULL
- stay_id (stay_id2) — INTEGER — 외래 키 → mimiciv_icu.icustays.stay_id — NOT NULL
- caregiver_id — INTEGER
- storetime — TIMESTAMP(3) — NOT NULL
- value — FLOAT — NOT NULL
- valueuom — VARCHAR(20)
- subject_id (subject_id2) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
- hadm_id (hadm_id2) — INTEGER — 외래 키 → mimiciv_hosp.admissions.hadm_id — NOT NULL
- itemid (itemid2) — INTEGER — 외래 키 → mimiciv_icu.d_items.itemid — NOT NULL
mimiciv_icu.procedureevents (39)
- orderid — INTEGER — 기본 키
- caregiver_id — INTEGER
- starttime — TIMESTAMP — NOT NULL
- endtime — TIMESTAMP — NOT NULL
- storetime — TIMESTAMP — NOT NULL
- value — FLOAT
- valueuom — VARCHAR(20)
- location — VARCHAR(100)
- locationcategory — VARCHAR(50)
- linkorderid — INTEGER
- ordercategoryname — VARCHAR(50)
- ordercategorydescription — VARCHAR(30)
- patientweight — FLOAT
- isopenbag — SMALLINT
- continueinnextdept — SMALLINT
- statusdescription — VARCHAR(20)
- originalamount — FLOAT
- originalrate — FLOAT
- subject_id (subject_id2) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
- hadm_id (hadm_id2) — INTEGER — 외래 키 → mimiciv_hosp.admissions.hadm_id — NOT NULL
- stay_id (stay_id2) — INTEGER — 외래 키 → mimiciv_icu.icustays.stay_id — NOT NULL
- itemid (itemid2) — INTEGER — 외래 키 → mimiciv_icu.d_items.itemid — NOT NULL