데이터베이스 과제 2주차

테이블 (31)

admission (h-01)

  • hadm (병원입원ID) — INT NOT NULL — 기본 키
  • suject_id (환자ID) — INT NOT NULL
  • admittime (입원시간) — TIMESTAMP NOT NULL
  • Field4 (퇴원시간) — TIMESTAMP
  • dischtime (사망시간) — TIMESTAMP
  • deathtime (입원유형) — VARCHAR(40) NOT NULL
  • admission_type (보호자ID) — VARCHAR(10)
  • admit_provider_id (입원위치) — VARCHAR(60)
  • admission_location (퇴원위치) — VARCHAR(60)
  • discharge_location (보험종류) — VARCHAR(60)
  • insurance (환자사용언어) — VARCHAR(255)
  • language (결혼여부) — VARCHAR(10)
  • marital_status (인종) — VARCHAR(30)
  • race (응급실등록시간) — VARCHAR(80)
  • edregtime (응급실퇴원시간) — TIMESTAMP
  • edouttime (사망자예측) — TIMESTAMP
  • hadm_id (병원입원ID2) — INT NOT NULL — 외래 키 → diagnoses_icd.hadm_id
  • seq_num (진단에할당된우선순위) — INT NOT NULL — 외래 키 → diagnoses_icd.seq_num
  • icd_code (ICD코드) — CHAR(7) — 외래 키 → diagnoses_icd.icd_code
  • icd_version (ICD코드버전) — SMALLINT — 외래 키 → diagnoses_icd.icd_version
  • emar_id (EMAR고유ID) — VARCHAR(25) NOT NULL — 외래 키 → emar.emar_id
  • hadm_id (병원입원ID3) — INT NOT NULL — 외래 키 → hcpcsevents.hadm_id
  • hcpcs_cd (사건고유코드) — CHAR(5) NOT NULL — 외래 키 → hcpcsevents.hcpcs_cd
  • seq_num (진단에할당된우선순위2) — INT NOT NULL — 외래 키 → hcpcsevents.seq_num
  • microevent_id (미생물학적검사ID) — INT NOT NULL — 외래 키 → microbiologyevents.microevent_id
  • subject_id (환자ID2) — INT NOT NULL — 외래 키 → patients.subject_id
  • poe_id (의사의뢰입력ID) — VARCHAR(25) NOT NULL — 외래 키 → poe.poe_id
  • pharmacy_id (약국정보ID) — INT NOT NULL — 외래 키 → prescriptions.pharmacy_id — NOT NULL
  • drug_type (처방전의성분) — VARCHAR(20) NOT NULL — 외래 키 → prescriptions.drug_type — NOT NULL
  • drug (투여된약물) — VARCHAR(255) NOT NULL — 외래 키 → prescriptions.drug — NOT NULL
  • seq_num (진단에할당된우선순위3) — INT NOT NULL — 외래 키 → procedures_icd.seq_num
  • subject_id (환자ID3) — INT NOT NULL — 외래 키 → procedures_icd.subject_id
  • icd_code (ICD(국제코딩정의)코드) — VARCHAR(7) — 외래 키 → procedures_icd.icd_code
  • icd_version (ICD코드버전2) — SMALLINT — 외래 키 → procedures_icd.icd_version
  • hadm_id (병원입원ID4) — INT NOT NULL — 외래 키 → services.hadm_id
  • transfertime (SERVICE로이동한시간) — TIMESTAMP NOT NULL — 외래 키 → services.transfertime
  • curr_service (환자가현재상주하는서비스) — VARCHAR(10) — 외래 키 → services.curr_service
  • subject_id (환자ID4) — INT NOT NULL — 외래 키 → datetimeevents.subject_id
  • itemid (단일측정유형에대한식별자) — INT NOT NULL — 외래 키 → datetimeevents.itemid
  • charttime (약투여시간) — TIMESTAMP NOT NULL — 외래 키 → datetimeevents.charttime
  • subject_id (환자ID5) — INT NOT NULL — 외래 키 → icustays.subject_id
  • itemid (단일측정유형식별자ID) — INT NOT NULL — 외래 키 → inputevents.itemid
  • orderid (주문ID) — INT NOT NULL — 외래 키 → inputevents.orderid
  • stay_id (병동ID) — INT NOT NULL — 외래 키 → outputevents.stay_id
  • charttime (약투여시간2) — TIMESTAMP(3) NOT NULL — 외래 키 → outputevents.charttime
  • itemid (단일측정유형에대한식별자ID) — INT NOT NULL — 외래 키 → outputevents.itemid
  • orderid (주문ID2) — INT — 외래 키 → procedureevents.orderid

