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