HW4W_관계 데이터 모델 설계

테이블 (31)

mimiciv_hosp.admissions

  • Key (hadm_id) — INTEGER — 기본 키 — NOT NULL
  • Field (admittime) — TIMESTAMP — NOT NULL
  • Field (dischtime) — TIMESTAMP
  • Field (deathtime) — TIMESTAMP
  • Field (admission_type) — VARCHAR(40) — NOT NULL
  • Field (admit_provider_id) — VARCHAR(10)
  • Field (admission_location) — VARCHAR(60)
  • Field (discharge_location) — VARCHAR(60)
  • Field (insurance) — VARCHAR(255)
  • Field (language) — VARCHAR(10)
  • Field (marital_status) — VARHCAR(30)
  • Field (race) — VARCHAR(80)
  • Field (edregtime) — TIMESTAMP
  • Field (edouttime) — TIMESTAMP
  • Field (hospital_expire_flag) — SMALLINT
  • Key (subject_id) — INTEGER — 외래 키 → mimiciv_hosp.patients.Key — NOT NULL

mimiciv_hosp.d_hcpcs

  • Key (code) — CHAR(5) — 기본 키 — NOT NULL
  • Field (category) — SMALLINT
  • Field (long_description) — TEXT
  • Field (short_description) — VARCHAR(180)

mimiciv_hosp.d_icu_diagnoses (mimiciv_hosp.d_icd_diagnoses)

  • Key (icd_code) — CHAR(7) — 기본 키 — NOT NULL
  • Key (icd_version) — SMALLINT — 기본 키 — NOT NULL
  • Field (long_title) — VARCHAR(255)

mimiciv_hosp.d_icu_procedures (mimiciv_hosp.d_icd_procedures)

  • Key (icd_code) — CHAR(7) — 기본 키 — NOT NULL
  • Key (icd_version) — SMALLINT — 기본 키 — NOT NULL
  • Field (long_title) — VARCHAR(222)

mimiciv_hosp.d_labitems

  • Key (itemid) — INTEGER — 기본 키 — NOT NULL
  • Field (label) — VARCHAR(50)
  • Field (fluid) — VARCHAR(50)
  • Field (category) — VARCHAR(50)

mimiciv_hosp.diagnoses_icd

  • Key (hadm_id) — INTEGER — 기본 키 — NOT NULL
  • Key (seq_num) — INTEGER — 기본 키 — NOT NULL
  • Key2 (icd_code) — CHAR(7) — 기본 키 — NOT NULL
  • Key3 (icd_version) — SMALLINT — 기본 키 — NOT NULL
  • Field (subject_id) — INTEGER — NOT NULL

mimiciv_hosp.drgcodes

  • Key (drg_code) — VARCHAR(10) — 기본 키 — NOT NULL
  • Key2 (description) — VARCHAR(195) — 기본 키 — NOT NULL
  • Key3 (drg_severity) — SMALLINT — 기본 키 — NOT NULL
  • Key4 (drg_mortality) — SMALLINT — 기본 키 — NOT NULL
  • Key5 (drg_type) — VARCHAR(4) — 기본 키 — NOT NULL
  • Field1 (hadm_id) — INTEGER — NOT NULL
  • Key (subject_id) — INTEGER — 외래 키 → mimiciv_hosp.patients.Key — NOT NULL

mimiciv_hosp.emar

  • Key (emar_id) — VARCHAR(25) — 기본 키 — NOT NULL
  • Field3 (emar_seq) — INTEGER — NOT NULL
  • Field4 (poe_id) — VARCHAR(25) — NOT NULL
  • Field5 (pharmacy_id) — INTEGER
  • Field6 (enter_provider_id) — VARCHAR(10)
  • Field7 (charttime) — TIMESTAMP — NOT NULL
  • Field8 (medication) — TEXT
  • Field9 (event_txt) — VARCHAR(100)
  • Field10 (scheduletime) — TIMESTAMP
  • Field11 (storetime) — TIMESTAMP — NOT NULL
  • Key (subject_id) — INTEGER — 외래 키 → mimiciv_hosp.patients.Key — NOT NULL
  • Key (hadm_id) — INTEGER — 외래 키 → mimiciv_hosp.admissions.Key — NOT NULL

