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