데이터베이스 과제 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