mimiciv_hosp.emar_detail

  • Key2 (parent_field_ordinal) — VARCHAR(10) — 기본 키 — NOT NULL
  • Key (emar_id) — VARCHAR(25) — 외래 키 → mimiciv_hosp.emar.Key — NOT NULL
  • Field2 (emar_seq) — INTEGER — NOT NULL
  • Field3 (administration_type) — VARCHAR(50)
  • Field4 (pharmacy_id) — INTEGER
  • Field5 (barcode_type) — VARCHAR(4)
  • Field6 (reason_for_no_barcode) — TEXT
  • Field7 (complete_dose_not_given) — VARCHAR(5)
  • Field8 (dose_due) — VARCHAR(100)
  • Field9 (dose_due_unit) — VARCHAR(50)
  • Field10 (dose_given) — VARCHAR(255)
  • Field11 (dose_given_unit) — VARCHAR(50)
  • Field12 (will_remainder_of_dose_be_given) — VARCHAR(5)
  • Field13 (product_amount_given) — VARCHAR(30)
  • Field14 (product_unit) — VARCHAR(30)
  • Field15 (product_code) — VARCHAR(30)
  • Field16 (product_description) — VARCHAR(255)
  • Field17 (product_description_other) — VARCHAR(255)
  • Field18 (prior_infusion_rate) — VARCHAR(40)
  • Field19 (infusion_rate) — VARCHAR(40)
  • Field20 (infusion_rate_adjustment) — VARCHAR(50)
  • Field21 (infusion_rate_adjustment_amount) — VARCHAR(30)
  • Field22 (infusion_rate_unit) — VARCHAR(30)
  • Field23 (route) — VARCHAR(10)
  • Field24 (infusion_complete) — VARCHAR(1)
  • Field25 (completion_interval) — VARCHAR(50)
  • Field26 (new_iv_bag_hung) — VARCHAR(1)
  • Field27 (continued_infusion_in_other_location) — VARCHAR(1)
  • Field28 (restart_interval) — VARCHAR(2305)
  • Field29 (side) — VARCHAR(10)
  • Field30 (site) — VARCHAR(255)
  • Field31 (non_formulary_visual_verification) — VARCHAR(1)
  • Key (subject_id) — INTEGER — 외래 키 → mimiciv_hosp.patients.Key — NOT NULL

mimiciv_hosp.hcpcsevents

  • Key2 (hcpcs_cd) — CHAR(5) — 기본 키 — NOT NULL
  • Key3 (seq_num) — INTEGER — 기본 키 — NOT NULL
  • Key (hadm_id) — INTEGER — 외래 키 → mimiciv_hosp.admissions.Key — NOT NULL
  • Key (code) — CHAR(5) — 외래 키 → mimiciv_hosp.d_hcpcs.Key — NOT NULL
  • Field2 (chartdate) — DATE
  • Field3 (short_description) — VARCHAR(180)
  • Key (subject_id) — INTEGER — 외래 키 → mimiciv_hosp.patients.Key — NOT NULL

mimiciv_hosp.labevents

  • Key (labevent_id) — INTEGER — 기본 키 — NOT NULL
  • Key (subject_id) — INTEGER — 외래 키 → mimiciv_hosp.patients.Key — NOT NULL
  • Key (itemid) — INTEGER — 외래 키 → mimiciv_hosp.d_labitems.Key — NOT NULL
  • Field (hadm_id) — INTEGER
  • Field (specimen_id) — INTEGER — NOT NULL
  • Field (order_provider_id) — VARCHAR(10)
  • Field (chartime) — TIMESTAMP(0)
  • Field (storetime) — TIMESTAMP(0)
  • Field (value) — VARCHAR(200)
  • Field (valuenum) — DOUBLE
  • Field (valueuom) — VARCHAR(20)
  • Field (ref_range_lower) — DOUBLE
  • Field (ref_range_upper) — DOUBLE
  • Field (flag) — VARCHAR(10)
  • Field (priority) — VARCHAR(7)
  • Field (comments) — TEXT