caregiver (i-01)

  • caregiver_id (간병인ID) — INT NOT NULL

chartevents (i-02)

  • subject_id (환자ID) — INT NOT NULL
  • hadm_id (병원입원ID) — INT NOT NULL
  • stay_id (병동ID) — INT NOT NULL
  • caregiver_id (간병인ID) — INT
  • charttime (약투여시간) — TIMESTAMP
  • storetime (수동검증시간) — TIMESTAMP
  • itemid (단일측정유형에대한식별자ID) — INT NOT NULL
  • value (값) — VARCHAR(200)
  • valuenum (값번호) — FLOAT
  • valueuom (값의측정단위) — VARCHAR(20)
  • warning (관찰경고여부) — SMALLINT
  • subject_id (환자ID2) — INT NOT NULL — 외래 키 → patients.subject_id
  • hadm (병원입원ID2) — INT NOT NULL — 외래 키 → admission.hadm
  • subject_id (환자ID3) — INT NOT NULL — 외래 키 → icustays.subject_id
  • itemid (단일측정유형에대한식별자ID2) — INT NOT NULL — 외래 키 → d_items.itemid — NOT NULL

d_hcpcs (h-02)

  • code (코드) — CHAR(5) NOT NULL — 기본 키
  • category (측정유형정보) — SMALLINT
  • long_description (상세설명) — TEXT
  • short_description (요약설명) — VARCHAR(180)
  • hadm_id (병원입원ID) — INT NOT NULL — 외래 키 → hcpcsevents.hadm_id
  • hcpcs_cd (사건고유코드) — CHAR(5) NOT NULL — 외래 키 → hcpcsevents.hcpcs_cd
  • seq_num (진단에할당된우선순위) — INT NOT NULL — 외래 키 → hcpcsevents.seq_num

d_icd_diagnoses (h-15)

  • icd_code (ICD(국제코딩정의)코드) — CHAR(7) NOT NULL — 기본 키
  • icd_version (ICD코드버전) — SMALLINT NOT NULL — 기본 키
  • long_title (ICD코드정의) — VARCHAR(255)

d_icd_procedures (h-16)

  • icd_code (ICD코드) — CHAR(7) NOT NULL — 기본 키
  • icd_version (ICD코드버전) — SMALLINT NOT NULL — 기본 키
  • long_title (ICD코드정의) — VARCHAR(222)

d_items (i-04)

  • itemid (단일측정유형에대한식별자ID) — INT NOT NULL — 기본 키 — NOT NULL
  • label (ITEMID개념설명) — VARCHAR(100) NOT NULL
  • abbreviation (LABEL약어) — VARCHAR(50) NOT NULL
  • linksto (연결테이블이름) — VARCHAR(30) NOT NULL
  • category (측정유형정보) — VARCHAR(50) NOT NULL
  • unitname (ITEMID의측정단위) — VARCHAR(50)
  • param_type (기록되는데이터유형) — VARCHAR(20) NOT NULL
  • lownormalvalue (낮은측정기준점) — FLOAT
  • highnormalvalue (높은측정기준점) — FLOAT
  • subject_id (환자ID) — INT NOT NULL — 외래 키 → datetimeevents.subject_id
  • itemid (단일측정유형에대한식별자2) — INT NOT NULL — 외래 키 → datetimeevents.itemid
  • charttime (약투여시간) — TIMESTAMP NOT NULL — 외래 키 → datetimeevents.charttime
  • itemid (단일측정유형식별자ID) — INT NOT NULL — 외래 키 → inputevents.itemid
  • orderid (주문ID) — INT NOT NULL — 외래 키 → inputevents.orderid
  • stay_id (병동ID) — INT NOT NULL — 외래 키 → outputevents.stay_id
  • charttime (약투여시간2) — TIMESTAMP(3) NOT NULL — 외래 키 → outputevents.charttime
  • itemid (단일측정유형에대한식별자ID2) — INT NOT NULL — 외래 키 → outputevents.itemid
  • orderid (주문ID2) — INT — 외래 키 → procedureevents.orderid

