DataBase_25_002_Team_9

Tables (31)

admissions.csv (입퇴원 이력 정보)

  • hadm_id (Key) — Primary key — NOT NULL
  • admittime (Field4) — NOT NULL
  • dischtime (Field5)
  • deathtime (Field2)
  • admission_type (Field6) — NOT NULL
  • admit_provider_id (Field7)
  • admission_location (Field16)
  • discharge_location (Field8)
  • insurance (Field9)
  • language (Field10)
  • marital_status (Field11)
  • race (Field12)
  • edregtime (Field13)
  • edouttime (Field14)
  • hospital_expire_flag (Field15)
  • subject_id (Key2) — Foreign key → patients.csv.subject_id — NOT NULL

caregiver.csv (ICU 의료진 고유 식별 번호)

  • caregiver_id (Key) — Primary key — NOT NULL

chartevents.csv (ICU 환자 정보 데이터)

  • caregiver_id (Field4)
  • charttime (Field)
  • storetime (Field6)
  • value (Field8)
  • valuenum (Field9)
  • valueuom (Field10)
  • warning (Field11)
  • subject_id (Key) — Foreign key → patients.csv.subject_id — NOT NULL
  • hadm_id (Key2) — Foreign key → admissions.csv.hadm_id — NOT NULL
  • stay_id (Key3) — Foreign key → icustays.csv.stay_id — NOT NULL
  • itemid (Key5) — Foreign key → d_items.csv.itemid — NOT NULL

d_hcpcs.csv (의료서비스 및 장비에 대한 정보)

  • code (Key) — Primary key — NOT NULL
  • category (Field2)
  • long_description (Field3)
  • short_description (Field4)

d_icd_diagnoses.csv (ICD 코드 체계 정보)

  • icd_code (Key) — Primary key — NOT NULL
  • icd_version (Key2) — Primary key — NOT NULL
  • long_title (Field3)

d_icd_procedures.csv (의료 절차 분류 데이터)

  • icd_code (Key) — Primary key — NOT NULL
  • icd_version (Key2) — Primary key — NOT NULL
  • long_title (Field3)

d_items.csv (장비와 절차)

  • itemid (Key) — Primary key — NOT NULL
  • label (Field2) — NOT NULL
  • abbreviation (Field3) — NOT NULL
  • linksto (Field4) — NOT NULL
  • category (Field5) — NOT NULL
  • unitname (Field6)
  • param_type (Field7) — NOT NULL
  • lownormalvalue (Field8)
  • highnormalvalue (Field9)

d_labitems.csv (체액 검사 항목)

  • itemid (Key) — Primary key — NOT NULL
  • label (Field2)
  • fluid (Field3)
  • category (Field4)

datetimeevents.csv (날짜 형식 환자 의료 데이터)

  • charttime (Key4) — Primary key — NOT NULL
  • itemid (Key6) — Primary key — NOT NULL
  • stay_id (Key7) — Primary key — NOT NULL
  • itemid (Key3) — Foreign key → d_items.csv.itemid — NOT NULL
  • stay_id (Key5) — Foreign key → icustays.csv.stay_id — NOT NULL
  • caregiver_id (Field4)
  • storetime (Field6)
  • value (Field8) — NOT NULL
  • valueuom (Field9)
  • warning (Field10)
  • subject_id (Key) — Foreign key → patients.csv.subject_id — NOT NULL
  • hadm_id (Key2) — Foreign key → admissions.csv.hadm_id — NOT NULL

diagnoses_icd.csv (입원에 대한 ICD 진단 데이터)

  • seq_num (Key3) — Primary key — NOT NULL
  • hadm_id (Key4) — Primary key — NOT NULL
  • icd_code (Key5) — Primary key
  • icd_version (Key6) — Primary key
  • hadm_id (Key2) — Foreign key → admissions.csv.hadm_id — NOT NULL
  • subject_id (Key) — Foreign key → patients.csv.subject_id — NOT NULL

drgcodes.csv (진단 정보)

  • drg_type (Field)
  • drg_code (Field4) — NOT NULL
  • description (Field5)
  • drg_severity (Field6)
  • drg_mortality (Field7)
  • subject_id (Key) — Foreign key → patients.csv.subject_id — NOT NULL
  • hadm_id (Key2) — Foreign key → admissions.csv.hadm_id — NOT NULL