mimiciv_hosp.microbiologyevents

  • Key (microevent_id) — INTEGER — 기본 키 — NOT NULL
  • Key (subject_id) — INTEGER — 외래 키 → mimiciv_hosp.patients.Key — NOT NULL
  • Key (hadm_id) — INTEGER — 외래 키 → mimiciv_hosp.admissions.Key — NOT NULL
  • Field (micro_specimen_id) — INTEGER — NOT NULL
  • Field (order_provider_id) — VARCHAR(10)
  • Field (chartdate) — TIMESTAMP(0) — NOT NULL
  • Field (charttime) — TIMESTAMP(0)
  • Field (spec_tiemid) — INTEGER — NOT NULL
  • Field (spec_type_desc) — VARCHAR(100) — NOT NULL
  • Field (test_seq) — INTEGER — NOT NULL
  • Field (storedate) — TIMESTAMP(0)
  • Field (storetime) — TIMESTAMP(0)
  • Field (test_itemid) — INTEGER
  • Field (test_name) — VARCHAR(100)
  • Field (org_itemid) — INTEGER
  • Field (org_name) — VARCHAR(50)
  • Field (isolate_num) — SMALLINT
  • Field (quantity) — VARCHAR(50)
  • Field (ab_itemid) — INTEGER
  • Field (ab_name) — VARCHAR(30)
  • Field (dilution_text) — VARCHAR(10)
  • Field (dilution_comparision) — VARCHAR(20)
  • Field (dilution_value) — DOUBLE
  • Field (interpretation) — VARCHAR(5)
  • Field (coments) — TEXT

mimiciv_hosp.omr

  • Key (subject_id) — INTEGER — 기본 키 — NOT NULL
  • Field (chartdate) — DATE — NOT NULL
  • Field (seq_num) — INTEGER — NOT NULL
  • Field (result_name) — VARCHAR(100) — NOT NULL
  • Field (result_value) — TEXT — NOT NULL

mimiciv_hosp.patients

  • Key (subject_id) — INTEGER — 기본 키 — NOT NULL
  • Field (gender) — CHAR(1) — NOT NULL
  • Field (anchor_age) — SMALLINT
  • Field (anchor_year) — SMALLINT — NOT NULL
  • Field (anchor_year_group) — VARCHAR(20) — NOT NULL
  • Field (dod) — DATE

mimiciv_hosp.pharmacy

  • Key (pharmacy_id) — INTEGER — 기본 키 — NOT NULL
  • Key (subject_id) — INTEGER — 외래 키 → mimiciv_hosp.patients.Key — NOT NULL
  • Key (hadm_id) — INTEGER — 외래 키 → mimiciv_hosp.admissions.Key — NOT NULL
  • Field (poe_id) — VARCHAR(25)
  • Field (starttime) — TIMESTAMP(3)
  • Field (stoptime) — TIMESTAMP(3)
  • Field (medication) — TEXT
  • Field (proc_type) — VARCHAR(50) — NOT NULL
  • Field (status) — VARCHAR(50)
  • Field (entertime) — TIMESTAMP(3) — NOT NULL
  • Field (verifiedtime) — TIMESTAMP(3)
  • Field (route) — VARCHAR(50)
  • Field (frequency) — VARCHAR(50)
  • Field (disp_sched) — VARCHAR(255)
  • Field (infusion_type) — VARCHAR(15)
  • Field (sliding_scale) — VARCHAR(1)
  • Field (lockout_interval) — VARCHAR(50)
  • Field (basal_rate) — REAL
  • Field — VARCHAR(10)
  • Field (doses_per_24_hrs) — REAL
  • Field (duration) — REAL
  • Field (duration_interval) — VARCHAR(50)
  • Field (expiration_value) — INTEGER
  • Field (expiration_unit) — VARCHAR(50)
  • Field (expirationdate) — TIMESTAMP(3)
  • Field (dispensation) — VARCHAR(50)
  • Field (fill_quantity) — VARCAHR(50)

