คงต้องนั่งพิจารณาทีละ vn แล้วละ
ว่าอันไหนเป็นของHN ไหน
ไล่แก้ไปทีละตาราง อิอิ หน้ามืดละครานี้
TABLE_NAME COLUMN_NAME COLUMN_TYPE
patient father_hn varchar(9)
active_medication hn varchar(9)
allergy_confirm hn varchar(9)
an_stat hn varchar(9)
anc_birthcontrol_history hn varchar(9)
anc_detail hn varchar(9)
anc_family_history hn varchar(9)
anc_head hn varchar(9)
anc_ill_history hn varchar(9)
anc_member hn varchar(9)
anc_preg_history hn varchar(9)
approve_doctor hn varchar(9)
ar_head hn varchar(9)
baby_development_status hn varchar(9)
baby_member hn varchar(9)
backupx hn varchar(9)
backupx1 hn varchar(9)
bb9_sender hn varchar(9)
bb_sender hn varchar(9)
blood_request hn varchar(9)
clinic_cormobidity_diabete hn varchar(9)
clinic_cormobidity_list hn varchar(9)
clinic_dm_member hn varchar(9)
clinic_dys hn varchar(9)
clinic_miss_dose hn varchar(9)
clinic_persist_icd hn varchar(9)
clinic_profile hn varchar(9)
clinic_transfer hn varchar(9)
clinic_visit hn varchar(9)
clinicmember hn varchar(9)
death hn varchar(9)
debtor hn varchar(9)
dentop hn varchar(9)
doctor_cert hn varchar(9)
doctor_consult hn varchar(9)
doctor_fee_list hn varchar(9)
doctor_order_print hn varchar(9)
doctorptotlist hn varchar(9)
doctorscreen hn varchar(9)
drug_counseling_list hn varchar(9)
dtdn hn varchar(9)
dtmain hn varchar(9)
dtmain_save hn varchar(9)
eris hn varchar(9)
factordm hn varchar(9)
fbshistory hn varchar(9)
ff_service hn varchar(9)
ffdeath hn varchar(9)
ffhealth hn varchar(9)
ffmember hn varchar(9)
finance_check hn varchar(9)
finance_deposit hn varchar(9)
finance_ticket hn varchar(9)
finger_template hn varchar(9)
food_allergy hn varchar(9)
fp_member hn varchar(9)
fp_women hn varchar(9)
fpapp hn varchar(9)
fpmain hn varchar(9)
hipdatachw hn varchar(9)
hn_change_log hn varchar(9)
hninsert hn varchar(9)
hnlock hn varchar(9)
hospital Hn varchar(9)
inc_ipd_stat hn varchar(9)
inc_opd_stat hn varchar(9)
inc_std_ipd_stat hn varchar(9)
inc_std_opd_stat hn varchar(9)
incoth hn varchar(9)
inj_demo hn varchar(9)
injury hn varchar(9)
ipdrent hn varchar(9)
ipt hn varchar(9)
ipt_admit_queue hn varchar(9)
ipt_labour hn varchar(9)
ipt_labour_infant hn varchar(9)
ipt_nk2 hn varchar(9)
iptdiag hn varchar(9)
lab_app_head hn varchar(9)
lab_bethesda_head hn varchar(9)
lab_head hn varchar(9)
lab_routine_result hn varchar(9)
lab_specimen hn varchar(9)
medplan_ipd_wait hn varchar(9)
moo_home_member hn varchar(9)
oapp hn varchar(9)
oapp_cancel hn varchar(9)
oapp_temp hn varchar(9)
oldpttypeno hn varchar(9)
opd_allergy hn varchar(9)
opd_card_request hn varchar(9)
opd_ill_history hn varchar(9)
opdcard_location hn varchar(9)
opdcard_not_found hn varchar(9)
opdcard_print_log hn varchar(9)
opdrent hn varchar(9)
opdscan hn varchar(9)
opdscreen hn varchar(9)
opdscreening hn varchar(9)
operation_list hn varchar(9)
operation_schedule hn varchar(9)
opitemrece hn varchar(9)
opitemrece_arc hn varchar(9)
opitemrece_bak hn varchar(9)
opitemrece_delta hn varchar(9)
opitemrece_finance_delete hn varchar(9)
opitemreceh hn varchar(9)
ovaccident hn varchar(9)
ovst hn varchar(9)
ovst_department hn varchar(9)
ovstdiag hn varchar(9)
patient hn varchar(9)
patient_adr hn varchar(9)
patient_birth hn varchar(9)
patient_description hn varchar(9)
patient_employer hn varchar(9)
patient_file hn varchar(9)
patient_history hn varchar(9)
patient_hospital hn varchar(9)
patient_hospital_refer hn varchar(9)
patient_image hn varchar(9)
patient_ipd_scan hn varchar(9)
patient_log hn varchar(9)
patient_nc hn varchar(9)
patient_opd_scan hn varchar(9)
patient_pid hn varchar(9)
patient_promotion hn varchar(9)
patient_pttype hn varchar(9)
patient_pttype_lock hn varchar(9)
patient_realname hn varchar(9)
patient_regiment hn varchar(9)
patient_relation_address hn varchar(9)
patient_remove_log hn varchar(9)
patient_rx_note hn varchar(9)
patient_search hn varchar(9)
patient_vaccine hn varchar(9)
pcu_hn hn varchar(9)
physic_main hn varchar(9)
physic_main_ipd hn varchar(9)
physic_member hn varchar(9)
pq_ipd_rxorder hn varchar(9)
pq_opdcard hn varchar(9)
pq_opdcard_tag hn varchar(9)
pq_rxorder hn varchar(9)
psychia_member hn varchar(9)
psychia_member_type hn varchar(9)
psychia_service_list hn varchar(9)
psychia_visit hn varchar(9)
pt_consult hn varchar(9)
pt_medication_history hn varchar(9)
ptcardno hn varchar(9)
ptdepart hn varchar(9)
pteroprt hn varchar(9)
ptnote hn varchar(9)
pttype_log hn varchar(9)
pttypehistory hn varchar(9)
pttypeno hn varchar(9)
rcpt_abort hn varchar(9)
rcpt_arrear hn varchar(9)
rcpt_credit hn varchar(9)
rcpt_current hn varchar(9)
rcpt_debt hn varchar(9)
rcpt_debt_cancel hn varchar(9)
rcpt_print hn varchar(9)
referin hn varchar(9)
referout hn varchar(9)
report_sks hn varchar(9)
room_reserve hn varchar(9)
service_time hn varchar(9)
surveil_member hn varchar(9)
tempblue_command1 hn varchar(9)
universal_head hn varchar(9)
visit_name hn varchar(9)
visit_pay_plan hn varchar(9)
vital_sign_data hn varchar(9)
vn_stat hn varchar(9)
xray_head hn varchar(9)
xray_rent hn varchar(9)
xray_report hn varchar(9)
xrayexam hn varchar(9)
xrayxn hn varchar(9)
hn_change_log hn_change_log_id int(11)
data_synchronize hn_guid varchar(38)
ipd_data_synchronize hn_guid varchar(38)
patient hn_int int(11)
pcu_node hn_start varchar(7)
opdconfig hn_style tinyint(4)
hismember matchhn varchar(7)
patient mother_hn varchar(9)
opd_hn_change new_hn varchar(9)
pcu_hn new_hn varchar(7)
opd_hn_change old_hn varchar(9)
opd_hn_change opd_hn_change_id int(11)
person patient_hn varchar(9)
หัวข้อ: รวม HN ผิดคน (อ่าน 5027 ครั้ง)