d_labitems (h-17)

  • itemid (실험실고유ID) — INT NOT NULL — 기본 키
  • label (ITEMID고유설명) — VARCHAR(50)
  • fluid (측정된물질) — VARCHAR(50)
  • category (측정유형정보) — VARCHAR(50)
  • labevent_id (임상시험식별ID) — INT NOT NULL — 외래 키 → labevents.labevent_id

datetimeevents (i-03)

  • subject_id (환자ID) — INT NOT NULL — 기본 키
  • itemid (단일측정유형에대한식별자) — INT NOT NULL — 기본 키
  • charttime (약투여시간) — TIMESTAMP NOT NULL — 기본 키
  • hadm_id (병원입원ID) — INT NOT NULL
  • stay_id (병동ID) — INT NOT NULL
  • caregiver_id (간병인ID) — INT
  • storetime (수동검증시간) — TIMESTAMP
  • value (값) — TIMESTAMP NOT NULL
  • valueuom (값의측정단위) — VARCHAR(20)
  • warning (관찰경고여부) — SMALLINT

diagnoses_icd (h-18)

  • hadm_id (병원입원ID) — INT NOT NULL — 기본 키
  • seq_num (진단에할당된우선순위) — INT NOT NULL — 기본 키
  • icd_code (ICD코드) — CHAR(7) — 기본 키
  • icd_version (ICD코드버전) — SMALLINT — 기본 키
  • subject_id (환자ID) — INT NOT NULL

drgcodes (h-19)

  • subject_id (환자ID) — INT NOT NULL
  • hadm_id (병원입원ID) — INT NOT NULL
  • drg_type (DRG코드유형) — VARCHAR(4)
  • drg_code (입원에대한청구진단관련그룹(DRG)코드) — VARCHAR(10) NOT NULL
  • description (DRG코드설명) — VARCHAR(195)
  • drg_severity (질병중증도평가) — SMALLINT
  • drg_mortality (사망가능성평가) — SMALLINT

emar (h-20)

  • emar_id (EMAR고유ID) — VARCHAR(25) NOT NULL — 기본 키
  • subject_id (환자ID) — INT NOT NULL
  • hadm_id (병원입원ID) — INT
  • emar_seq (시간순으로지정한연속정수) — INT NOT NULL
  • poe_id (의사의뢰입력ID) — VARCHAR(25) NOT NULL
  • pharmacy_id (약국정보ID) — INT
  • enter_provider_id (정보입력자익명ID) — VARCHAR(10)
  • charttime (약투여시간) — TIMESTAMP NOT NULL
  • medication (투여된약물이름) — TEXT
  • event_txt (관리정보) — VARCHAR(100)
  • scheduletime (약투여예정시간) — TIMESTAMP
  • storetime (수동검증시간) — TIMESTAMP NOT NULL
  • emar_id (EMAR고유ID2) — VARCHAR(25) NOT NULL — 외래 키 → emar_detail.emar_id
  • parent_field_ordinal (여러투여량설명) — VARCHAR(10) — 외래 키 → emar_detail.parent_field_ordinal