mimiciv_hosp.poe

  • Key (poe_id) — VARCHAR(25) — 기본 키 — NOT NULL
  • Field2 (poe_seq) — INTEGER — NOT NULL
  • Field5 (ordertime) — TIMESTAMP(0) — NOT NULL
  • Field6 (order_type) — VARCHAR(25) — NOT NULL
  • Field7 (order_subtype) — VARCHAR(50)
  • Field8 (transaction_type) — VARCHAR(15)
  • Field9 (discontinue_of_poe_id) — VARCHAR(25)
  • Field10 (discontinued_by_poe_id) — VARCHAR(25)
  • Field11 (order_provider_id) — VARCHAR(10)
  • Field12 (order_status) — VARCHAR(15)
  • Key (subject_id) — INTEGER — 외래 키 → mimiciv_hosp.patients.Key — NOT NULL
  • Key (hadm_id) — INTEGER — 외래 키 → mimiciv_hosp.admissions.Key — NOT NULL

mimiciv_hosp.poe_detail

  • Key (poe_id) — VARCHAR(25) — 외래 키 → mimiciv_hosp.poe.Key — NOT NULL
  • Field (poe_seq) — INTEGER — NOT NULL
  • Field (field_name) — VARCHAR(255) — NOT NULL
  • Field (field_value) — TEXT
  • Key (subject_id) — INTEGER — 외래 키 → mimiciv_hosp.patients.Key — NOT NULL

mimiciv_hosp.prescriptions

  • Key (pharmacy_id) — INTEGER — 기본 키 — NOT NULL
  • Key (drug_type) — VARCHAR(20) — 기본 키 — NOT NULL
  • Key (drug) — VARCHAR(255) — 기본 키 — NOT NULL
  • Field (poe_id) — VARCHAR(25)
  • Field (poe_seq) — INTEGER
  • Field (order_provider_id) — VARCHAR(10)
  • Field (starttime) — TIMESTAMP(3)
  • Field (stoptime) — TIMESTAMP(3)
  • Field (formulary_drug_cd) — VARCHAR(50)
  • Field (gsn) — VARCHAR(255)
  • Field (ndc) — VARCHAR(25)
  • Field (prod_strength) — VARCHAR(255)
  • Field (form_rx) — VARCHAR(25)
  • Field (dose_val_rx) — VARCHAR(100)
  • Field (dose_unit_rx) — VARCHAR(50)
  • Field (form_val_disp) — VARCHAR(50)
  • Field (form_unit_disp) — VARCHAR(50)
  • Field (doses_per_24_hrs) — REAL
  • Field (route) — VARCHAR(50)
  • Key (subject_id) — INTEGER — 외래 키 → mimiciv_hosp.patients.Key — NOT NULL
  • Key (hadm_id) — INTEGER — 외래 키 → mimiciv_hosp.admissions.Key — NOT NULL

mimiciv_hosp.procedures_icd

  • Key (icd_code) — VARCHAR(7) — 기본 키 — NOT NULL
  • Key (icd_version) — SMALLINT — 기본 키 — NOT NULL
  • Key (seq_num) — INTEGER — 기본 키 — NOT NULL
  • Key (hadm_id) — INTEGER — 외래 키 → mimiciv_hosp.admissions.Key — NOT NULL
  • Field (chartdate) — DATE — NOT NULL
  • Key (subject_id) — INTEGER — 외래 키 → mimiciv_hosp.patients.Key — NOT NULL

mimiciv_hosp.provider

  • Field (provider_id) — VARCHAR(10) — NOT NULL

mimiciv_hosp.services

  • Key (transfertime) — TIMESTAMP — 기본 키 — NOT NULL
  • Key (curr_service) — VARCHAR(10) — 기본 키 — NOT NULL
  • Key (hadm_id) — INTEGER — 외래 키 → mimiciv_hosp.admissions.Key — NOT NULL
  • Field (prev_service) — VARCHAR(10)
  • Key (subject_id) — INTEGER — 외래 키 → mimiciv_hosp.patients.Key — NOT NULL