emar.csv (투약 환자 관리)

  • emar_id (Key) — Primary key — NOT NULL
  • emar_seq (Field4) — NOT NULL
  • poe_id (Field5) — NOT NULL
  • pharmacy_id (Field6)
  • enter_provider_id (Field7)
  • charttime (Field8) — NOT NULL
  • medication (Field9)
  • event_txt (Field10)
  • scheduletime (Field11)
  • storetime (Field12) — NOT NULL
  • hadm_id (Key2) — Foreign key → admissions.csv.hadm_id — NOT NULL
  • subject_id (Key3) — Foreign key → patients.csv.subject_id — NOT NULL

emar_detail.csv (약물 투여 정보)

  • parent_field_oridinal (Key2) — Primary key — NOT NULL
  • emar_id (Key4) — Primary key — NOT NULL
  • emar_id (Key3) — Foreign key → emar.csv.emar_id — NOT NULL
  • parent_field_ordinal (Field14)
  • administration_type (Field15)
  • pharmacy_id (Field6)
  • barcode_type (Field16)
  • reason_for_no_barcode (Field17)
  • complete_dose_not_given (Field18)
  • dose_due (Field19)
  • dose_due_unit (Field20)
  • dose_given (Field21)
  • dose_given_unit (Field22)
  • will_remainder_of_dose_be_given (Field23)
  • product_amount_given (Field24)
  • product_unit (Field25)
  • product_code (Field26)
  • product_description (Field27)
  • product_description_other (Field28)
  • prior_infusion_rate (Field29)
  • infusion_rate (Field30)
  • infusion_rate_adjustment (Field31)
  • infusion_rate_adjustment_amount (Field32)
  • infusion_rate_unit (Field33)
  • route (Field2)
  • infusion_complet (Field5)
  • completion_interval (Field7)
  • new_iv_bag_hung (Field8)
  • continued_infusion_in_other_location (Field9)
  • restart_interval (Field10)
  • side (Field11)
  • site (Field12)
  • non_formulary_visual_verification (Field13)
  • subject_id (Key) — Foreign key → patients.csv.subject_id — NOT NULL

hcpcsevents.csv (입원 중 발생된 청구 이벤트)

  • hcpcs_cd (Key3) — Primary key — NOT NULL
  • seq_num (Key4) — Primary key — NOT NULL
  • hadm_id (Key6) — Primary key — NOT NULL
  • hadm_id (Key) — Foreign key → admissions.csv.hadm_id — NOT NULL
  • code (Key5) — Foreign key → d_hcpcs.csv.code — NOT NULL
  • chartdate (Field3)
  • short_description (Field6)
  • subject_id (Key2) — Foreign key → patients.csv.subject_id — NOT NULL

icustays.csv (ICU 입원 데이터)

  • stay_id (Key) — Primary key — NOT NULL
  • first_careunit (Field4)
  • last_careunit (Field5)
  • intime (Field6)
  • outtime (Field7)
  • los (Field8)
  • subject_id (Key2) — Foreign key → patients.csv.subject_id — NOT NULL
  • hadm_id (Key3) — Foreign key → admissions.csv.hadm_id — NOT NULL

ingredientevents.csv (투여 성분)

  • subject_id (Field) — NOT NULL
  • hadm_id (Field2) — NOT NULL
  • stay_id (Field3)
  • caregiver_id (Field4)
  • starttime (Field5) — NOT NULL
  • endtime (Field6) — NOT NULL
  • storetime (Field7)
  • itemid (Field8) — NOT NULL
  • amount (Field9)
  • amountuom (Field10)
  • rate (Field11)
  • rateuom (Field12)
  • orderid (Field13) — NOT NULL
  • linkorderid (Field14)
  • statusdescription (Field15)
  • originalamount (Field16)
  • originalrate (Field17)

inputevents.csv (투약 이벤트 기록)

  • orderid (Key) — Primary key — NOT NULL
  • itemid (Key2) — Primary key — NOT NULL
  • itemid (Key8) — Foreign key → d_items.csv.itemid — NOT NULL
  • caregiver_id (Field4)
  • endtime (Field6) — NOT NULL
  • storetime (Field7)
  • amount (Field9)
  • amountuom (Field10)
  • rate (Field11)
  • rateuom (Field12)
  • orderid (Field13) — NOT NULL
  • linkorderid (Field14)
  • ordercategoryname (Field15)
  • secondaryordercategoryname (Field16)
  • ordercomponenttypedescription (Field17)
  • ordercategorydescription (Field18)
  • patientweight (Field19)
  • totalamount (Field20)
  • totalamountuom (Field21)
  • isopenbag (Field22)
  • continueinnextdept (Field23)
  • statusdescription (Field24)
  • originalamount (Field25)
  • originalrate (Field26)
  • subject_id (Key5) — Foreign key → patients.csv.subject_id — NOT NULL
  • hadm_id (Key6) — Foreign key → admissions.csv.hadm_id — NOT NULL
  • stay_id (Key7) — Foreign key → icustays.csv.stay_id — NOT NULL