emar_detail (h-21)

  • emar_id (EMAR고유ID) — VARCHAR(25) NOT NULL — 기본 키
  • parent_field_ordinal (여러투여량설명) — VARCHAR(10) — 기본 키
  • subject_id (환자ID) — INT NOT NULL
  • emar_seq (시간순으로지정한연속정수) — INT NOT NULL
  • administation_type (투여종류) — VARCHAR(50)
  • pharmacy_id (약국정보ID) — INT
  • barcode_type (약물바코드유형) — VARCHAR(4)
  • reason_for_no_barcode (바코드없는이유) — TEXT
  • complete_dose_not_given (전체용량미제공) — VARCHAR(5)
  • does_due (용량기한) — VARCHAR(100)
  • does_due_unit (당량단위) — VARCHAR(50)
  • does_given (주어진복용량) — VARCHAR(255)
  • does_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 (새로운IV주입여부) — 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)

hcpcsevents (h-22)

  • hadm_id (병원입원ID) — INT NOT NULL — 기본 키
  • hcpcs_cd (사건고유코드) — CHAR(5) NOT NULL — 기본 키
  • seq_num (진단에할당된우선순위) — INT NOT NULL — 기본 키
  • subect_id (환자ID) — INT NOT NULL
  • chartdate (차트날짜) — DATE
  • short_description (요약설명) — VARCHAR(180)

icustays (i-05)

  • subject_id (환자ID) — INT NOT NULL — 기본 키
  • hadm_id (병원입원ID) — INT NOT NULL
  • stay_id (병동ID) — INT NOT NULL
  • first_careunit (첫번째ICUID) — VARCHAR(255)
  • last_careunit (마지막ICUID) — VARCHAR(255)
  • intime (중환자실이전시간) — TIMESTAMP
  • outtime (중환자실퇴원시간) — TIMESTAMP
  • los (환자의체류기간) — FLOAT
  • subject_id (환자ID2) — INT NOT NULL — 외래 키 → datetimeevents.subject_id
  • itemid (단일측정유형에대한식별자) — INT NOT NULL — 외래 키 → datetimeevents.itemid
  • charttime (약투여시간) — TIMESTAMP NOT NULL — 외래 키 → datetimeevents.charttime
  • itemid (단일측정유형식별자ID) — INT NOT NULL — 외래 키 → inputevents.itemid
  • orderid (주문ID) — INT NOT NULL — 외래 키 → inputevents.orderid
  • stay_id (병동ID2) — INT NOT NULL — 외래 키 → outputevents.stay_id
  • charttime (약투여시간2) — TIMESTAMP(3) NOT NULL — 외래 키 → outputevents.charttime
  • itemid (단일측정유형에대한식별자ID) — INT NOT NULL — 외래 키 → outputevents.itemid
  • orderid (주문ID2) — INT — 외래 키 → procedureevents.orderid

ingredientevents (i-06)

  • subject_id (환자ID) — INT NOT NULL
  • hadm_id (병원입원ID) — INT NOT NULL
  • stay_id (병동ID) — INT
  • caregiver_id (간병인ID) — INT
  • starttime (약물투약시작시간) — TIMESTAMP NOT NULL
  • endtime (약물투약종료시간) — TIMESTAMP NOT NULL
  • storetime (수동검증시간) — TIMESTAMP
  • itemid (단일측정유형에대한식별자ID) — INT NOT NULL
  • amount (약물투여량) — FLOAT
  • amountuom (약물투여단위) — VARCHAR(20)
  • rate (환자에게투여되는약물의시간당비율) — FLOAT
  • rateuom (환자에게투여되는약물의시간당비율의단위) — VARCHAR(20)
  • orderid (주문ID) — INT NOT NULL
  • linkorderid (동일한순서를연결) — INT
  • statusdescription (투여된의약품의현재상태설명) — VARCHAR(20)
  • originalamount (시작시간에봉지에들어있는화합물의양) — FLOAT
  • originalrate (진료자가입력한요금) — FLOAT

