데이터베이스_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