mimiciv_hosp.transfers

  • Key (transfer_id) — INTEGER — 기본 키 — NOT NULL
  • Field (hadm_id) — INTEGER
  • Field (eventtype) — VARCHAR(10)
  • Field (careunit) — VARCHAR(255)
  • Field (intime) — TIMESTAMP
  • Field (outtime) — TIMESTAMP
  • Key (subject_id) — INTEGER — 외래 키 → mimiciv_hosp.patients.Key — NOT NULL

mimiciv_icu.caregivers

  • Field (caregiver_id) — INTEGER — NOT NULL

mimiciv_icu.chartevents

  • Field (caregiver_id) — INTEGER
  • Field (charttime) — TIMESTAMP — NOT NULL
  • Field (storetime) — TIMESTAMP
  • Field (value) — VARCHAR(200)
  • Field (valuenum) — FLOAT
  • Field (valueuom) — VARCHAR(20)
  • Field (warning) — SMALLINT
  • Key (subject_id) — INTEGER — 외래 키 → mimiciv_hosp.patients.Key — NOT NULL
  • Key (hadm_id) — INTEGER — 외래 키 → mimiciv_hosp.admissions.Key — NOT NULL
  • Key (itemid) — INTEGER — 외래 키 → mimiciv_icu.d_items.Key — NOT NULL

mimiciv_icu.d_items

  • Key (itemid) — INTEGER — 기본 키 — NOT NULL
  • Field (label) — VARCHAR(100) — NOT NULL
  • Field2 (abbreviation) — VARCHAR(50) — NOT NULL
  • Field3 (linksto) — VARCHAR(30) — NOT NULL
  • Field4 (category) — VARCHAR(50) — NOT NULL
  • Field5 (unitname) — VARCHAR(50)
  • Field6 (param_type) — VARCHAR(20) — NOT NULL
  • Field7 (lownormalvalue) — FLOAT
  • Field8 (highnormalvalue) — FLOAT

mimiciv_icu.datetimeevents

  • Key2 (charttime) — TIMESTAMP — 기본 키 — NOT NULL
  • Key (subject_id) — INTEGER — 외래 키 → mimiciv_hosp.patients.Key — NOT NULL
  • Key3 (itemid) — INTEGER — 외래 키 — NOT NULL
  • Field (caregiver_id) — INTEGER
  • Field (storetime) — TIMESTAMP
  • Field (value) — TIMESTAMP — NOT NULL
  • Field (valueuom) — VARCHAR(20)
  • Field (warning) — SMALLINT
  • Key (hadm_id) — INTEGER — 외래 키 → mimiciv_hosp.admissions.Key — NOT NULL
  • Key (stay_id) — INTEGER — 외래 키 → mimiciv_icu.icustays.Key — NOT NULL

mimiciv_icu.icustays

  • Key (stay_id) — INTEGER — 기본 키 — NOT NULL
  • Key (subject_id) — INTEGER — 외래 키 → mimiciv_hosp.patients.Key — NOT NULL
  • Key (hadm_id) — INTEGER — 외래 키 → mimiciv_hosp.admissions.Key — NOT NULL
  • Field (first_careunit) — VARCHAR(255)
  • Field (last_careunit) — VARCHAR(255)
  • Field (intime) — TIMESTAMP
  • Field (outtime) — TIMASTAMP
  • Field (los) — FLOAT

mimiciv_icu.ingredientevents

  • Field (subject_id) — INTEGER — NOT NULL
  • Field (hadm_id) — INTEGER — NOT NULL
  • Field (stay_id) — INTEGER
  • Field (caregiver_id) — INTEGER
  • Field (starttime) — TIMESTAMP — NOT NULL
  • Field (endtime) — TIMASTAMP — NOT NULL
  • Field (storetime) — TIMASTAMP
  • Field (itemid) — INTEGER — NOT NULL
  • Field (amount) — FLOAT
  • Field (amountuom) — VARCHAR(20)
  • Field (rate) — FLOAT
  • Field (rateuom) — VARCHAR(20)
  • Field (orderid) — INTEGER — NOT NULL
  • Field (Fieldlinkorderid) — INTEGER
  • Field (statusdescription) — VARCHAR(20)
  • Field (originalamount) — FLOAT
  • Field (originalrate) — FLOAT