inputevents (i-07)

  • itemid (단일측정유형식별자ID) — INT NOT NULL — 기본 키
  • orderid (주문ID) — INT NOT NULL — 기본 키
  • subject_id (환자ID) — INT NOT NULL
  • hadm_id (병원입원ID) — INT NOT NULL
  • stay_id (병동ID) — INT
  • caregiver_id (간병인ID) — INT
  • starttime (약물투약시작시간) — TIMESTAMP NOT NULL
  • endtime (약물투약종료시간) — TIMESTAMP NOT NULL
  • storetime (수동검증시간) — TIMESTAMP
  • amount (약물투여량) — FLOAT
  • amountuom (약물투여단위) — VARCHAR(20)
  • rate (투여되는약물시간당비율) — FLOAT
  • rateuom (투여되는약물시간당비율단위) — VARCHAR(20)
  • linkorderid (동일한순서를연결) — INT
  • 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

labevents (h-03)

  • labevent_id (임상시험식별ID) — INT NOT NULL — 기본 키
  • subject_id (환자ID) — INT NOT NULL
  • adm_id (병원입원ID) — INT
  • specimen_id (생체샘플ID) — INT NOT NULL
  • itemid (실험실고유ID) — INT NOT NULL
  • order_provider_id (의사ID) — VARCHAR(10)
  • charttime (약투여시간) — TIMESTAMP(0)
  • storetime (수동검증시간) — TIMESTAMP(0)
  • value (값) — VARCHAR(200)
  • valuenum (값번호) — DOUBLE PRECISION
  • valueuom (값의측정단위) — VARCHAR(20)
  • ref_range_lower (정상수치하한값) — DOUBLE PRECISION
  • ref_range_upper (정상수치상한값) — DOUBLE PRECISION
  • flag (검사결과정상여부) — VARCHAR(10)
  • priority (검사결과우선순위) — VARCHAR(7)
  • comments (추가정보) — TEXT

microbiologyevents (h-04)

  • microevent_id (미생물학적검사ID) — INT NOT NULL — 기본 키
  • subject_id (환자ID) — INT NOT NULL
  • hadm_id (병원입원ID) — INT
  • micro_specimen_id (생체시료ID) — INT NOT NULL
  • order_provider_id (의사ID) — VARCHAR(10)
  • chartdate (차트날짜) — TIMESTAMP(0) NOT NULL
  • charttime (약투여시간) — TIMESTAMP(0)
  • spec_itemid (표본식별ID) — INT NOT NULL
  • spec_type_desc (표본에대한설명) — VARCHAR(100) NOT NULL
  • test_seq (미생물학적테스트순차적결과) — INT
  • storedate (DB에저장된날짜와시간) — TIMESTAMP(0)
  • storetime (수동검증시간) — TIMISTAMP(0)
  • test_itemid (미생물학적테스트식별ID) — INT
  • test_name (테스트이름) — VARCHAR(100)
  • org_itemid (미생물의종식별ID) — INT
  • org_name (유기체이름) — VARCHAR(100)
  • isolate_num (테스트와연관된번호구분) — SMALLINT
  • quantity (관찰되는미생물양) — VARCHAR(50)
  • ab_itemid (항체식별ID) — INT
  • ab_name (항체이름) — VARCHAR(30)
  • dilution_text (희석량비교) — VARCHAR(10)
  • dilution_comparison (희석량비교구성요소) — VARCHAR(20)
  • dilution_value (구성요소의값) — DOUBLE PRECIRION
  • interpretation (테스트해석) — VARCHAR(5)
  • comments (추가정보) — TEXT

omr (h-05)

  • subject_id (환자ID) — INT NOT NULL
  • chartdate (차트날짜) — DATE NOT NULL
  • seq_num (진단에할당된우선순위) — INT NOT NULL
  • result_name (검사결과이름) — VARCHAR(100) NOT NULL
  • result_value (검사결과) — TEXT NOT NULL

