mimic
Tables (31)
hosp_admissions
- hadm_id (입원-id) — INTEGER — Primary key — NOT NULL
- subject_id (환자-id) — INTEGER — Foreign key → hosp_patients.subject_id — NOT NULL
- admittime (입원시각) — TIMESTAMP — NOT NULL
- dischtime (퇴원시각) — TIMESTAMP
- deathtime (사망시각) — TIMESTAMP
- admission_type (입원유형) — VARCHAR(40) — NOT NULL
- admit_provider_id (입원담당-id) — VARCHAR(10)
- admission_location (입원위치) — VARCHAR(60)
- discharge_location (퇴원위치) — VARCHAR(60)
- insurance (보험유형) — VARCHAR(255)
- language (언어) — VARCHAR(25)
- marital_status (혼인상태) — VARCHAR(30)
- race (인종) — VARCHAR(80)
- edregtime (응급실등록시각) — TIMESTAMP
- edouttime (응급실퇴실시각) — TIMESTAMP
- hospital_expire_flag (병원사망여부) — SMALLINT
hosp_d_hcpcs
- code (HCPCS-코드) — CHAR(5) — Primary key — NOT NULL
- category (카테고리) — SMALLINT
- long_description (전체-설명) — TEXT
- short_description (약어-설명) — VARCHAR(180)
hosp_d_icd_diagnoses
- icd_code (ICD코드) — CHAR(7) — Primary key — NOT NULL
- icd_version (ICD 버전) — SMALLINT — Primary key — NOT NULL
- long_title (진단명) — VARCHAR(255)
hosp_d_icd_procedures
- icd_code (ICD-코드) — CHAR(7) — Primary key — NOT NULL
- icd_version (ICD-버전) — SMALLINT — Primary key — NOT NULL
- long_title (전체-명칭) — VARCHAR(222)
hosp_d_labitems
- itemid (검사항목-id) — INTEGER — Primary key — NOT NULL
- label (검사명) — VARCHAR(50)
- fluid (검체유형) — VARCHAR(50)
- category (검사분류) — VARCHAR(50)
hosp_diagnoses_icd
- seq_num (순서번호) — INTEGER — Primary key — NOT NULL
- hadm_id (입원-id) — INTEGER — Foreign key → hosp_admissions.hadm_id — NOT NULL
- subject_id (환자-id) — INTEGER — Foreign key → hosp_patients.subject_id — NOT NULL
- icd_code (ICD코드) — CHAR(7)
- icd_version (ICD버전) — SMALLINT
hosp_drgcodes
- subject_id (환자-id) — INTEGER — Foreign key → hosp_patients.subject_id — NOT NULL
- hadm_id (입원-id) — INTEGER — Foreign key → hosp_admissions.hadm_id — NOT NULL
- drg_type (DRG -유형) — VARCHAR(4)
- drg_code (DRG-코드) — VARCHAR(10) — NOT NULL
- description (상세설명) — VARCHAR(195)
- drg_severity (질병-중증도) — SMALLINT
- drg_mortality (사망-위험도) — SMALLINT
hosp_emar
- emar_id (EMAR 기록 ID) — VARCHAR(25) — Primary key — NOT NULL
- subject_id (환자 ID) — INTEGER — Foreign key → hosp_patients.subject_id — NOT NULL
- hadm_id (입원 ID) — INTEGER — Foreign key → hosp_admissions.hadm_id
- emar_seq (EMAR 순번) — INTEGER — NOT NULL
- poe_id (처방 입력 ID) — VARCHAR(25) — NOT NULL
- pharmacy_id (약국 ID) — INTEGER
- enter_provider_id (기록 입력 의료진 ID) — VARCHAR(10)
- charttime (투약 기록 시각) — TIMESTAMP — NOT NULL
- medication (약물 이름) — TEXT
- event_txt (투약 이벤트 상태) — VARCHAR(100)
- scheduletime (예정 투약 시각) — TIMESTAMP
- storetime (시스템 저장 시각) — TIMESTAMP — NOT NULL
hosp_emar_detail
- subject_id (환자-id) — INTEGER — Foreign key → hosp_patients.subject_id — NOT NULL
- emar_id — VARCHAR(25) — Foreign key → hosp_emar.emar_id — NOT NULL
- emar_seq (투약-순번) — INTEGER — NOT NULL
- parent_field_ordinal (상위항목-순서) — VARCHAR(10)
- administration_type (투여-유형) — VARCHAR(50)
- pharmacy_id (조제-id) — INTEGER
- barcode_type (바코드-종류) — VARCHAR(4)
- reason_for_no_barcode (바코드미사용-사유) — TEXT
- complete_dose_not_given (미투약-여부) — VARCHAR(5)
- dose_due (예정-용량) — VARCHAR(100)
- dose_due_unit (예정용량-단위) — VARCHAR(50)
- dose_given (실제-투여량) — VARCHAR(255)
- dose_given_unit (투여량-단위) — VARCHAR(50)
- will_remainder_of_dose_be_given (잔량-투여여부) — VARCHAR(5)
- product_amount_given (제품-투여량) — VARCHAR(30)
- product_unit (제품-단위) — VARCHAR(30)
- product_code (제품-코드) — VARCHAR(30)
- product_description (제품-설명) — VARCHAR(255)
- product_description_other (기타-제품설명) — VARCHAR(255)
- prior_infusion_rate (이전-주입속도) — VARCHAR(40)
- infusion_rate (주입-속도) — VARCHAR(40)
- infusion_rate_adjustment (주입속도-조정) — VARCHAR(50)
- infusion_rate_adjustment_amount (주입속도-조정량) — VARCHAR(30)
- infusion_rate_unit (주입속도-단위) — VARCHAR(30)
- route (투여-경로) — VARCHAR(10)
- infusion_complete (주입-완료여부) — VARCHAR(1)
- completion_interval (완료-간격) — VARCHAR(50)
- new_iv_bag_hung (새수액-교체여부) — VARCHAR(1)
- continued_infusion_in_other_location (타장소-지속여부) — VARCHAR(1)
- restart_interval (재시작-간격) — VARCHAR(2305)
- side (투여-측면) — VARCHAR(10)
- site (투여-부위) — VARCHAR(255)
- non_formulary_visual_verification (비원내처방-육안확인) — VARCHAR(1)
hosp_hcpcsevents
- seq_num (순번) — INTEGER — Primary key — NOT NULL
- hadm_id (입원-id) — INTEGER — Foreign key → hosp_admissions.hadm_id — NOT NULL
- hcpcs_cd (HCPCS 코드) — CHAR(5) — Foreign key → hosp_d_hcpcs.code — NOT NULL
- subject_id (환자 ID) — INTEGER — Foreign key → hosp_patients.subject_id — NOT NULL
- chartdate (기록 날짜) — DATE
- short_description (HCPCS 코드 간단 설명) — VARCHAR(180)
hosp_labevents
- labevent_id (검사이벤트-id) — INTEGER — Primary key — NOT NULL
- subject_id (환자-id) — INTEGER — Foreign key → hosp_patients.subject_id — NOT NULL
- hadm_id (입원-id) — INTEGER
- specimen_id (검체-id) — INTEGER — NOT NULL
- itemid (검사항목-id) — INTEGER — Foreign key → hosp_d_labitems.itemid — NOT NULL
- order_provider_id (처방의-id) — VARCHAR(10)
- charttime (검사기록시각) — TIMESTAMP(0)
- storetime (저장시각) — TIMESTAMP(0)
- value (검사결과값) — VARCHAR(200)
- valuenum (검사수치값) — DOUBLE
- valueuom (결과단위) — VARCHAR(20)
- ref_range_lower (참고범위하한) — DOUBLE
- ref_range_upper (참고범위상한) — DOUBLE
- flag (이상여부) — VARCHAR(10)
- priority (우선순위) — VARCHAR(7)
- comments (비고) — TEXT
hosp_microbiologyevents
- microevent_id (미생물 검사 ID) — INTEGER — Primary key — NOT NULL
- subject_id (환자 ID) — INTEGER — Foreign key → hosp_patients.subject_id — NOT NULL
- hadm_id (입원 ID) — INTEGER — Foreign key → hosp_admissions.hadm_id
- micro_specimen_id (검체 ID) — INTEGER — NOT NULL
- order_provider_id (검사 처방 의사 ID) — VARCHAR(10)
- chartdate (기록 날짜) — TIMESTAMP(0) — NOT NULL
- charttime (기록 시간) — TIMESTAMP(0)
- spec_itemid (검체 항목 코드) — INTEGER — NOT NULL
- spec_type_desc (검체 종류 설명) — VARCHAR(100) — NOT NULL
- test_seq (검사 순서) — INTEGER — NOT NULL
- storedate (저장 날짜) — TIMESTAMP(0)
- storetime (저장 시간) — TIMESTAMP(0)
- test_itemid (검사 항목 ID) — INTEGER
- test_name (검사 이름) — VARCHAR(100)
- org_itemid (균 ID) — INTEGER
- org_name (균 이름) — VARCHAR(100)
- isolate_num (분리된 균 번호) — SMALLINT
- quantity (균 양) — VARCHAR(50)
- ab_itemid (항생제 ID) — INTEGER
- ab_name (항생제 이름) — VARCHAR(30)
- dilution_text (희석 설명) — VARCHAR(10)
- dilution_comparison (비교 연산자) — VARCHAR(20)
- dilution_value (희석 값) — DOUBLE
- interpretation (해석) — VARCHAR(5)
- comments (추가 코멘트) — TEXT
hosp_omr
- subject_id (환자 ID) — INTEGER — NOT NULL
- chartdate (측정 날짜) — DATE — NOT NULL
- seq_num (순번) — INTEGER — NOT NULL
- result_name (측정 항목 이름) — VARCHAR(100) — NOT NULL
- result_value (측정 값) — TEXT — NOT NULL
hosp_patients
- subject_id (환자-id) — INTEGER — Primary key — NOT NULL
- gender (성별) — CHAR(1) — NOT NULL
- anchor_age (기준나이) — SMALLINT
- anchor_year (기준연도) — SMALLINT — NOT NULL
- anchor_year_group (기준연도구간) — VARCHAR(20) — NOT NULL
- dod (사망일) — DATE
hosp_pharmacy
- pharmacy_id (조제-id) — INTEGER — Primary key — NOT NULL
- subject_id (환자-id) — INTEGER — Foreign key → hosp_patients.subject_id — NOT NULL
- hadm_id (입원-id) — INTEGER — Foreign key → hosp_admissions.hadm_id — NOT NULL
- poe_id (처방입력-id) — VARCHAR(25)
- starttime (투약시작예정시간) — TIMESTAMP(3)
- stoptime (투약종료예정시간) — TIMESTAMP(3)
- medication (약물명) — TEXT
- proc_type (처리 유형) — VARCHAR(50) — NOT NULL
- status (상태) — VARCHAR(50)
- entertime (입력 시각) — TIMESTAMP(3) — NOT NULL
- verifiedtime (검수 시각) — TIMESTAMP(3)
- route (투여 경로) — VARCHAR(50)
- frequency (투여 횟수) — VARCHAR(50)
- disp_sched (조제 일정) — VARCHAR(255)
- infusion_type (주입 유형) — VARCHAR(15)
- sliding_scale (슬라이딩 스케일) — VARCHAR(1)
- lockout_interval (차단 간격) — VARCHAR(50)
- basal_rate (기저 주입 속도) — REAL
- one_hr_max (시간당 최대 용량) — VARCHAR(10)
- doses_per_24_hrs (24시간당 투여 횟수) — REAL
- duration (투약 기간) — REAL
- duration_interval (기간 단위) — VARCHAR(50)
- expiration_value (유효 기간 수치) — INTEGER
- expiration_unit (유효 기간 단위) — VARCHAR(50)
- expirationdate (만료 날짜) — TIMESTAMP(3)
- dispensation (조제 방식) — VARCHAR(50)
- fill_quantity (조제 수량) — VARCHAR(50)
hosp_poe
- poe_id (처방 입력-id) — VARCHAR(25) — Primary key — NOT NULL
- field_name (필드 이름) — VARCHAR(255) — Foreign key → hosp_poe_detail.field_name — NOT NULL
- poe_id (처방입력-id2) — VARCHAR(25) — Foreign key → hosp_poe_detail.poe_id — NOT NULL
- ordertime (처방 일시) — TIMESTAMP(0) — NOT NULL
- poe_seq (처방 순번) — INTEGER — NOT NULL
- subject_id (환자-id) — INTEGER — Foreign key → hosp_patients.subject_id — NOT NULL
- hadm_id (입원-id) — INTEGER — Foreign key → hosp_admissions.hadm_id
- order_type (처방 유형) — VARCHAR(25) — NOT NULL
- order_subtype (처방 하위 유형) — VARCHAR(50)
- transaction_type (트랜잭션 종류) — VARCHAR(15)
- discontinue_of_poe_id (중단된 처방-id) — VARCHAR(25)
- discontinued_by_poe_id (중단시킨 처방-id) — VARCHAR(25)
- order_provider_id (처방의-id) — VARCHAR(10)
- order_status (처방 현재 진행 상태) — VARCHAR(15)
hosp_poe_detail
- field_name (필드 이름) — VARCHAR(255) — Primary key — NOT NULL
- poe_id (처방 입력-id) — VARCHAR(25) — Foreign key → hosp_poe.poe_id — NOT NULL
- field_name (필드이름2) — VARCHAR(255) — Foreign key → hosp_poe.field_name — NOT NULL
- poe_id (처방입력-id2) — VARCHAR(25) — Foreign key → hosp_poe.poe_id — NOT NULL
- poe_seq (처방 순번) — INTEGER — NOT NULL
- subject_id (환자-id) — INTEGER — Foreign key → hosp_patients.subject_id — NOT NULL
- field_value (필드 값) — TEXT
hosp_prescriptions
- pharmacy_id (약제-id) — INTEGER — Primary key — NOT NULL
- drug_type (약물유형) — VARCHAR(20) — Primary key — NOT NULL
- drug (약물명) — VARCHAR(255) — Primary key — NOT NULL
- subject_id (환자-id) — INTEGER — Foreign key → hosp_patients.subject_id — NOT NULL
- hadm_id (입원-id) — INTEGER — Foreign key → hosp_admissions.hadm_id — NOT NULL
- poe_id (주문-id) — VARCHAR(25)
- poe_seq (주문순번) — INTEGER
- order_provider_id (처방의-id) — VARCHAR(10)
- starttime (처방시작시각) — TIMESTAMP(3)
- stoptime (처방종료시각) — TIMESTAMP(3)
- formulary_drug_cd (약품코드) — VARCHAR(50)
- gsn (GSN코드) — VARCHAR(255)
- ndc (ndc코드) — VARCHAR(25)
- prod_strength (약물강도) — VARCHAR(255)
- form_rx (처방형태) — VARCHAR(25)
- dose_val_rx (처방용량값) — VARCHAR(100)
- dose_unit_rx (처방용량단위) — VARCHAR(50)
- form_val_disp (조제형태값) — VARCHAR(50)
- form_unit_disp (조제형태단위) — VARCHAR(50)
- doses_per_24_hrs (24시간당투여횟수) — REAL
- route (투여경로) — VARCHAR(50)
hosp_procedures_icd
- seq_num (순번) — INTEGER — Primary key — NOT NULL
- hadm_id (입원 ID) — INTEGER — Foreign key → hosp_admissions.hadm_id — NOT NULL
- subject_id (환자 ID) — INTEGER — Foreign key → hosp_patients.subject_id — NOT NULL
- chartdate (시술 기록 날짜) — DATE — NOT NULL
- icd_code (ICD 시술 코드) — VARCHAR(7)
- icd_version (ICD 버전) — SMALLINT
hosp_provider
- provider_id (의료진-id) — VARCHAR(10) — NOT NULL
hosp_services
- transfertime (서비스 변경 시각) — TIMESTAMP — Primary key — NOT NULL
- hadm_id (입원-id) — INTEGER — Foreign key → hosp_admissions.hadm_id — NOT NULL
- subject_id (환자-id) — INTEGER — Foreign key → hosp_patients.subject_id — NOT NULL
- prev_service (이전 진료과) — VARCHAR(10)
- curr_service (현재 진료과) — VARCHAR(10)
hosp_transfers
- transfer_id (이동-id) — INTEGER — Primary key — NOT NULL
- hadm_id (입원-id2) — INTEGER — Foreign key → hosp_admissions.hadm_id — NOT NULL
- subject_id (환자-id) — INTEGER — Foreign key → hosp_patients.subject_id — NOT NULL
- hadm_id (입원-id) — INTEGER
- eventtype (이벤트유형) — VARCHAR(10)
- careunit (진료구역) — VARCHAR(255)
- intime (이동시작시각) — TIMESTAMP
- outtime (이동종료시각) — TIMESTAMP
icu_caregiver
- caregiver_id (기록한 의료진 ID) — INTEGER — NOT NULL
icu_chartevents
- subject_id (환자-id) — INTEGER — Foreign key → hosp_patients.subject_id — NOT NULL
- hadm_id (입원-id) — INTEGER — Foreign key → hosp_admissions.hadm_id — NOT NULL
- stay_id (중환자실체류-id) — INTEGER — Foreign key → icu_icustays.stay_id — NOT NULL
- caregiver_id (의료진-id) — INTEGER
- charttime (기록시각) — TIMESTAMP — NOT NULL
- storetime (저장시각) — TIMESTAMP
- itemid (항목-id) — INTEGER — Foreign key → icu_d_items.itemid — NOT NULL
- value (기록값) — VARCHAR(200)
- valuenum (수치값) — FLOAT
- valueuom (값단위) — VARCHAR(20)
- warning (경고여부) — SMALLINT
icu_d_items
- itemid (항목 ID) — INTEGER — Primary key — NOT NULL
- label (항목 이름) — VARCHAR(100) — NOT NULL
- abbreviation (약어) — VARCHAR(50) — NOT NULL
- linksto (연결된 테이블 이름) — VARCHAR(30) — NOT NULL
- category (카테고리) — VARCHAR(50) — NOT NULL
- unitname (단위 이름) — VARCHAR(50)
- param_type (값 타입) — VARCHAR(20) — NOT NULL
- lownormalvalue (정상 범위 하한) — FLOAT
- highnormalvalue (정상 범위 상한) — FLOAT
icu_datetimeevents
- charttime (발생 시각) — TIMESTAMP — Primary key — NOT NULL
- stay_id (중환자실체류-id) — INTEGER — Foreign key → icu_icustays.stay_id — NOT NULL
- itemid (항목 ID) — INTEGER — Foreign key → icu_d_items.itemid — NOT NULL
- subject_id (환자 ID) — INTEGER — Foreign key → hosp_patients.subject_id — NOT NULL
- hadm_id (입원 ID) — INTEGER — Foreign key → hosp_admissions.hadm_id — NOT NULL
- caregiver_id (기록한 의료진 ID) — INTEGER
- storetime (시스템 저장 시각) — TIMESTAMP
- value (기록된 날짜/시간) — TIMESTAMP — NOT NULL
- valueuom (값의 단위) — VARCHAR(20)
- warning (경고 플래그) — SMALLINT
icu_icustays
- stay_id (중환자실체류-id) — INTEGER — Primary key — NOT NULL
- subject_id (환자-id) — INTEGER — Foreign key → hosp_patients.subject_id — NOT NULL
- hadm_id (입원-id) — INTEGER — Foreign key → hosp_admissions.hadm_id — NOT NULL
- first_careunit (최초중환자실병동) — VARCHAR(255)
- last_careunit (최종중환자실병동) — VARCHAR(255)
- intime (입실시각) — TIMESTAMP
- outtime (퇴실시각) — TIMESTAMP
- los (재실기간) — FLOAT
icu_ingredientevents
- subject_id (환자 -id) — INTEGER — NOT NULL
- hadm_id (입원 ID) — INTEGER — NOT NULL
- stay_id (ICU 입실 ID) — INTEGER
- caregiver_id (의료진 ID) — INTEGER
- starttime (투여 시작 시간) — TIMESTAMP — NOT NULL
- endtime (투여 종료 시간) — TIMESTAMP — NOT NULL
- storetime (기록 저장 시간) — TIMESTAMP
- itemid (약물/성분 코드) — INTEGER — NOT NULL
- amount (투여량) — FLOAT
- amountuom (투여량 단위) — VARCHAR(20)
- rate (투여 속도) — FLOAT
- rateuom (속도 단위) — VARCHAR(20)
- orderid (처방 ID) — INTEGER — NOT NULL
- linkorderid (연결된 처방 ID) — INTEGER
- statusdescription (상태 설명) — VARCHAR(20)
- originalamount (원래 투여량) — FLOAT
- originalrate (원래 투여 속도) — FLOAT
icu_inputevents
- orderid (처방-id) — INTEGER — Primary key — NOT NULL
- itemid (항목코드) — INTEGER — Foreign key → icu_d_items.itemid — NOT NULL
- subject_id (환자-id) — INTEGER — Foreign key → hosp_patients.subject_id — NOT NULL
- hadm_id (입원-id) — INTEGER — Foreign key → hosp_admissions.hadm_id — NOT NULL
- stay_id (중환자실체류-id) — INTEGER — Foreign key → icu_icustays.stay_id
- caregiver_id (의료진-id) — INTEGER
- starttime (투여시작시간) — TIMESTAMP — NOT NULL
- endtime (투여종료시간) — TIMESTAMP — NOT NULL
- storetime (저장시간) — TIMESTAMP
- amount (실제 투여량) — FLOAT
- amountuom (투여량 단위) — VARCHAR(20)
- rate (주입 속도) — FLOAT
- rateuom (주입 속도 단위) — VARCHAR(20)
- linkorderid (연결 처방-id) — INTEGER
- ordercategoryname (처방 분류) — VARCHAR(50)
- secondaryordercategoryname (처방 부분류) — VARCHAR(50)
- ordercomponenttypedescription (성분 구성 유형) — VARCHAR(100)
- ordercategorydescription (투여 방식 설명) — VARCHAR(30)
- patientweight (환자 체중) — FLOAT
- totalamount (전체 조제량) — FLOAT
- totalamountuom (전체 조제량 단위) — VARCHAR(50)
- isopenbag (투여 진행 여부) — SMALLINT
- continueinnextdept (병동 이동 시 지속 여부) — SMALLINT
- statusdescription (상태 설명) — VARCHAR(20)
- originalamount (초기 처방량) — FLOAT
- originalrate (초기 처방 속도) — FLOAT
icu_outputevents
- charttime (기록 시간) — TIMESTAMP(3) — Primary key — NOT NULL
- stay_id (중환자실 체류-id) — INTEGER — Foreign key → icu_icustays.stay_id — NOT NULL
- itemid (항목코드) — INTEGER — Foreign key → icu_d_items.itemid — NOT NULL
- subject_id (환자-id) — INTEGER — Foreign key → hosp_patients.subject_id — NOT NULL
- hadm_id (입원-id) — INTEGER — Foreign key → hosp_admissions.hadm_id — NOT NULL
- caregiver_id (의료진-id) — INTEGER
- storetime (저장시간) — TIMESTAMP(3) — NOT NULL
- value (시간값) — FLOAT — NOT NULL
- valueuom (시간단위) — VARCHAR(20)
icu_procedureevents
- subject_id (환자-id) — INTEGER — Foreign key → hosp_patients.subject_id — NOT NULL
- hadm_id (입원-id) — INTEGER — Foreign key → hosp_admissions.hadm_id — NOT NULL
- stay_id (중환자실체류-id) — INTEGER — Foreign key → icu_icustays.stay_id — NOT NULL
- caregiver_id (의료진-id) — INTEGER
- starttime (시술 시작 시간) — TIMESTAMP — NOT NULL
- endtime (시술 종료 시간) — TIMESTAMP — NOT NULL
- storetime (저장 시간) — TIMESTAMP — NOT NULL
- itemid (항목 코드) — INTEGER — Foreign key → icu_d_items.itemid — NOT NULL
- value (수치) — FLOAT
- valueuom (수치 단위) — VARCHAR(20)
- location (시술 위치) — VARCHAR(100)
- locationcategory (시술 위치 분류) — VARCHAR(50)
- orderid (처방-id) — INTEGER
- linkorderid (연결 처방-id) — INTEGER
- ordercategoryname (처방 범주명) — VARCHAR(50)
- ordercategorydescription (처방 방식 설명) — VARCHAR(30)
- patientweight (환자 체중) — FLOAT
- isopenbag (진행 여부) — SMALLINT
- continueinnextdept (병동 이동 시 지속) — SMALLINT
- statusdescription (진행 상태 설명) — VARCHAR(20)
- originalamount (초기 계획량) — FLOAT
- originalrate (초기 설정 속도) — FLOAT