ดูจาก Change Log แล้วมันน่าสนใจ จ๊ะ และถามเผื่อหลายๆท่านที่สงสัย คือกัลล จ้า
ประมาณ
ALTER TABLE xray_pacs_transaction ADD `hos_guid` char(38) NULL
ALTER TABLE ward_admit_snapshot ADD `hos_guid` char(38) NULL
ALTER TABLE vn_opd_complete ADD `hos_guid` char(38) NULL
ALTER TABLE vn_insert ADD `hos_guid` char(38) NULL
ALTER TABLE vital_sign_data ADD `hos_guid` char(38) NULL
ALTER TABLE visit_pttype_change ADD `hos_guid` char(38) NULL
ALTER TABLE visit_name ADD `hos_guid` char(38) NULL
ALTER TABLE thaiaddress ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE sks_drug_code ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE sks_drug_code ADD `hos_guid` char(38) NULL
ALTER TABLE serial ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE screen_doctor ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE screen_doctor ADD `hos_guid` char(38) NULL
ALTER TABLE rx_audit ADD `hos_guid` char(38) NULL
ALTER TABLE risk_screen_sso_company ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE risk_screen_sso_company ADD `hos_guid` char(38) NULL
ALTER TABLE reporttemplate_history ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE reporttemplate ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE rcpt_print_opi ADD `hos_guid` char(38) NULL
ALTER TABLE rcpt_disease ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE rcpt_debt_opi ADD `hos_guid` char(38) NULL
ALTER TABLE rcpt_abort ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE rcpt_abort ADD `hos_guid` char(38) NULL
ALTER TABLE pttypehistory ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE pttypehistory ADD `hos_guid` char(38) NULL
ALTER TABLE ptdepart ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE ptdepart ADD `hos_guid` char(38) NULL
ALTER TABLE provis_chronic_icd10 ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE provis_chronic_icd10 ADD `hos_guid` char(38) NULL
ALTER TABLE profile_print ADD `hos_guid` char(38) NULL
ALTER TABLE pq_screen ADD `hos_guid` char(38) NULL
ALTER TABLE pq_ipdorder ADD `hos_guid` char(38) NULL
ALTER TABLE person_bc_target ADD `hos_guid` char(38) NULL
ALTER TABLE person_anc_classifying ADD `hos_guid` char(38) NULL
ALTER TABLE pe_image ADD `hos_guid` char(38) NULL
ALTER TABLE pe_code ADD `hos_guid` char(38) NULL
ALTER TABLE patient_search ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE patient_search ADD `hos_guid` char(38) NULL
ALTER TABLE patient_rx_note ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE patient_rx_note ADD `hos_guid` char(38) NULL
ALTER TABLE patient_regiment ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE patient_regiment ADD `hos_guid` char(38) NULL
ALTER TABLE patient_qr_code ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE patient_qr_code ADD `hos_guid` char(38) NULL
ALTER TABLE patient_pttype_lock ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE patient_pttype_lock ADD `hos_guid` char(38) NULL
ALTER TABLE patient_pid ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE patient_pid ADD `hos_guid` char(38) NULL
ALTER TABLE patient_nc ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE patient_nc ADD `hos_guid` char(38) NULL
ALTER TABLE patient_history ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE patient_history ADD `hos_guid` char(38) NULL
ALTER TABLE patient_employer ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE patient_employer ADD `hos_guid` char(38) NULL
ALTER TABLE ovst_rx_room ADD `hos_guid` char(38) NULL
ALTER TABLE ovst_presc_ned ADD `hos_guid` char(38) NULL
ALTER TABLE ovst_nhso_send ADD `hos_guid` char(38) NULL
ALTER TABLE ovst_finance ADD `hos_guid` char(38) NULL
ALTER TABLE ovst_control_doctor ADD `hos_guid` char(38) NULL
ALTER TABLE opitemrece_summary ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE opitemrece_sticker_stat ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE opitemrece_pay ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE opitemrece_medplan ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE opitemrece_ipd ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE opitemrece_finance_delete ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE opitemrece_charge ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE operation_icd_10 ADD `hos_guid` char(38) NULL
ALTER TABLE opduser_right ADD `hos_guid` char(38) NULL
ALTER TABLE opdcard_location ADD `hos_guid` char(38) NULL
ALTER TABLE opd_regist_sendlist ADD `hos_guid` char(38) NULL
ALTER TABLE opd_observe ADD `hos_guid` char(38) NULL
ALTER TABLE opd_ill_history ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE opd_ill_history ADD `hos_guid` char(38) NULL
ALTER TABLE opd_hn_change ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE nhso_offline_check ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE nhso_offline_check ADD `hos_guid` char(38) NULL
ALTER TABLE medreturn_ipd ADD `hos_guid` char(38) NULL
ALTER TABLE medpay_ipd_head ADD `hos_guid` char(38) NULL
ALTER TABLE loinc_code ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE loinc_code ADD `hos_guid` char(38) NULL
ALTER TABLE lab_order_print ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE lab_lis_track ADD `hos_guid` char(38) NULL
ALTER TABLE ipt_queue ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE ipt_queue ADD `hos_guid` char(38) NULL
ALTER TABLE ipt_income_auto_check ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE ipt_income_auto_check ADD `hos_guid` char(38) NULL
ALTER TABLE ipt_income_auto_charge ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE ipt_income_auto_charge ADD `hos_guid` char(38) NULL
ALTER TABLE ipt_income_auto ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE ipt_income_auto ADD `hos_guid` char(38) NULL
ALTER TABLE ipt_food_order_sp ADD `hos_guid` char(38) NULL
ALTER TABLE ipt_finance_status ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE ipt_finance_status ADD `hos_guid` char(38) NULL
ALTER TABLE ipt_chart_location ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE ipt_chart_location ADD `hos_guid` char(38) NULL
ALTER TABLE ipt_against_advice ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE ipt_against_advice ADD `hos_guid` char(38) NULL
ALTER TABLE ipt_admit_queue ADD `hos_guid` char(38) NULL
ALTER TABLE ipd_profile_print ADD `hos_guid` char(38) NULL
ALTER TABLE ipd_mar ADD `hos_guid` char(38) NULL
ALTER TABLE ipd_data_synchronize ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE ipd_data_synchronize ADD `hos_guid` char(38) NULL
ALTER TABLE incoth_summary_head ADD `hos_guid` char(38) NULL
ALTER TABLE incoth ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE incith_adjust ADD `hos_guid` char(38) NULL
ALTER TABLE incith ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE incith ADD `hos_guid` char(38) NULL
ALTER TABLE inc_opd_stat ADD `hos_guid` char(38) NULL
ALTER TABLE inc_ipd_stat ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE inc_ipd_stat ADD `hos_guid` char(38) NULL
ALTER TABLE icd_codemap ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE icd_codemap ADD `hos_guid` char(38) NULL
ALTER TABLE icd9cm1 ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE icd9cm1 ADD `hos_guid` char(38) NULL
ALTER TABLE icd10tm_operation ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE icd10tm_operation ADD `hos_guid` char(38) NULL
ALTER TABLE icd101 ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE icd101 ADD `hos_guid` char(38) NULL
ALTER TABLE hosxp_ddl_index ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE hosxp_ddl_index ADD `hos_guid` char(38) NULL
ALTER TABLE hosxp_ddl_field ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE hosxp_ddl_field ADD `hos_guid` char(38) NULL
ALTER TABLE hospcode ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE hninsert ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE hninsert ADD `hos_guid` char(38) NULL
ALTER TABLE hipdata ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE height_chart ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE fbshistory ADD `hos_guid` char(38) NULL
ALTER TABLE eriscode ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE eriscode ADD `hos_guid` char(38) NULL
ALTER TABLE er_image ADD `hos_guid` char(38) NULL
ALTER TABLE dw_emr_cache ADD `hos_guid` char(38) NULL
ALTER TABLE dt_list ADD `hos_guid` char(38) NULL
ALTER TABLE drugusage_line2 ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE drugusage_line2 ADD `hos_guid` char(38) NULL
ALTER TABLE drugusage_line1 ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE drugusage_line1 ADD `hos_guid` char(38) NULL
ALTER TABLE drugstdgeneric ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE drugstdgeneric ADD `hos_guid` char(38) NULL
ALTER TABLE drugitems_usage ADD `hos_guid` char(38) NULL
ALTER TABLE drugitems_register_unique ADD `hos_guid` char(38) NULL
ALTER TABLE drugitems_register ADD `hos_guid` char(38) NULL
ALTER TABLE drug_interaction_incident ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE drug_interaction_incident ADD `hos_guid` char(38) NULL
ALTER TABLE doctor_cert ADD `hos_guid` char(38) NULL
ALTER TABLE dental_icd ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE dental_icd ADD `hos_guid` char(38) NULL
ALTER TABLE dbicd10chronic ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE dbicd10chronic ADD `hos_guid` char(38) NULL
ALTER TABLE dbhospital ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE dbhospital ADD `hos_guid` char(38) NULL
ALTER TABLE dbaddress ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE dbaddress ADD `hos_guid` char(38) NULL
ALTER TABLE data_synchronize ADD `hos_guid` char(38) NULL
ALTER TABLE ct2proc ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE ct2proc ADD `hos_guid` char(38) NULL
ALTER TABLE ct2mdcpr ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE ct2mdcpr ADD `hos_guid` char(38) NULL
ALTER TABLE ct2icd10 ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE ct2icd10 ADD `hos_guid` char(38) NULL
ALTER TABLE ct2ccexc ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE ct2ccexc ADD `hos_guid` char(38) NULL
ALTER TABLE ct2ax ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE ct2ax ADD `hos_guid` char(38) NULL
ALTER TABLE bw_chart ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE bmi_chart ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE bird_flu_screen ADD `hos_guid` char(38) NULL
ALTER TABLE baby_development_status ADD `hos_guid_ext` varchar(64) NULL
ALTER TABLE aninsert ADD `hos_guid_ext` varchar(64) NULL