outputevents (i-08)

  • stay_id (병동ID) — INT NOT NULL — 기본 키
  • charttime (약투여시간) — TIMESTAMP(3) NOT NULL — 기본 키
  • itemid (단일측정유형에대한식별자ID) — INT NOT NULL — 기본 키
  • subject_id (환자ID) — INT NOT NULL
  • hadm_id (병원입원ID) — INT NOT NULL
  • caregiver_id (간병인ID) — INT
  • storetime (수동검증시간) — TIMESTAMP NOT NULL
  • value (값) — FLOAT NOT NULL
  • valueuom (값의측정단위) — VARCHAR(20)

patients (h-06)

  • subject_id (환자ID) — INT NOT NULL — 기본 키
  • gender (성별) — CHAR(1) NOT NULL
  • anchor_age (환자의연령) — SMALLINT
  • anchor_year (의료기록수집연도) — SMALLINT NOT NULL
  • anchor_year_group (연도별그룹) — VARCHAR(20) NOT NULL
  • dod (사망한날짜) — DATE
  • hadm (병원입원ID) — INT NOT NULL — 외래 키 → admission.hadm
  • hadm_id (병원입원ID2) — INT NOT NULL — 외래 키 → diagnoses_icd.hadm_id
  • seq_num (진단에할당된우선순위) — INT NOT NULL — 외래 키 → diagnoses_icd.seq_num
  • icd_code (ICD코드) — CHAR(7) — 외래 키 → diagnoses_icd.icd_code
  • icd_version (ICD코드버전) — SMALLINT — 외래 키 → diagnoses_icd.icd_version
  • emar_id (EMAR고유ID) — VARCHAR(25) NOT NULL — 외래 키 → emar_detail.emar_id
  • parent_field_ordinal (여러투여량설명) — VARCHAR(10) — 외래 키 → emar_detail.parent_field_ordinal
  • emar_id (EMAR고유ID2) — VARCHAR(25) NOT NULL — 외래 키 → emar.emar_id
  • hadm_id (병원입원ID3) — INT NOT NULL — 외래 키 → hcpcsevents.hadm_id
  • hcpcs_cd (사건고유코드) — CHAR(5) NOT NULL — 외래 키 → hcpcsevents.hcpcs_cd
  • seq_num (진단에할당된우선순위2) — INT NOT NULL — 외래 키 → hcpcsevents.seq_num
  • labevent_id (임상시험식별ID) — INT NOT NULL — 외래 키 → labevents.labevent_id
  • microevent_id (미생물학적검사ID) — INT NOT NULL — 외래 키 → microbiologyevents.microevent_id
  • pharmacy_id (약국정보ID) — INT NOT NULL — 외래 키 → pharmacy.pharmacy_id
  • poe_id (의사의뢰입력ID) — VARCHAR(25) NOT NULL — 외래 키 → poe_detail.poe_id — NOT NULL
  • field_name (POE순서특정세부정보) — VARCHAR(255) NOT NULL — 외래 키 → poe_detail.field_name — NOT NULL
  • poe_id (의사의뢰입력ID2) — VARCHAR(25) NOT NULL — 외래 키 → poe.poe_id
  • pharmacy_id (약국정보ID2) — INT NOT NULL — 외래 키 → prescriptions.pharmacy_id — NOT NULL
  • drug_type (처방전의성분) — VARCHAR(20) NOT NULL — 외래 키 → prescriptions.drug_type — NOT NULL
  • drug (투여된약물) — VARCHAR(255) NOT NULL — 외래 키 → prescriptions.drug — NOT NULL
  • seq_num (진단에할당된우선순위3) — INT NOT NULL — 외래 키 → procedures_icd.seq_num
  • subject_id (환자ID2) — INT NOT NULL — 외래 키 → procedures_icd.subject_id
  • icd_code (ICD(국제코딩정의)코드) — VARCHAR(7) — 외래 키 → procedures_icd.icd_code
  • icd_version (ICD코드버전2) — SMALLINT — 외래 키 → procedures_icd.icd_version
  • hadm_id (병원입원ID4) — INT NOT NULL — 외래 키 → services.hadm_id
  • transfertime (SERVICE로이동한시간) — TIMESTAMP NOT NULL — 외래 키 → services.transfertime
  • curr_service (환자가현재상주하는서비스) — VARCHAR(10) — 외래 키 → services.curr_service
  • subject_id (환자ID3) — INT NOT NULL — 외래 키 → datetimeevents.subject_id
  • itemid (단일측정유형에대한식별자) — INT NOT NULL — 외래 키 → datetimeevents.itemid
  • charttime (약투여시간) — TIMESTAMP NOT NULL — 외래 키 → datetimeevents.charttime
  • subject_id (환자ID4) — INT NOT NULL — 외래 키 → icustays.subject_id
  • itemid (단일측정유형식별자ID) — INT NOT NULL — 외래 키 → inputevents.itemid
  • orderid (주문ID) — INT NOT NULL — 외래 키 → inputevents.orderid
  • stay_id (병동ID) — INT NOT NULL — 외래 키 → outputevents.stay_id
  • charttime (약투여시간2) — TIMESTAMP(3) NOT NULL — 외래 키 → outputevents.charttime
  • itemid (단일측정유형에대한식별자ID) — INT NOT NULL — 외래 키 → outputevents.itemid
  • orderid (주문ID2) — INT — 외래 키 → procedureevents.orderid