labevents.csv (실험실 측정 결과)

  • labevent_id (Key) — Primary key — NOT NULL
  • specimen_id (Field4) — NOT NULL
  • itemid (Field5) — NOT NULL
  • order_provider_id (Field6)
  • charttime (Field7)
  • storetime (Field8)
  • value (Field9)
  • valuenum (Field10)
  • valueuom (Field11)
  • ref_range_lower (Field12)
  • ref_range_upper (Field13)
  • flag (Field14)
  • priority (Field15)
  • comments (Field16)
  • hadm_id (Key2) — Foreign key → admissions.csv.hadm_id — NOT NULL
  • subject_id (Key3) — Foreign key → patients.csv.subject_id — NOT NULL

microbiologyevents.csv (미생물학 검사)

  • microevent_id (Key) — Primary key — NOT NULL
  • micro_specimen_id (Field4) — NOT NULL
  • order_provider_id (Field5)
  • chartdate (Field6) — NOT NULL
  • charttime (Field7)
  • spec_itemid (Field8) — NOT NULL
  • spec_type_desc (Field9) — NOT NULL
  • test_seq (Field10) — NOT NULL
  • storedate (Field11)
  • storetime (Field12)
  • test_itemid (Field13)
  • test_name (Field14)
  • org_itemid (Field15)
  • org_name (Field16)
  • isolate_num (Field17)
  • quantity (Field18)
  • ab_itemid (Field19)
  • ab_name (Field20)
  • dilution_text (Field21)
  • dilution_comparison (Field22)
  • dilution_value (Field23)
  • interpretation (Field24)
  • comments (Field25)
  • hadm_id (Key2) — Foreign key → admissions.csv.hadm_id — NOT NULL
  • subject_id (Key3) — Foreign key → patients.csv.subject_id — NOT NULL

omr.csv (외래 진료 기록)

  • subject_id (Key) — Primary key — NOT NULL
  • chartdate (Key2) — Primary key — NOT NULL
  • seq_num (Key3) — Primary key — NOT NULL
  • result_name (Field4) — NOT NULL
  • result_value (Field5) — NOT NULL

outputevents.csv (배출 이벤트 기록)

  • charttime (Key4) — Primary key — NOT NULL
  • itemid (Key6) — Primary key — NOT NULL
  • stay_id (Key7) — Primary key — NOT NULL
  • itemid (Key3) — Foreign key → d_items.csv.itemid — NOT NULL
  • stay_id (Key5) — Foreign key → icustays.csv.stay_id — NOT NULL
  • caregiver_id (Field4)
  • storetime (Field6) — NOT NULL
  • value (Field8) — NOT NULL
  • valueuom (Field9)
  • subject_id (Key) — Foreign key → patients.csv.subject_id — NOT NULL
  • hadm_id (Key2) — Foreign key → admissions.csv.hadm_id — NOT NULL

patients.csv (환자 정보)

  • subject_id (Key) — Primary key — NOT NULL
  • gender (Field2) — NOT NULL
  • anchor_age (Field3)
  • anchor_year (Field4) — NOT NULL
  • anchor_year_group (Field5) — NOT NULL
  • dod (Field6)

pharmacy.csv (약물 처방 데이터)

  • pharmacy_id (Key) — Primary key — NOT NULL
  • poe_id (Field4)
  • starttime (Field5)
  • stoptime (Field6)
  • medication (Field7)
  • proc_type (Field8) — NOT NULL
  • status (Field9)
  • entertime (Field10) — NOT NULL
  • verifiedtime (Field11)
  • route (Field12)
  • frequency (Field13)
  • disp_sched (Field14)
  • infusion_type (Field15)
  • sliding_scale (Field16)
  • lockout_interval (Field17)
  • basal_rate (Field18)
  • one_hr_max (Field19)
  • doses_per_24_hrs (Field20)
  • duration (Field21)
  • duration_interval (Field22)
  • expiration_value (Field23)
  • expiration_unit (Field24)
  • expirationdate (Field25)
  • dispensation (Field26)
  • fill_quantity (Field27)
  • subject_id (Key3) — Foreign key → patients.csv.subject_id — NOT NULL
  • hadm_id (Key4) — Foreign key → admissions.csv.hadm_id — NOT NULL

