데이터베이스 4조
테이블 (31)
Admissions
- (hadm_id) — INT — 기본 키 — NOT NULL
- (admittime) — TIMESTAMP — NOT NULL
- Field3 (dischtime) — TIMESTAMP
- Field (deathtime) — TIMESTAMP
- Field2 (admission_type) — VARCHAR(40) — NOT NULL
- Field3 (admit_provider_id) — VARCHAR(10)
- Field4 (admission_location) — VARCHAR(60)
- Field (discharge_location) — VARCHAR(60)
- Field2 (insurance) — VARCHAR(255)
- Field3 (language) — VARCHAR(10)
- Field4 (marital_status) — VARCHAR(30)
- Field (race) — VARCHAR(80)
- Field2 (edregtime) — TIMESTAMP
- Field (edouttime) — TIMESTAMP
- Field2 (hospital_expire_flag) — SMALLINT
- Key (subject_id) — INT — 외래 키 → patients.Key — NOT NULL
caregiver
- (caregiver_id) — INT — NOT NULL
chartevents
- (itemid) — INT — 외래 키 → d_items.Key — NOT NULL
- Field (stay_id) — INT — 외래 키 → icustays.Field — NOT NULL
- (hadm_id) — INT — 외래 키 → Admissions.hadm_id — NOT NULL
- (subject_id) — INT — 외래 키 → patients.Key — NOT NULL
- Field (storetime) — TIMESTAMP(0)
- Field (value) — VARCHAR(200)
- Field (valuenum) — FLOAT
- Field (valueuom) — VARCHAR(20)
- Field (warning) — SMALLINT
- (caregiver_id) — INT
- Field (charttime) — TIMESTAMP(0) — NOT NULL
d_hcpcs
- Key (code) — CHAR(5) — 기본 키 — NOT NULL
- Field (category) — SMALLINT
- Field (long_description) — TEXT
- Field (short_description) — VARCHAR(180)
d_icd_diagnose
- Field (icd_code) — CHAR(7) — 기본 키 — NOT NULL
- Field (icd_version) — INT — 기본 키 — NOT NULL
- Field (long_title) — VARCHAR(255)
d_icd_procedures
- Field (icd_code) — CHAR(7) — 기본 키 — NOT NULL
- Field (icd_version) — INT — 기본 키 — NOT NULL
- Field (long_title) — VARCHAR(255)
d_items
- Key (itemid) — INT — 기본 키 — NOT NULL
- Field (label) — VARCHAR(100) — NOT NULL
- Field (abbreviation) — VARCHAR(50) — NOT NULL
- Field (linksto) — VARCHAR(30) — NOT NULL
- Field (category) — VARCHAR(50) — NOT NULL
- Field (unitname) — VARCHAR(50)
- Field (param_type) — VARCHAR(20) — NOT NULL
- Field (lownormalvalue) — FLOAT
- Field (highnormalvalue) — FLOAT
d_labitems
- Field (itemid) — INT — 기본 키
- Field (label) — VARCHAR(50)
- Field (fluid) — VARCHAR(50)
- Field (category) — VARCHAR(50)
datatimeevents
- Field (charttime) — TIMESTAMP(3) — 기본 키 — NOT NULL
- Field (stay_id) — INT — 외래 키 → icustays.Field — NOT NULL
- Key (itemid) — INT — 외래 키 → d_items.Key — NOT NULL
- Key (subject_id) — INT — 외래 키 → patients.Key — NOT NULL
- (hadm_id) — INT — 외래 키 → Admissions.hadm_id — NOT NULL
- Field (storetime) — TIMESTAMP(3)
- Key (caregiver_id) — INT
- Field (value) — TIMESTAMP(3) — NOT NULL
- Field (valueuom) — VARCHAR(20)
- Field (warning) — SMALLINT
diagnoses_icd
- Field (seq_num) — INT — 기본 키 — NOT NULL
- Field (icd_code) — VARCHAR(7) — 기본 키
- Field (icd_version) — INT — 기본 키
- (hadm_id) — INT — 외래 키 → Admissions.hadm_id — NOT NULL
- Key (subject_id) — INT — 외래 키 → patients.Key — NOT NULL
drgcodes
- Key (subject_id) — INT — 외래 키 → patients.Key
- Field (drg_type) — VARCHAR(4)
- Field (drg_code) — VARCHAR(10)
- Field (description) — VARCHAR(19)
- Field (drg_severity) — SMALLINT
- Field (drg_mortality) — SMALLINT
- (hadm_id) — INT — 외래 키 → Admissions.hadm_id
emar
- Field (emar_id) — VARCHAR(25) — 기본 키 — NOT NULL
- Key (subject_id) — INT — 외래 키 → patients.Key — NOT NULL
- (hadm_id) — INT — 외래 키 → Admissions.hadm_id
- Field (emar_seq) — INT — NOT NULL
- Field (poe_id) — VARCHAR(25) — NOT NULL
- Field (pharmacy_id) — INT
- Field (enter_provider_id) — VARCHAR(10)
- Field (charttime) — TIMESTAMP — NOT NULL
- Field (medication) — TEXT
- Field (event_txt) — VARCHAR(10)
- Field (scheduletime) — TIMESTAMP
- Field (storetime) — TIMESTAMP — NOT NULL
emar_detail
- Field (parent_field_ordinal) — VARCHAR(10) — 기본 키
- Field (emar_id) — VARCHAR(25) — 외래 키 → emar.Field — NOT NULL
- Key (subject_id) — INT — 외래 키 → patients.Key — NOT NULL
- Field (emar_seq) — INT — NOT NULL
- Field (administration_type) — VARCHAR(50)
- Field (pharmacy_id) — INT
- Field (barcode_type) — VARCHAR(4)
- Field (reason_for_no_barcode) — TEXT
- Field (complete_dose_not_given) — VARCHAR(5)
- Field (dose_due) — VARCHAR(10)
- Field (dose_due_unit) — VARCHAR(50)
- Field (dose_given) — VARCHAR(255)
- Field (dose_given_unit) — VARCHAR(50)
- Field (will_remainder_of_dose_be_given) — VARCHAR(5)
- Field (product_amount_given) — VARCHAR(30)
- Field (product_unit) — VARCHAR(30)
- Field (product_code) — VARCHAR(30)
- Field (product_description) — VARCHAR(255)
- Field (product_description_other) — VARCHAR(255)
- Field (prior_infusion_rate) — VARCHAR(40)
- Field (infusion_rate) — VARCHAR(40)
- Field (infusion_rate_adjustment) — VARCHAR(50)
- Field (infusion_rate_adjustment_amount) — VARCHAR(30)
- Field (infusion_rate_unit) — VARCHAR(30)
- Field (route) — VARCHAR(10)
- Field (infusion_complete) — VARCHAR(1)
- Field (completion_interval) — VARCHAR(50)
- Field (new_iv_bag_hung) — VARCHAR(1)
- Field (continued_infusion_in_other_location) — VARCHAR(1)
- Field (restart_interval) — TEXT
- Field (side) — VARCHAR(10)
- Field2 (site) — VARCHAR(255)
- Field (non_formulary_visual_verification) — VARCHAR(1)
hcpcsevents
- Field (hcpcs_cd) — CHAR(5) — 기본 키 — NOT NULL
- Key (code) — CHAR(5) — 외래 키 → d_hcpcs.Key — NOT NULL
- Field (chartdate) — TIMESTAMP
- Field (seq_num) — INT — NOT NULL
- Field (short_description) — VARCHAR(180)
- Key (subject_id) — INT — 외래 키 → patients.Key — NOT NULL
- (hadm_id) — INT — 외래 키 → Admissions.hadm_id — NOT NULL
icustays
- Field (stay_id) — INT — 기본 키 — NOT NULL
- Key (subject_id) — INT — 외래 키 → patients.Key — NOT NULL
- (hadm_id) — INT — 외래 키 → Admissions.hadm_id — NOT NULL
- Field (first_careunit) — VARCHAR(255)
- Field (last_careunit) — VARCHAR(255)
- Field (intime) — TIMESTAMP(0)
- Field (outtime) — TIMESTAMP(0)
- Field (los) — FLOAT
ingredientevents
- Field (subject_id) — INT — NOT NULL
- Field (hadm_id) — INT — NOT NULL
- Field (stay_id) — INT
- (caregiver_id) — INT
- Field (starttime) — TIMESTAMP(0) — NOT NULL
- Field2 (endtime) — TIMESTAMP(0) — NOT NULL
- Field (storetime) — TIMESTAMP(0)
- Key (itemid) — INT — NOT NULL
- Field (amount) — FLOAT
- Field (amountuom) — VARCHAR(20)
- Field (rate) — FLOAT
- Field (orderid) — INT — NOT NULL
- Field (linkorderid) — INT
- Field (statusdescription) — VARCHAR(20)
- Field2 (rateuom) — VARCHAR(20)
- Field (originalamount) — FLOAT
- Field (originalrate) — FLOAT
inputevents
- Field (orderid) — INT — 기본 키 — NOT NULL
- Key (itemid) — INT — 외래 키 → d_items.Key — NOT NULL
- Field (stay_id) — INT — 외래 키 → icustays.Field
- (hadm_id) — INT — 외래 키 → Admissions.hadm_id — NOT NULL
- Key (subject_id) — INT — 외래 키 → patients.Key — NOT NULL
- (caregiver_id) — INT
- Field (starttime) — TIMESTAMP(0) — NOT NULL
- Field (endtime) — TIMESTAMP(0) — NOT NULL
- Field (storetime) — TIMESTAMP(0)
- Field (amount) — FLOAT
- Field (amountuom) — VARCHAR(20)
- Field (rate) — FLOAT
- Field (rateuom) — VARCHAR(20)
- Field (linkorderid) — INT — NOT NULL
- Field (ordercategoryname) — VARCHAR(50)
- Field (secondartyordercategoryname) — VARCHAR(50)
- Field (ordercomponenttypedescription) — VARCHAR(100)
- Field (ordercategorydescription) — VARCHAR(30)
- Field (patientweight) — FLOAT
- Field (totalamount) — FLOAT
- Field (totalamountuom) — VARCHAR(50)
- Field (isopenbag) — SMALLINT
- Field (statusdescription) — VARCHAR(20)
- Field (orignalamount) — FLOAT
- Field (originalrate) — FLOAT
- Field (continueinnextdept) — SMALLINT,
labevents
- Field (labevent_id) — INT — 기본 키 — NOT NULL
- Field (hadm_id) — INT
- Field (specimen_id) — INT — NOT NULL
- Field (order_provider_id) — VARCHAR(10)
- Field (charttime) — TIMESTAMP
- Field (storetime) — TIMESTAMP
- Field (value) — VARCHAR(200)
- Field (valuenum) — DOUBLE PRECISION
- Field (valueuom) — VARCHAR(20)
- Field (ref_range_lower, ref_range_upper) — DOUBLE PRECISION
- Field (flag) — VARCHAR(10)
- Field (priority) — VARCHAR(7)
- Field (comments) — TEXT
- Key (subject_id) — INTEGER — 외래 키 → patients.Key — NOT NULL
- Field (itemid) — INT — 외래 키 → d_labitems.Field — NOT NULL
microbiologyevents
- Field (microevent_id) — INT — 기본 키 — NOT NULL
- Field (micro_specimen_id) — INT — NOT NULL
- Field (order_provider_id) — VARCHAR(10)
- Field (chartdate) — TIMESTAMP — NOT NULL
- Field (charttime) — TIMESTAMP(0)
- Field (spec_itemid) — INT — NOT NULL
- Field (spec_type_desc) — VARCHAR(100) — NOT NULL
- Field (test_seq) — INT — NOT NULL
- Field (storedate) — TIMESTAMP(0)
- Field (storetime) — TIMESTAMP(0)
- Field (test_itemid) — INT
- Field (test_name) — VARCHAR(100)
- Field (org_itemid) — INT
- Field (org_name) — VARCHAR(100)
- Field (isolate_num) — SMALLINT
- Field (quantity) — VARCHAR(50)
- Field (ab_itemid) — INT
- Field (ab_name) — VARCHAR(30)
- Field (dilution_text) — VARCHAR(10)
- Field (dilution_comparison) — VARCHAR(20)
- Field (interpretation) — VARCHAR(5)
- Field (comments) — TEXT
- Key (subject_id) — INT — 외래 키 → patients.Key — NOT NULL
- (hadm_id) — INT — 외래 키 → Admissions.hadm_id
- Field (dilution_value) — DOUBLE PRECISION
omr
- Key (subject_id) — INT — 기본 키 — NOT NULL
- Field (chartdate) — DATE — NOT NULL
- Field (seq_num) — INT — NOT NULL
- Field (result_name) — VARCHAR(100) — NOT NULL
- Field (result_value) — TEXT — NOT NULL
outputevents
- Field4 (charttime) — TIMESTAMP(3) — 기본 키 — NOT NULL
- Field (stay_id) — INT — 외래 키 → icustays.Field — NOT NULL
- Key (itemid) — INT — 외래 키 → d_items.Key — NOT NULL
- Key (subject_id) — INT — 외래 키 → patients.Key — NOT NULL
- (hadm_id) — INT — 외래 키 → Admissions.hadm_id — NOT NULL
- Field (storetime) — TIMESTAMP(3) — NOT NULL
- Field (value) — FLOAT — NOT NULL
- Field (valueuom) — VARCHAR(20)
- Field3 (caregiver_id) — INT
patients
- Key (subject_id) — INT — 기본 키 — NOT NULL
- Field (pharmacy_id) — INT — 외래 키 → pharmacy.Field — NOT NULL
- Field (gender) — CHAR(10) — NOT NULL
- Field (anchor_age) — SMALLINT — NOT NULL
- Field (anchor_year) — SMALLINT — NOT NULL
- Field (anchor_year_group) — VARCHAR(20) — NOT NULL
- Field (dod) — DATE
pharmacy
- Field (pharmacy_id) — INT — 기본 키 — NOT NULL
- Field (poe_id) — VARCHAR(25)
- Field (starttime) — TIMESTAMP(3)
- Field (stoptime) — TIMESTAMP(3)
- Field (medication) — TEXT
- Field (proc_type) — VARCHAR(50) — NOT NULL
- Field (status) — VARCHAR(50)
- Field (entertime) — TIMESTAMP(3) — NOT NULL
- Field (verifiedtime) — TIMESTAMP(3)
- Field (route) — VARCHAR(50)
- Field (frequency) — VARCHAR(50)
- Field (disp_sched) — VARCHAR(255)
- Field (infusion_type) — VARCHAR(15)
- Field (sliding_scale) — VARCHAR(1)
- Field (lockout_interval) — VARCHAR(50)
- Field (basal_rate) — REAL
- Field (one_hr_max) — VARCHAR(10)
- Field (doses_per_24_hrs) — REAL
- Field (duration) — REAL
- Field (duration_interval) — VARCHAR(50)
- Field (expiration_value) — INT
- Field (expiration_unit) — VARCHAR(50)
- Field (expirationdate) — TIMESTAMP(3)
- Field (dispensation) — VARCHAR(50)
- Field (fill_quantity) — VARCHAR(50)
- Key (subject_id) — INT — 외래 키 → patients.Key — NOT NULL
- (hadm_id) — INT — 외래 키 → Admissions.hadm_id — NOT NULL
poe
- Key (poe_id) — VARCHAR(25) — 기본 키 — NOT NULL
- Field (poe_seq) — INT — NOT NULL
- Field (ordertime) — TIMESTAMP(0) — NOT NULL
- Field (order_type) — VARCHAR(25) — NOT NULL
- Field (order_subtype) — VARCHAR(50)
- Field (transaction_type) — VARCHAR(15)
- Field (discontinue_of_poe_id) — VARCHAR(25)
- Field (discontinued_by_poe_id) — VARCHAR(25)
- Field (order_provider_id) — VARCHAR(10)
- Field (order_status) — VARCHAR(15)
- Key (subject_id) — INT — 외래 키 → patients.Key — NOT NULL
- (hadm_id) — INT — 외래 키 → Admissions.hadm_id
poe_detail
- Field (field_name) — VARCHAR(255) — 기본 키 — NOT NULL
- Key (poe_id) — VARCHAR(25) — 외래 키 → poe.Key — NOT NULL
- Field (poe_seq) — INT — NOT NULL
- Field (field_value) — TEXT
- Key (subject_id) — INT — 외래 키 → patients.Key — NOT NULL
prescriptions
- Key (pharmacy_id) — INT — 기본 키 — NOT NULL
- Field (drug_type) — VARCHAR(20) — 기본 키 — NOT NULL
- Field (drug) — VARCHAR(255) — 기본 키 — NOT NULL
- Field (poe_seq) — INT
- Field (order_provider_id) — VARCHAR(10)
- Field (starttime) — TIMESTAMP(3)
- Field (stoptime) — TIMESTAMP(3)
- Field (formulary_drug_cd) — VARCHAR(50)
- Field (gsn) — VARCHAR(255)
- Field (ndc) — VARCHAR(25)
- Field (prod_strength) — VARCHAR(255)
- Field (form_rx) — VARCHAR(25)
- Field (dose_val_rx) — VARCHAR(100)
- Field (dose_unit_rx) — VARCHAR(50)
- Field (form_val_disp) — VARCHAR(50)
- Field (form_unit_disp) — VARCHAR(50)
- Field (doses_per_24_hrs) — REAL
- Field (route) — VARCHAR(50)
- Key (poe_id) — VARCHAR(25)
- Key (subject_id) — INT — 외래 키 → patients.Key — NOT NULL
- (hadm_id) — INT — 외래 키 → Admissions.hadm_id — NOT NULL
procedureevents
- Field8 (orderid) — INT — 기본 키
- Key (itemid) — INT — 외래 키 → d_items.Key — NOT NULL
- Field (stay_id) — INT — 외래 키 → icustays.Field — NOT NULL
- (hadm_id) — INT — 외래 키 → Admissions.hadm_id — NOT NULL
- Key (subject_id) — INT — 외래 키 → patients.Key — NOT NULL
- Field4 (starttime) — TIMESTAMP — NOT NULL
- Field (endtime) — TIMESTAMP — NOT NULL
- Field2 (storetime) — TIMESTAMP — NOT NULL
- Field4 (value) — FLOAT
- Field5 (valueuom) — VARCHAR(20)
- Field6 (location) — VARCHAR(100)
- Field7 (locationcategory) — VARCHAR(50)
- Field9 (linkorderid) — INT
- Field10 (ordercategoryname) — VARCHAR(50)
- Field (ordercategorydescription) — VARCHAR(30)
- Field2 (patientweight) — FLOAT
- Field3 (isopenbag) — SMALLINT
- Field4 (continueinnextdept) — SMALLINT
- Field5 (statusdescription) — VARCHAR(20)
- Field (originalamount) — FLOAT
- Field2 (originalrate) — FLOAT
- (caregiver_id) — INT
procedures_icd
- Field (seq_num) — INT — 기본 키 — NOT NULL
- Field (icd_code) — VARCHAR(7) — 기본 키
- Field (icd_version) — SMALLINT — 기본 키
- (hadm_id) — INT — 외래 키 → Admissions.hadm_id — NOT NULL
- Field (chartdate) — DATE — NOT NULL
- Field — INT — NOT NULL
- Key (subject_id) — INT — 외래 키 → patients.Key — NOT NULL
provider
- Key (provider_id) — VARCHAR(10) — NOT NULL
services
- Field (transfertime) — TIMESTAMP — 기본 키 — NOT NULL
- Field (curr_service) — VARCHAR(10) — 기본 키
- (hadm_id) — INT — 외래 키 → Admissions.hadm_id — NOT NULL
- Field2 (prev_service) — VARCHAR(10)
- Key (subject_id) — INT — 외래 키 → patients.Key — NOT NULL
transfers
- Key3 (transfer_id) — INTEGER — 기본 키 — NOT NULL
- Field (eventtype) — VARCHAR(10)
- Field2 (careunit) — VARCHAR(255)
- Field (intime) — TIMESTAMP
- Field (outtime) — TIMESTAMP
- Key2 (hadm_id) — INT
- Key (subject_id) — INT — 외래 키 → patients.Key — NOT NULL