pharmacy (h-07)

  • pharmacy_id (약국정보ID) — INT NOT NULL — 기본 키
  • subject_id (환자ID) — INT NOT NULL
  • hadm_id (병원입원ID) — INT 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 (24시투여되는약물속도) — REAL
  • one_hr_max (1시간동안투여할수있는최대용량) — VARCHAR(10)
  • doses_per_24_hrs (24시투여되는예상약물용량) — REAL
  • duration (약물복용기간) — REAL
  • duration_interval (의약품사용기간) — VARCHAR(50)
  • expiration_value (약물의유통기간) — INT
  • expiration_unit (유통기간의단위) — VARCHAR(50)
  • expirationdate (미확인된약물의유통기간) — TIMESTAMP(3)
  • dispensation (약물제공시기) — VARCHAR(50)
  • fill_quantity (약물의양) — VARCHAR(50)

poe (h-08)

  • poe_id (의사의뢰입력ID) — VARCHAR(25) NOT NULL — 기본 키
  • poe_seq (진료의일련번호) — INT NOT NULL
  • subject_id (환자ID) — INT NOT NULL
  • hadm_id (병원입원ID) — INT
  • ordertime (처방시간) — TIMESTAMP(0) NOT NULL
  • order_type (의료조치유형) — VARCHAR(25) NOT NULL
  • order_subtype (의료조치하위유형) — VARCHAR(50)
  • transaction_type (의료행위유형) — VARCHAR(15)
  • discontinue_of_poe-id (의료중단이유) — VARCHAR(25)
  • discontinued_by_poe_id (의사에의한중단식별자) — VARCHAR(25)
  • order_provider_id (의사ID) — VARCHAR(10)
  • order_status (현재상태) — VARCHAR(15)
  • poe_id (의사의뢰입력ID2) — VARCHAR(25) NOT NULL — 외래 키 → poe_detail.poe_id — NOT NULL
  • field_name (POE순서특정세부정보) — VARCHAR(255) NOT NULL — 외래 키 → poe_detail.field_name — NOT NULL

poe_detail (h-09)

  • poe_id (의사의뢰입력ID) — VARCHAR(25) NOT NULL — 기본 키 — NOT NULL
  • field_name (POE순서특정세부정보) — VARCHAR(255) NOT NULL — 기본 키 — NOT NULL
  • poe_seq (진료의일련번호) — INT NOT NULL
  • subject_id (환자ID) — INT NOT NULL
  • field_value (환자입원유형) — TEXT