poe.csv (진료 오더 이력 데이터)

  • poe_id (Key) — Primary key — NOT NULL
  • poe_seq (Field2) — NOT NULL
  • ordertime (Field5) — NOT NULL
  • order_type (Field6) — NOT NULL
  • order_subtype (Field7)
  • transaction_type (Field8)
  • discontinue_of_poe_id (Field9)
  • discontinued_by_poe_id (Field10)
  • order_provider_id (Field11)
  • order_status (Field12)
  • hadm_id (Key2) — Foreign key → admissions.csv.hadm_id — NOT NULL
  • subject_id (Key3) — Foreign key → patients.csv.subject_id — NOT NULL

poe_detail.csv (의료진 오더에 대한 세부 항목과 값)

  • poe_id (Key) — Primary key — NOT NULL
  • field_name (Key2) — Primary key — NOT NULL
  • poe_id (Key4) — Foreign key → poe.csv.poe_id — NOT NULL
  • field_name (Field4) — NOT NULL
  • field_value (Field5)
  • subject_id (Key3) — Foreign key → patients.csv.subject_id — NOT NULL

prescriptions.csv (처방 약물 정보)

  • pharmacy_id (Key) — Primary key — NOT NULL
  • drug_type (Key4) — Primary key — NOT NULL
  • drug (Key5) — Primary key — NOT NULL
  • poe_id (Field4)
  • poe_seq (Field5)
  • order_provider_id (Field6)
  • starttime (Field7)
  • stoptime (Field8)
  • formulary_drug_cd (Field11)
  • gsn (Field12)
  • ndc (Field13)
  • prod_strength (Field14)
  • form_rx (Field15)
  • dose_val_rx (Field16)
  • dose_unit_rx (Field17)
  • form_val_disp (Field18)
  • form_unit_disp (Field19)
  • doses_per_24_hrs (Field20)
  • route (Field21)
  • hadm_id (Key2) — Foreign key → admissions.csv.hadm_id — NOT NULL
  • subject_id (Key3) — Foreign key → patients.csv.subject_id — NOT NULL

procedureevents.csv (ICU 입원 중 기록된 처치 정보)

  • orderid (Key4) — Primary key — NOT NULL
  • caregiver_id (Field4)
  • endtime (Field6) — NOT NULL
  • storetime (Field7) — NOT NULL
  • value (Field9)
  • valueuom (Field10)
  • location (Field11)
  • locationcategory (Field12)
  • orderid (Field13)
  • linkorderid (Field14)
  • ordercategoryname (Field15)
  • ordercategorydescription (Field16)
  • patientweight (Field17)
  • isopenbag (Field18)
  • continueinnextdept (Field19)
  • statusdescription (Field20)
  • ORIGINALAMOUNT (Field21)
  • ORIGINALRATE (Field22)
  • subject_id (Key) — Foreign key → patients.csv.subject_id — NOT NULL
  • hadm_id (Key2) — Foreign key → admissions.csv.hadm_id — NOT NULL
  • itemid (Key3) — Foreign key → d_items.csv.itemid — NOT NULL
  • stay_id (Key5) — Foreign key → icustays.csv.stay_id — NOT NULL

procedures_icd.csv (진단 코드와 순서 기록)

  • seq_num (Key3) — Primary key — NOT NULL
  • hadm_id (Key4) — Primary key — NOT NULL
  • icd_code (Key5) — Primary key — NOT NULL
  • icd_version (Key6) — Primary key — NOT NULL
  • hadm_id (Key) — Foreign key → admissions.csv.hadm_id — NOT NULL
  • chartdate (Field4) — NOT NULL
  • subject_id (Key2) — Foreign key → patients.csv.subject_id — NOT NULL

provider.csv (의료진 입력 데이터 추적)

  • provider_id (Key) — Primary key — NOT NULL

services.csv (입원 서비스 전환 데이터)

  • transfertime (Key3) — Primary key — NOT NULL
  • hadm_id (Key4) — Primary key — NOT NULL
  • curr_service (Key5) — Primary key — NOT NULL
  • hadm_id (Key2) — Foreign key → admissions.csv.hadm_id — NOT NULL
  • prev_service (Field4)
  • curr_service (Field5)
  • subject_id (Key) — Foreign key → patients.csv.subject_id — NOT NULL

transfers.csv (입원 및 퇴원 추적 기록)

  • transfer_id (Key) — Primary key — NOT NULL
  • hadm_id (Field2)
  • eventtype (Field4)
  • careunit (Field5)
  • intime (Field6)
  • outtime (Field7)
  • subject_id (Key2) — Foreign key → patients.csv.subject_id — NOT NULL