mimiciv_icu.inputevents

  • Key (orderid) — INTEGER — 기본 키 — NOT NULL
  • Key (itemid) — INTEGER — 외래 키 → mimiciv_icu.d_items.Key — NOT NULL
  • Field (caregiver_id) — INTEGER
  • Field (starttime) — TIMESTAMP — NOT NULL
  • Field (endtime) — TIMESTAMP — NOT NULL
  • Field (storetime) — TIMESTAMP
  • Field (amount) — FLOAT
  • Field (amountuom) — VARCHAR(20)
  • Field (rate) — FLOAT
  • Field (rateuom) — VARCHAR(20)
  • Field (linkorderid) — INTEGER,
  • Field (ordercategoryname) — VARCHAR(50)
  • Field (secondaryordercategoryname) — VARCHAR(50)
  • Field (ordercomponenttypedescription) — VARCHAR(100)
  • Field (ordercategorydescription) — VARCHAR(30)
  • Field (patientweight) — FLOAT
  • Field (totalamount) — FLOAT
  • Field (totalamountuom) — VARCHAR(50)
  • Field (isopenbag) — SMALLINT
  • Field (continueinnextdept) — SMALLINT
  • Field (statusdescription) — VARCHAR(20)
  • Field (originalamount) — FLOAT
  • Field (originalrate) — FLOAT
  • Key (subject_id) — INTEGER — 외래 키 → mimiciv_hosp.patients.Key — NOT NULL
  • Key (hadm_id) — INTEGER — 외래 키 → mimiciv_hosp.admissions.Key — NOT NULL
  • Key (stay_id) — INTEGER — 외래 키 → mimiciv_icu.icustays.Key — NOT NULL

mimiciv_icu.outputevents

  • Key (charttime) — TIMESTAMP(3) — 기본 키 — NOT NULL
  • Key (itemid) — INTEGER — 외래 키 → mimiciv_icu.d_items.Key — NOT NULL
  • Key (stay_id) — INTEGER — 외래 키 → mimiciv_icu.icustays.Key — NOT NULL
  • Field (caregiver_id) — INTEGER
  • Field (storetime) — TIMESTAMP(3) — NOT NULL
  • Field (value) — FLOAT — NOT NULL
  • Field (valueuom) — VARCHAR(20)
  • Key (subject_id) — INTEGER — 외래 키 → mimiciv_hosp.patients.Key — NOT NULL
  • Key (hadm_id) — INTEGER — 외래 키 → mimiciv_hosp.admissions.Key — NOT NULL

mimiciv_icu.procedureevents

  • Key (orderid) — INTEGER — 기본 키 — NOT NULL
  • Field (caregiver_id) — INTEGER
  • Field (starttime) — TIMESTAMP — NOT NULL
  • Field (endtime) — TIMESTAMP — NOT NULL
  • Field (storetime) — TIMESTAMP — NOT NULL
  • Field (value) — FLOAT
  • Field (valueuom) — VARCHAR(20)
  • Field (location) — VARCHAR(100)
  • Field (locationcategory) — VARCHAR(50)
  • Field (linkorderid) — INTEGER
  • Field (ordercategoryname) — VARCHAR(50)
  • Field (ordercategorydescription) — VARCHAR(30)
  • Field (patientweight) — FLOAT
  • Field (isopenbag) — SMALLINT
  • Field (continueinnextdept) — SMALLINT
  • Field (statusdescription) — VARCHAR(20)
  • Field (originalamount) — FLOAT
  • Field (originalrate) — FLOAT
  • Key (subject_id) — INTEGER — 외래 키 → mimiciv_hosp.patients.Key — NOT NULL
  • Key (hadm_id) — INTEGER — 외래 키 → mimiciv_hosp.admissions.Key — NOT NULL
  • Key (itemid) — INTEGER — 외래 키 → mimiciv_icu.d_items.Key — NOT NULL
  • Key (stay_id) — INTEGER — 외래 키 → mimiciv_icu.icustays.Key — NOT NULL