prescriptions (h-10)

  • pharmacy_id (약국정보ID) — INT NOT NULL — 기본 키 — NOT NULL
  • drug_type (처방전의성분) — VARCHAR(20) NOT NULL — 기본 키 — NOT NULL
  • drug (투여된약물) — VARCHAR(255) NOT NULL — 기본 키 — NOT NULL
  • subject_id (환자ID) — INT NOT NULL
  • hadm_id (병원입원ID) — INT NOT NULL
  • poe_id (의사의뢰입력ID) — VARCHAR(25)
  • poe_seq (진료의일련번호) — INT
  • order_provider_id (의사ID) — VARCHAR(10)
  • starttime (약물투약시작시간) — TIMESTAMP(3)
  • stoptime (약물투약중지시간) — TIMESTAMP(3)
  • formulary_drug_cd (약물주문시사용되는병원별형태) — VARCHAR(50)
  • gsn (약물에사용되는암호화된식별자) — VARCHAR(255)
  • 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)

procedureevents (i-09)

  • orderid (주문ID) — INT — 기본 키
  • subject_id (환자ID) — INT NOT NULL
  • hadm_id (병원입원ID) — INT NOT NULL
  • stay_id (병동ID) — INT NOT NULL
  • caregiver_id (간병인ID) — INT
  • starttime (약물투약시작시간) — TIMESTAMP NOT NULL
  • endtime (약물투약종료시간) — TIMASTAMP NOT NULL
  • storetime (수동검증시간) — TIMASTAMP NOT NULL
  • itemid (단일측정유형에대한식별자ID) — INT NOT NULL
  • value (값) — FLOAT
  • valueuom (값의측정단위) — VARCHAR(20)
  • location (환자의치료가수행된위치) — VARCHAR(100)
  • locationcategory (치료를받은위치의범주) — VARCHAR(50)
  • linkorderid (동일한순서를연결) — INT
  • ordercategoryname (의료지시의범주) — VARCHAR(50)
  • ordercategorydescription (의료조치유형) — VARCHAR(30)
  • patientweight (환자체중) — FLOAT
  • isopenbag (환자의의료가방유무) — SMALLINT
  • continueinnextdept (약물투여가계속돼야함을나타냄) — SMALLINT
  • statusdescription (투여된의약품의현재상태설명) — VARCHAR(20)
  • ORIGINALAMOUNT (시작시간에봉지에들어있는화합물양) — FLOAT
  • ORIGINALRATE (진료자가입력한요금) — FLOAT

procedures_icd (h-11)

  • seq_num (진단에할당된우선순위) — INT NOT NULL — 기본 키
  • subject_id (환자ID) — INT NOT NULL — 기본 키
  • icd_code (ICD(국제코딩정의)코드) — VARCHAR(7) — 기본 키
  • icd_version (ICD코드버전) — SMALLINT — 기본 키
  • hadm_id (병원입원ID) — INT NOT NULL
  • chartdate (차트날짜) — DATE

provider (h-12)

  • provider_id (공급자ID) — VARCHAR(10)

services (h-13)

  • hadm_id (병원입원ID) — INT NOT NULL — 기본 키
  • transfertime (SERVICE로이동한시간) — TIMESTAMP NOT NULL — 기본 키
  • curr_service (환자가현재상주하는서비스) — VARCHAR(10) — 기본 키
  • subject_id (환자ID) — INT NOT NULL
  • prev_service (환자가이전에상주하던서비스) — VARCHAR(10)

transfers (h-14)

  • subject_id (환자ID) — INT NOT NULL
  • hadm_id (병원입원ID) — INT
  • transfer_id (환자위치ID) — INT NOT NULL
  • eventtype (환자이송유형) — VARCHAR(10)
  • careunit (환자병동의유형) — VARCHAR(255)
  • intime (진료실이전시간) — TIMESTAMP
  • outtime (진료실퇴원시간) — TIMESTAMP