데이터베이스_5조
테이블 (31)
mimiciv_hosp.admissions (hosp1)
- hadm_id (Key) — INTEGER — 기본 키 — NOT NULL
- admittime (Field2) — TIMESTAMP — NOT NULL
- dischtime (Field3) — TIMESTAMP
- deathtime (Field4) — TIMESTAMP
- admission_type (Field5) — VARCHAR(40) — NOT NULL
- admit_provider_id (Field6) — VARCHAR(10)
- admission_location (Field7) — VARCHAR(60)
- discharge_location (Field8) — VARCHAR(60)
- insurance (Field9) — VARCHAR(255)
- language (Field10) — VARCHAR(10)
- marital_status (Field11) — VARCHAR(30)
- race (Field12) — VARCHAR(80)
- edregtime (Field13) — TIMESTAMP
- edouttime (Field14) — TIMESTAMP
- hospital_expire_flag (Field15) — SMALLINT
- subject_id (Key2) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
mimiciv_hosp.d_hcpcs (hosp2)
- code (Key) — CHAR(5) — 기본 키 — NOT NULL
- category (Field) — SMALLINT
- long_description (Field2) — TEXT
- short_description (Field3) — VARCHAR(180)
mimiciv_hosp.d_icd_diagnoses (hosp4)
- icd_code (Key) — CHAR(7) — 기본 키 — NOT NULL
- icd_version (Key2) — SMALLINT — 기본 키 — NOT NULL
- long_title (Field) — VARCHAR(255)
mimiciv_hosp.d_icd_procedures (hosp5)
- icd_code (Key) — CHAR(7) — 기본 키 — NOT NULL
- icd_version (Key2) — SMALLINT — 기본 키 — NOT NULL
- long_title (Field) — VARCHAR(222)
mimiciv_hosp.d_labitems (hosp6)
- itemid (Key) — INTEGER — 기본 키 — NOT NULL
- label (Field) — VARCHAR(50)
- fluid (Field2) — VARCHAR(50)
- category (Field3) — VARCHAR(50)
mimiciv_hosp.diagnoses_icd (hosp3)
- seq_num (Key2) — INTEGER — 기본 키 — NOT NULL
- icd_code (Key3) — CHAR(7) — 기본 키
- icd_version (Key4) — SMALLINT — 기본 키
- hadm_id (Key6) — INTEGER — 외래 키 → mimiciv_hosp.admissions.hadm_id — NOT NULL
- subject_id (Key5) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
mimiciv_hosp.drgcodes (hosp7)
- subject_id (Key2) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
- drg_type (Field2) — VARCHAR(4)
- drg_code (Field3) — VARCHAR(10) — NOT NULL
- description (Field4) — VARCHAR(195)
- drg_serverity (Field5) — SMALLINT
- drg_mortality (Field6) — SMALLINT
- hadm_id (Key) — INTEGER — 외래 키 → mimiciv_hosp.admissions.hadm_id — NOT NULL
mimiciv_hosp.emar (hosp9)
- emar_id (Key) — VARCHAR(25) — 기본 키 — NOT NULL
- emar_seq (Field3) — INTEGER — NOT NULL
- poe_id (Field4) — VARCHAR(25) — NOT NULL
- pharmacy_id (Field5) — INTEGER
- enter_provider_id (Field6) — VARCHAR(10)
- charttime (Field7) — TIMESTAMP — NOT NULL
- medication (Field8) — TEXT
- event_txt (Field9) — VARCHAR(100)
- scheduletime (Field10) — TIMESTAMP
- storetime (Field11) — TIMESTAMP — NOT NULL
- subject_id (Key2) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
- hadm_id (Key3) — INTEGER — 외래 키 → mimiciv_hosp.admissions.hadm_id
mimiciv_hosp.emar_detail (hosp8)
- parent_field_ordinal (Key2) — VARCHAR(10) — 기본 키
- emar_id (Key4) — VARCHAR(25) — 외래 키 → mimiciv_hosp.emar.emar_id — NOT NULL
- Field4administration_type (Field4) — VARCHAR(50)
- pharmacy_id (Field5) — INTEGER
- barcode_type (Field6) — VARCHAR(4)
- reason_for_no_barcode (Field7) — TEXT
- complete_dose_not_given (Field8) — VARCHAR(5)
- dose_due (Field9) — VARCHAR(100)
- dose_due_unit (Field10) — VARCHAR(50)
- dose_given (Field11) — VARCHAR(255)
- dose_given_unit (Field12) — VARCHAR(50)
- will_remainder_of_dose_be_given (Field13) — VARCHAR(5)
- product_amount_given (Field14) — VARCHAR(30)
- product_unit (Field15) — VARCHAR(30)
- product_code (Field16) — VARCHAR(30)
- product_description (Field17) — VARCHAR(255)
- product_description_other (Field18) — VARCHAR(255)
- prior_infusion_rate (Field19) — VARCHAR(40)
- infusion_rate (Field20) — VARCHAR(40)
- infusion_rate_adjustment (Field21) — VARCHAR(50)
- infusion_rate_adjustment_amount (Field22) — VARCHAR(30)
- infusion_rate_unit (Field23) — VARCHAR(30)
- route (Field24) — VARCHAR(10)
- infusion_complete (Field25) — VARCHAR(1)
- completion_interval (Field26) — VARCHAR(50)
- new_iv_bag_hung (Field27) — VARCHAR(1)
- continued_infusion_in_other_location (Field28) — VARCHAR(1)
- restart_interval (Field29) — VARCHAR(2305)
- side (Field30) — VARCHAR(10)
- site (Field31) — VARCHAR(255)
- non_formulary_visual_verification (Field32) — VARCHAR(1)
- emar_seq (Field2) — INTEGER — NOT NULL
- subject_id (Key3) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
mimiciv_hosp.hcpcsevents (hosp10)
- seq_num (Key3) — INTEGER — 기본 키 — NOT NULL
- hadm_id (Key5) — INTEGER — 외래 키 → mimiciv_hosp.admissions.hadm_id — NOT NULL
- hcpcs_cd (Key) — CHAR(5) — 외래 키 → mimiciv_hosp.d_hcpcs.code — NOT NULL
- chartdate (Field2) — DATE
- short_description (Field5) — VARCHAR(180)
- subject_id (Key4) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
mimiciv_hosp.labevents (hosp11)
- labevent_id (Key) — INTEGER — 기본 키 — NOT NULL
- hadm_id (Field2) — INTEGER
- specimen_id (Field3) — INTEGER — NOT NULL
- order_provider_id (Field5) — VARCHAR(10)
- charttime (Field6) — TIMESTAMP(0)
- storetime (Field7) — TIMESTAMP(0)
- value (Field8) — VARCHAR(200)
- valuenum (Field9) — DOUBLE PRECISION
- valueuom (Field10) — VARCHAR(20)
- ref_range_lower (Field11) — DOUBLE PRECISION
- ref_range_upper (Field12) — DOUBLE PRECISION
- flag (Field13) — VARCHAR(10)
- priority (Field14) — VARCHAR(7)
- comments (Field15) — TEXT
- subject_id (Key2) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
- itemid (Key3) — INTEGER — 외래 키 → mimiciv_hosp.d_labitems.itemid — NOT NULL
mimiciv_hosp.microbiologyevents (hosp12)
- microevent_id (Key) — INTEGER — 기본 키 — NOT NULL
- micro_specimen_id (Field3) — INTEGER — NOT NULL
- order_provider_id (Field4) — VARCHAR(10)
- chartdate (Field5) — TIMESTAMP(0) — NOT NULL
- charttime (Field6) — TIMESTAMP(0)
- spec_itemid (Field7) — INTEGER — NOT NULL
- spec_type_desc (Field8) — VARCHAR(100) — NOT NULL
- test_seq (Field9) — INTEGER — NOT NULL
- storedate (Field10) — TIMESTAMP(0)
- storetime (Field11) — TIMESTAMP(0)
- test_itemid (Field12) — INTEGER
- test_name (Field13) — VARCHAR(100)
- org_itemid (Field14) — INTEGER
- org_name (Field15) — VARCHAR(100)
- isolate_num (Field16) — SMALLINT
- quantity (Field17) — VARCHAR(50)
- ab_itemid (Field18) — INTEGER
- ab_name (Field19) — VARCHAR(30)
- dilution_text (Field20) — VARCHAR(10)
- dilution_comparison (Field21) — VARCHAR(20)
- dilution_value (Field22) — DOUBLE PRECISION
- interpretation (Field23) — VARCHAR(5)
- comments (Field24) — TEXT
- subject_id (Key2) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
- hadm_id (Key3) — INTEGER — 외래 키 → mimiciv_hosp.admissions.hadm_id
mimiciv_hosp.omr (hosp13)
- subject_id (Field) — INTEGER — NOT NULL
- chartdate (Field2) — DATE — NOT NULL
- seq_num (Field3) — INTEGER — NOT NULL
- result_name (Field4) — VARCHAR(100) — NOT NULL
- result_value (Field5) — TEXT — NOT NULL
mimiciv_hosp.patients (hosp14)
- subject_id (Key) — INTEGER — 기본 키 — NOT NULL
- gender (Field) — CHAR(1) — NOT NULL
- anchor_age (Field2) — SMALLINT
- anchor_year (Field3) — SMALLINT — NOT NULL
- anchor_year_group (Field4) — VARCHAR(20) — NOT NULL
- dod (Field5) — DATE
mimiciv_hosp.pharmacy (hosp15)
- pharmacy_id (Key) — INTEGER — 기본 키 — NOT NULL
- poe_id (Field3) — VARCHAR(25)
- starttime (Field4) — TIMESTAMP(3)
- stoptime (Field5) — TIMESTAMP(3)
- medication (Field6) — TEXT
- proc_type (Field7) — VARCHAR(50) — NOT NULL
- status (Field8) — VARCHAR(50)
- entertime (Field9) — TIMESTAMP(3) — NOT NULL
- verifiedtime (Field10) — TIMESTAMP(3)
- route (Field11) — VARCHAR(50)
- frequency (Field12) — VARCHAR(50)
- disp_sched (Field13) — VARCHAR(255)
- infusion_type (Field14) — VARCHAR(15)
- sliding_scale (Field15) — VARCHAR(1)
- lockout_interval (Field16) — VARCHAR(50)
- basal_rate (Field17) — REAL
- one_hr_max (Field18) — VARCHAR(10)
- doses_per_24_hrs (Field19) — REAL
- duration (Field20) — REAL
- duration_interval (Field21) — VARCHAR(50)
- expiration_value (Field22) — INTEGER
- expiration_unit (Field23) — VARCHAR(50)
- expirationdate (Field24) — TIMESTAMP(3)
- dispensation (Field25) — VARCHAR(50)
- fill_quantity (Field26) — VARCHAR(50)
- subject_id (Key2) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
- hadm_id (Key3) — INTEGER — 외래 키 → mimiciv_hosp.admissions.hadm_id — NOT NULL
mimiciv_hosp.poe (hosp17)
- poe_id (Key) — VARCHAR(25) — 기본 키 — NOT NULL
- poe_seq (Field) — INTEGER — NOT NULL
- ordertime (Field4) — TIMESTAMP(0) — NOT NULL
- order_type (Field5) — VARCHAR(25) — NOT NULL
- order_subtype (Field6) — VARCHAR(50)
- transaction_type (Field7) — VARCHAR(15)
- discontinue_of_poe_id (Field8) — VARCHAR(25)
- discontinued_by_poe_id (Field9) — VARCHAR(25)
- order_provider_id (Field10) — VARCHAR(10)
- order_status (Field11) — VARCHAR(15)
- subject_id (Key2) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
- hadm_id (Key3) — INTEGER — 외래 키 → mimiciv_hosp.admissions.hadm_id
mimiciv_hosp.poe_detail (hosp16)
- field_name (Key2) — VARCHAR(255) — 기본 키 — NOT NULL
- poe_id (Key4) — VARCHAR(25) — 외래 키 → mimiciv_hosp.poe.poe_id — NOT NULL
- poe_seq (Field) — INTEGER — NOT NULL
- field_value (Field3) — TEXT
- subject_id (Key3) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
mimiciv_hosp.prescriptions (hosp18)
- pharmacy_id (Key) — INTEGER — 기본 키 — NOT NULL
- drug_type (Key2) — VARCHAR(20) — 기본 키 — NOT NULL
- drug (Key3) — VARCHAR(255) — 기본 키 — NOT NULL
- poe_id (Field3) — VARCHAR(25)
- poe_seq (Field4) — INTEGER
- order_provider_id (Field5) — VARCHAR(10)
- starttime (Field6) — TIMESTAMP(3)
- stoptime (Field7) — TIMESTAMP(3)
- formulary_drug_cd (Field8) — VARCHAR(50)
- gsn (Field9) — VARCHAR(255)
- ndc (Field10) — VARCHAR(25)
- prod_strength (Field11) — VARCHAR(255)
- form_rx (Field12) — VARCHAR(25)
- dose_val_rx (Field13) — VARCHAR(100)
- dose_unit_rx (Field14) — VARCHAR(50)
- form_val_disp (Field15) — VARCHAR(50)
- form_unit_disp (Field16) — VARCHAR(50)
- doses_per_24_hrs (Field17) — REAL
- route (Field18) — VARCHAR(50)
- subject_id (Key4) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
- hadm_id (Key5) — INTEGER — 외래 키 → mimiciv_hosp.admissions.hadm_id — NOT NULL
mimiciv_hosp.procedures_icd (hosp19)
- seq_num (Key2) — INTEGER — 기본 키 — NOT NULL
- icd_code (Key3) — VARCHAR(7) — 기본 키
- icd_version (Key4) — SMALLINT — 기본 키
- hadm_id (Key6) — INTEGER — 외래 키 → mimiciv_hosp.admissions.hadm_id — NOT NULL
- chartdate (Field2) — DATE — NOT NULL
- subject_id (Key5) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
mimiciv_hosp.provider (hosp20)
- provider_id (Field) — VARCHAR(10) — NOT NULL
mimiciv_hosp.services (hosp21)
- transfertime (Key2) — TIMESTAMP — 기본 키 — NOT NULL
- curr_service (Key3) — VARCHAR(10) — 기본 키
- hadm_id (Key5) — INTEGER — 외래 키 → mimiciv_hosp.admissions.hadm_id — NOT NULL
- prev_service (Field2) — VARCHAR(10)
- subject_id (Key4) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
mimiciv_hosp.transfers (hosp22)
- transfer_id (Key) — INTEGER — 기본 키 — NOT NULL
- hadm_id (Field2) — INTEGER
- eventtype (Field3) — VARCHAR(10)
- careunit (Field4) — VARCHAR(255)
- intime (Field5) — TIMESTAMP
- outtime (Field6) — TIMESTAMP
- subject_id (Key2) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
mimiciv_icu.caregiver (ICU)
- caregiver_id (KEY) — INTEGER — 기본 키 — NOT NULL
mimiciv_icu.chartevents (2)
- caregiver_id (Field4) — INTEGER
- charttime (Field5) — TIMESTAMP — NOT NULL
- storetime (Field6) — TIMESTAMP
- value (Field8) — VARCHAR(200)
- valuenum (Field9) — FLOAT
- valueuom (Field11) — VARCHAR(20)
- warning (Field10) — SMALLINT
- subject_id (Key) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
- hadm_id (Key2) — INTEGER — 외래 키 → mimiciv_hosp.admissions.hadm_id — NOT NULL
- stay_id (Key6) — INTEGER — 외래 키 → mimiciv_icu.icustays.stay_id — NOT NULL
- itemid (Key3) — INTEGER — 외래 키 → mimiciv_icu.d_items.itemid — NOT NULL
mimiciv_icu.d_items (4)
- itemid (Key) — INTEGER — 기본 키 — NOT NULL
- label (Field) — VARCHAR(100) — NOT NULL
- abbreviation (Field2) — VARCHAR(50) — NOT NULL
- linksto (Field3) — VARCHAR(30) — NOT NULL
- category (Field4) — VARCHAR(50) — NOT NULL
- unitname (Field5) — VARCHAR(50)
- param_type (Field6) — VARCHAR(20) — NOT NULL
- lownormalvalue (Field7) — FLOAT
- highnormalvalue (Field8) — FLOAT
mimiciv_icu.datetimeevents (3)
- charttime (key) — TIMESTAMP — 기본 키 — NOT NULL
- subject_id (Key2) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
- stay_id (Key6) — INTEGER — 외래 키 → mimiciv_icu.icustays.stay_id — NOT NULL
- itemid (Key3) — INTEGER — 외래 키 → mimiciv_icu.d_items.itemid — NOT NULL
- caregiver_id (Field3) — INTEGER
- storetime (Field5) — TIMESTAMP
- value (Field7) — TIMESTAMP — NOT NULL
- valueuom (Field8) — VARCHAR(20)
- warning (Field9) — SMALLINT
- hadm_id (Key) — INTEGER — 외래 키 → mimiciv_hosp.admissions.hadm_id — NOT NULL
mimiciv_icu.icustays (5)
- stay_id (Key6) — INTEGER — 기본 키 — NOT NULL
- first_careunit (Field3) — VARCHAR(255)
- last_careunit (Field4) — VARCHAR(255)
- intime (Field5) — TIMESTAMP
- outtime (Field6) — TIMESTAMP
- los (Field7) — FLOAT
- subject_id (Key2) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
- hadm_id (Key) — INTEGER — 외래 키 → mimiciv_hosp.admissions.hadm_id — NOT NULL
mimiciv_icu.ingredientevents (6)
- hadm_id (Field) — INTEGER
- subject_id (Key) — INTEGER — NOT NULL
- stay_id (Field2) — INTEGER
- caregiver_id (Field3) — INTEGER
- starttime (Field4) — TIMESTAMP
- endtime (Field5) — TIMESTAMP
- storetime (Field6) — TIMESTAMP
- itemid (Field7) — INTEGER
- amount (Field8) — FLOAT
- amountuom (Field9) — VARCHAR(20)
- rate (Field10) — FLOAT
- rateuom (Field11) — VARCHAR(20)
- orderid (Field12) — INTEGER
- linkorderid (Field13) — INTEGER
- statusdescription (Field14) — VARCHAR(20)
- originalamount (Field15) — FLOAT
- originalrate (Field16) — FLOAT
mimiciv_icu.inputevents (7)
- orderid (Field12) — INTEGER — 기본 키 — NOT NULL
- itemid (Key3) — INTEGER — 외래 키 → mimiciv_icu.d_items.itemid — NOT NULL
- caregiver_id (Field3) — INTEGER
- starttime (Field4) — TIMESTAMP — NOT NULL
- endtime (Field5) — TIMESTAMP — NOT NULL
- storetime (Field6) — TIMESTAMP
- amount (Field8) — FLOAT
- amountuom (Field9) — VARCHAR(20)
- rate (Field10) — FLOAT
- rateuom (Field11) — VARCHAR(20)
- linkorderid (Field13) — INTEGER
- ordercategoryname (Field14) — VARCHAR(50)
- secondaryordercategoryname (Field15) — VARCHAR(50)
- ordercomponenttypedescription (Field16) — VARCHAR(100)
- ordercategorydescription (Field17) — VARCHAR(30)
- patientweight (Field18) — FLOAT
- totalamount (Field19) — FLOAT
- totalamountuom (Field20) — VARCHAR(50)
- isopenbag (Field21) — SMALLINT
- continueinnextdept (Field22) — SMALLINT
- statusdescription (Field23) — VARCHAR(20)
- originalamount (Field24) — FLOAT
- originalrate (Field25) — FLOAT
- subject_id (Key2) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
- hadm_id (Key) — INTEGER — 외래 키 → mimiciv_hosp.admissions.hadm_id — NOT NULL
- stay_id (Key6) — INTEGER — 외래 키 → mimiciv_icu.icustays.stay_id — NOT NULL
mimiciv_icu.outputevents (8)
- charttime (Field4) — TIMESTAMP(3) — 기본 키 — NOT NULL
- stay_id (Key6) — INTEGER — 외래 키 → mimiciv_icu.icustays.stay_id — NOT NULL
- itemid (Key3) — INTEGER — 외래 키 → mimiciv_icu.d_items.itemid — NOT NULL
- caregiver_id (Field3) — INTEGER
- storetime (Field5) — TIMESTAMP(3) — NOT NULL
- value FLOAT (Field7) — FLOAT — NOT NULL
- valueuom (Field8) — VARCHAR
- subject_id (Key2) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
- hadm_id (Key) — INTEGER — 외래 키 → mimiciv_hosp.admissions.hadm_id — NOT NULL
mimiciv_icu.procedureevents (9)
- orderid (Field12) — INTEGER — 기본 키
- caregiver_id (Field3) — INTEGER
- starttime (Field4) — TIMESTAMP — NOT NULL
- endtime (Field5) — TIMESTAMP — NOT NULL
- storetime (Field6) — TIMESTAMP — NOT NULL
- value (Field8) — FLOAT
- valueuom (Field9) — VARCHAR(20)
- location (Field10) — VARCHAR(100)
- locationcategory (Field11) — VARCHAR(50)
- linkorderid (Field13) — INTEGER
- ordercategoryname (Field14) — VARCHAR(50)
- ordercategorydescription (Field15) — VARCHAR(30)
- patientweight (Field16) — FLOAT
- isopenbag (Field17) — SMALLINT
- continueinnextdept (Field18) — SMALLINT
- statusdescription (Field19) — VARCHAR(20)
- originalamount (Field20) — FLOAT
- originalrate (Field21) — FLOAT
- subject_id (Key2) — INTEGER — 외래 키 → mimiciv_hosp.patients.subject_id — NOT NULL
- hadm_id (Key) — INTEGER — 외래 키 → mimiciv_hosp.admissions.hadm_id — NOT NULL
- stay_id (Key6) — INTEGER — 외래 키 → mimiciv_icu.icustays.stay_id — NOT NULL
- itemid (Key3) — INTEGER — 외래 키 → mimiciv_icu.d_items.itemid — NOT NULL