กำลังทดสอบ แต่สั่งผมไม่ดี พรุ่งนี้จะไปให้แพทย์ ร้องเพลง ทดสอบดูครับ
[code=sql]
Upgrade MySQL Done.
End at 22/10/2553 18:21:41
Checking Serial Number
Import data to village_drug_store_type
Import data to village_agri_group_type
Import data to test
Import data to student_regulation
Import data to rpt_504_code
Import data to risk_taste_type
Import data to risk_smoking_type
Import data to risk_screen_sso_company
Import data to risk_screen_relation_type
Import data to risk_screen_ofc_desc_mins
Import data to risk_screen_ofc_desc_dept
Import data to risk_screen_age
Import data to risk_pttype
Import data to risk_pmh_choice
Import data to risk_pmh
Import data to risk_perform
Import data to risk_lab_type
Import data to risk_is_smoking
Import data to risk_exercise_type
Import data to risk_drive_type
Import data to risk_drink_type
Import data to risk_doctor_opinion_type
Import data to risk_condom_type
Import data to risk_comment_type
Import data to risk_clinic_doctor
Import data to risk_clinic
Import data to paidst
Import data to operation_status
Import data to micnp_resultdata
Import data to micnp_reasondata
Import data to micnp_problemdata
Import data to micnp_plandata
Import data to micnp
Import data to mantenance_service
Import data to income_report2
Import data to income_group
Import data to hosxp_error_message
Import data to hospital_volunteer_position
Import data to hospital_volunteer_observe_location
Import data to hospital_volunteer_expert_type
Import data to hospital_volunteer_excellent_type
Import data to hospital_speciality
Import data to hospital_service_type
Import data to hospital_person_status
Import data to hospital_person_position
Import data to hospital_person_field
Import data to hospital_person_employment_type
Import data to hospital_person_education
Import data to hospital_owner_type
Import data to hospital_observe_location
Import data to hospital_executive_position
Import data to er_accident_type
Import data to entity_code
Import data to dttm_dw_report_group
Import data to dental_report
Import data to dcplan
Import data to book_tooffice
Refresh base data
Update s_drugitems
Checking full_name in thaiaddress
Check income.drg_group
Check System Report
Check ICD9CM1
Check invalid referout
Check Upgrade allergy cid
Check Upgrade Clinicmember subtype
Check patient prename
Check Invalid Data
create index ix_village_id on village_news_tower (village_id)
alter ignore table village_drug_store_type add unique index ix_village_drug_store_type_name (village_drug_store_type_name)
create index ix_village_drug_store_id on village_drug_store_picture (village_drug_store_id)
create index ix_village_id on village_drug_store (village_id)
create index ix_village_id on village_basis_health_center (village_id)
create index ix_village_id on village_basis_doctor (village_id)
create index ix_md4 on tmp_dw_guid_ovst_seq (md4)
create index ix_md3 on tmp_dw_guid_ovst_seq (md3)
create index ix_md2 on tmp_dw_guid_ovst_seq (md2)
create index ix_md1 on tmp_dw_guid_ovst_seq (md1)
create index ix_village_student_screen_id on student_regulation_check (village_student_screen_id)
alter ignore table student_regulation add unique index ix_student_regulation_name (student_regulation_name)
alter ignore table rx_operator add unique index ix_vn_login_unique (vn,login)
create index ix_vn on rx_operator (vn)
create index ix_order_date on rx_operator (order_date)
alter ignore table psychia_member_type add unique index ix_unique (hn,psychia_type_id)
create index ix_person_health_club_bmi_summary_id on person_health_club_bmi (person_health_club_bmi_summary_id)
create index ix_hn on patient_allergy_pcu_screen (hn)
create index ix_cid on patient_allergy_pcu_screen (cid)
create index ix_icode on medication_voice (icode)
alter ignore table hospital_volunteer_position add unique index ix_hospital_volunteer_position_name (hospital_volunteer_position_name)
create index ix_hospital_volunteer_id on hospital_volunteer_picture (hospital_volunteer_id)
create index ix_hospital_volunteer_observe_activity_class_id on hospital_volunteer_observe_member (hospital_volunteer_observe_activity_class_id)
alter ignore table hospital_volunteer_observe_location add unique index ix_hospital_volunteer_observe_location_name (hospital_volunteer_observe_location_name)
create index ix_hospital_volunteer_observe_activity_id on hospital_volunteer_observe_activity_class (hospital_volunteer_observe_activity_id)
alter ignore table hospital_volunteer_expert_type add unique index ix_hospital_volunteer_expert_type_name (hospital_volunteer_expert_type_name)
create index ix_hospital_volunteer_id on hospital_volunteer_expert (hospital_volunteer_id)
alter ignore table hospital_volunteer_excellent_type add unique index ix_hospital_volunteer_excellent_type_name (hospital_volunteer_excellent_type_name)
create index ix_hospital_volunteer_id on hospital_volunteer_excellent (hospital_volunteer_id)
create index ix_hospital_profile_id on hospital_speciality_detail (hospital_profile_id)
alter ignore table hospital_speciality add unique index ix_hospital_speciality_name (hospital_speciality_name)
alter ignore table hospital_service_type add unique index ix_hospital_service_type_name (hospital_service_type_name)
alter ignore table hospital_person_status add unique index ix_hospital_person_status_name (hospital_person_status_name)
alter ignore table hospital_person_position add unique index ix_hospital_person_position_name (hospital_person_position_name)
create index ix_hospital_person_id on hospital_person_picture (hospital_person_id)
alter ignore table hospital_person_field add unique index ix_hospital_person_field_name (hospital_person_field_name)
alter ignore table hospital_person_employment_type add unique index ix_hospital_person_employment_type_name (hospital_person_employment_type_name)
alter ignore table hospital_person_education add unique index ix_hospital_person_education_name (hospital_person_education_name)
alter ignore table hospital_owner_type add unique index ix_hospital_owner_type_name (hospital_owner_type_name)
alter ignore table hospital_observe_location add unique index ix_hospital_observe_location_name (hospital_observe_location_name)
create index ix_hospital_observe_activity_id on hospital_observe_activity_prominent (hospital_observe_activity_id)
create index ix_hospital_observe_activity_class_id on hospital_observe_activity_member (hospital_observe_activity_class_id)
create index ix_hospital_observe_activity_id on hospital_observe_activity_class (hospital_observe_activity_id)
alter ignore table hospital_executive_position add unique index ix_hospital_executive_position_name (hospital_executive_position_name)
alter ignore table health_med_operation_item_organ add unique index ix_unique (health_med_operation_item_organ_id,health_med_operation_item_id,health_med_operation_type_id)
alter ignore table dttm_dw_report_group add unique index ix_dttm_dw_report_group_name (dttm_dw_report_group_name)
create index ix_dtmain_id on dtmain_report (dtmain_id)
alter ignore table datadictionary add unique index ix_fieldname_tablename_unique (fieldname,tablename)
create index ix_subtype on clinic_subtype (subtype)
create index ix_name on clinic_subtype (name)
create index ix_clinic on clinic_subtype (clinic)
create index ix_node_id on clinicmember (node_id)
create index ix_hn on clinicmember (hn)
create index ix_doctor on clinicmember (doctor)
create index ix_clinic on clinicmember (clinic)
Index not found : village_news_tower.ix_village_id (village_id)
Index not found : village_drug_store_type.village_drug_store_type_name (village_drug_store_type_name)
Index not found : village_drug_store_picture.ix_village_drug_store_id (village_drug_store_id)
Index not found : village_drug_store.ix_village_id (village_id)
Index not found : village_basis_health_center.ix_village_id (village_id)
Index not found : village_basis_doctor.ix_village_id (village_id)
Index not found : tmp_dw_guid_ovst_seq.ix_md4 (md4)
Index not found : tmp_dw_guid_ovst_seq.ix_md3 (md3)
Index not found : tmp_dw_guid_ovst_seq.ix_md2 (md2)
Index not found : tmp_dw_guid_ovst_seq.ix_md1 (md1)
Index not found : student_regulation_check.ix_village_student_screen_id (village_student_screen_id)
Index not found : student_regulation.student_regulation_name (student_regulation_name)
Index not found : rx_operator.ix_vn_login_unique (vn,login)
Index not found : rx_operator.ix_vn (vn)
Index not found : rx_operator.ix_order_date (order_date)
Index not found : psychia_member_type.ix_unique (hn,psychia_type_id)
Index not found : person_health_club_bmi.ix_person_health_club_bmi_summary_id (person_health_club_bmi_summary_id)
Index not found : person.ix_inregion (in_region)
Index not found : patient_allergy_pcu_screen.ix_hn (hn)
Index not found : patient_allergy_pcu_screen.ix_cid (cid)
Index not found : medication_voice.ix_icode (icode)
Index not found : hospital_volunteer_position.hospital_volunteer_position_name (hospital_volunteer_position_name)
Index not found : hospital_volunteer_picture.ix_hospital_volunteer_id (hospital_volunteer_id)
Index not found : hospital_volunteer_observe_member.ix_hospital_volunteer_observe_activity_class_id (hospital_volunteer_observe_activity_class_id)
Index not found : hospital_volunteer_observe_location.hospital_volunteer_observe_location_name (hospital_volunteer_observe_location_name)
Index not found : hospital_volunteer_observe_activity_class.ix_hospital_volunteer_observe_activity_id (hospital_volunteer_observe_activity_id)
Index not found : hospital_volunteer_expert_type.hospital_volunteer_expert_type_name (hospital_volunteer_expert_type_name)
Index not found : hospital_volunteer_expert.ix_hospital_volunteer_id (hospital_volunteer_id)
Index not found : hospital_volunteer_excellent_type.hospital_volunteer_excellent_type_name (hospital_volunteer_excellent_type_name)
Index not found : hospital_volunteer_excellent.ix_hospital_volunteer_id (hospital_volunteer_id)
Index not found : hospital_speciality_detail.ix_hospital_profile_id (hospital_profile_id)
Index not found : hospital_speciality.hospital_speciality_name (hospital_speciality_name)
Index not found : hospital_service_type.hospital_service_type_name (hospital_service_type_name)
Index not found : hospital_person_status.hospital_person_status_name (hospital_person_status_name)
Index not found : hospital_person_position.hospital_person_position_name (hospital_person_position_name)
Index not found : hospital_person_picture.ix_hospital_person_id (hospital_person_id)
Index not found : hospital_person_field.hospital_person_field_name (hospital_person_field_name)
Index not found : hospital_person_employment_type.hospital_person_employment_type_name (hospital_person_employment_type_name)
Index not found : hospital_person_education.hospital_person_education_name (hospital_person_education_name)
Index not found : hospital_owner_type.hospital_owner_type_name (hospital_owner_type_name)
Index not found : hospital_observe_location.hospital_observe_location_name (hospital_observe_location_name)
Index not found : hospital_observe_activity_prominent.ix_hospital_observe_activity_id (hospital_observe_activity_id)
Index not found : hospital_observe_activity_member.ix_hospital_observe_activity_class_id (hospital_observe_activity_class_id)
Index not found : hospital_observe_activity_class.ix_hospital_observe_activity_id (hospital_observe_activity_id)
Index not found : hospital_executive_position.hospital_executive_position_name (hospital_executive_position_name)
Index not found : health_med_operation_item_organ.ix_unique (health_med_operation_item_organ_id,health_med_operation_item_id,health_med_operation_type_id)
Index not found : dttm_dw_report_group.dttm_dw_report_group_name (dttm_dw_report_group_name)
Index not found : dtmain_report.ix_dtmain_id (dtmain_id)
Index not found : datadictionary.ix_fieldname_tablename_unique (fieldname,tablename)
Index not found : clinic_subtype.subtype (subtype)
Index not found : clinic_subtype.name (name)
Index not found : clinic_subtype.clinic (clinic)
Index not found : clinicmember.ix_node_id (node_id)
Index not found : clinicmember.ix_hn (hn)
Index not found : clinicmember.ix_doctor (doctor)
Index not found : clinicmember.ix_clinic (clinic)
xrayxn.xn ("xn") unique = N
xrayxn.regdate ("regdate") unique = N
xrayxn.hn ("hn") unique = N
xray_type_film.xray_type ("xray_type") unique = N
xray_type.ix_name ("name") unique = N
xray_type.ix_xray_items_code ("xray_items_code") unique = N
xray_time_type.ix_xray_time_type_name ("xray_time_type_name") unique = Y
xray_template.template_name ("template_name") unique = Y
xray_status.ix_xray_status_name ("xray_status_name") unique = Y
xray_side.ix_name ("name") unique = N
xray_service_charge.ix_opi_guid ("opi_guid") unique = Y
xray_room.ix_name ("name") unique = N
xray_report_type.xn ("xn") unique = N
xray_report_film.xn ("xn") unique = N
xray_report.ix_opiguid ("opitemrece_guid") unique = N
xray_report.ix_ix_vn ("vn") unique = N
xray_report.ix_ix_request_date ("request_date") unique = N
xray_report.ix_ix_report_date ("report_date") unique = N
xray_report.ix_ix_hn ("hn") unique = N
xray_report.ix_ix_an ("an") unique = N
xray_rent_type.ix_xray_rent_type_name ("xray_rent_type_name") unique = Y
xray_rent_status.ix_xray_rent_status_name ("xray_rent_status_name") unique = Y
xray_rent_department.ix_xray_rent_department_name ("xray_rent_department_name") unique = Y
xray_rent.ix_xrayxnid ("xrayxn_id") unique = N
xray_rent.xn ("xn") unique = N
xray_rent.rent_date ("rent_date") unique = N
xray_rent.hn ("hn") unique = N
xray_rent.checkin ("checkin") unique = N
xray_pt_status.ix_name ("name") unique = N
xray_priority.ix_name ("priority_name") unique = N
xray_pack.ix_xn ("xray_report_xn") unique = N
xray_order.xray_order_number ("xray_order_number") unique = N
xray_keeper.ix_xray_keeper_name ("xray_keeper_name") unique = Y
xray_items_doctor.ix_xray_items_code ("xray_items_code") unique = N
xray_items_doctor.ix_unique ("xray_items_code","doctor") unique = Y
xray_items.xray_items_name ("xray_items_name") unique = N
xray_head.ix_order_date ("order_date") unique = N
xray_head.ix_confirm_report ("confirm_report") unique = N
xray_head.ix_order_date_time ("order_date_time") unique = N
xray_head.vn_unique ("vn") unique = N
xray_head.hn ("hn") unique = N
xray_head.ix_xray_order_number_unique ("xray_order_number") unique = Y
xray_film_staff.ix_xn ("xn") unique = N
xray_film.ix_filmname ("film_name") unique = N
xray_contrast_media_use.ix_xn ("xn") unique = N
xray_contrast_media.ix_xray_contrast_media_name ("xray_contrast_media_name") unique = Y
xray_class_xn.ix_xray_xn ("xray_xn") unique = N
xray_class_xn.ix_hn ("hn") unique = N
xray_class_rent.ix_pt_class_xn ("pt_class_xn") unique = N
xray_class_rent.ix_return_complete ("return_complete") unique = N
xray_class_rent.ix_rent_date ("rent_date") unique = N
xray_appointment.ix_xn ("xn") unique = N
women_vaccine.ix_women_vaccine_name ("women_vaccine_name") unique = Y
women_vaccine.ix_vaccine_code ("vaccine_code") unique = Y
women_service.ix_women_service_name ("women_service_name") unique = Y
women_birth_control.ix_women_birth_control_name ("women_birth_control_name") unique = Y
web_var.name_unique ("name") unique = Y
web_session.sbrand_unique ("sbrand") unique = Y
web_board.user ("user") unique = N
web_board.subject ("subject") unique = N
web_board.master_pn ("master_pn") unique = N
web_board.pn_unique ("pn") unique = Y
wbc_vaccine.ix_export_vaccine_code ("export_vaccine_code") unique = N
wbc_vaccine.ix_age_min ("age_min") unique = N
wbc_vaccine.ix_wbc_vaccine_name ("wbc_vaccine_name") unique = Y
wbc_transfer.ix_wbc_transfer_name ("wbc_transfer_name") unique = Y
wbc_service.ix_wbc_service_name ("wbc_service_name") unique = Y
wbc_location_type.ix_wbc_location_type_name ("wbc_location_type_name") unique = Y
wbc_development_assess.ix_wbc_development_assess_name ("wbc_development_assess_name") unique = Y
wbc_breast_feed_type.ix_wbc_breast_feed_type_name ("wbc_breast_feed_type_name") unique = Y
ward.name ("name") unique = N
vn_stat.ym ("ym") unique = N
vn_stat.vstdate ("vstdate") unique = N
vn_stat.pttype ("pttype") unique = N
vn_stat.pcode ("pcode") unique = N
vn_stat.cid ("cid") unique = N
vn_stat.hospsub ("hospsub") unique = N
vn_stat.hospmain ("hospmain") unique = N
vn_stat.hn ("hn") unique = N
vn_lock.ix_lock_date_time ("lock_date_time") unique = N
vn_lock.lock_computer ("lock_computer") unique = N
vital_sign_data.ix_ix_vn ("vn") unique = N
vital_sign_data.ix_ix_hn ("hn") unique = N
vital_sign_data.ix_ix_an ("an") unique = N
visit_type.ix_visit_type_name ("visit_type_name") unique = Y
visit_pttype_change.ix_ix_vn ("vn") unique = N
visit_pttype.vn ("vn") unique = N
visit_pttype.pttype ("pttype") unique = N
visit_protect.ix_vn ("vn") unique = N
visit_protect.ix_unique ("vn","visit_protect_type_id") unique = N
visit_plan.vn ("vn") unique = N
visit_pay_plan.ix_ix_hn_item_expire ("hn","item_expire") unique = N
visit_pay_plan.ix_ix_hn ("hn") unique = N
visit_note_department.vn ("vn") unique = N
visit_note.ix_doctor ("doctor") unique = N
visit_note.ix_dep_name ("dep_name") unique = N
village_water_type.ix_village_water_type_name ("village_water_type_name") unique = Y
village_water.ix_village_water_name ("village_water_name") unique = Y
village_toilet_type.ix_village_toilet_type_name ("village_toilet_type_name") unique = Y
village_toilet_survey_image.ix_village_toilet_survey_id ("village_toilet_survey_id") unique = N
village_toilet_survey.ix_village_toilet_type_id ("village_toilet_type_id") unique = N
village_toilet_survey.ix_village_id ("village_id") unique = N
village_temple_type.ix_village_temple_type_name ("village_temple_type_name") unique = Y
village_temple.ix_village_id ("village_id") unique = N
village_survey_item.ix_item_group ("item_group") unique = N
village_survey_item.ix_unique ("village_survey_item_name") unique = Y
village_survey_detail.ix_village_si ("village_survey_item_id") unique = N
village_survey_detail.ix_village_id ("village_id") unique = N
village_student_vaccine_list.ix_village_student_vaccine_id ("village_student_vaccine_id") unique = N
village_student_vaccine.ix_village_student_id ("village_student_id") unique = N
village_student_screen.ix_vn ("vn") unique = N
village_student_screen.ix_village_student_id ("village_student_id") unique = N
village_student.ix_last_update ("last_update") unique = N
village_student.ix_village_school_id ("village_school_id") unique = N
village_student.ix_person_id_unique_unique_unique_unique_unique_unique ("person_id") unique = Y
village_store_type.ix_village_store_type_name ("village_store_type_name") unique = Y
village_store_training_course.ix_bdg_year ("bdg_year") unique = N
village_store_summary.ix_bdg_year ("bdg_year") unique = Y
village_store_subtype.ix_village_store_subtype_name ("village_store_subtype_name") unique = Y
village_store_picture.ix_village_store_id ("village_store_id") unique = N
village_store_location_type.ix_village_store_location_type_name ("village_store_location_type_name") unique = Y
village_store_food_sample.ix_village_store_id ("village_store_id") unique = N
village_store_food_sample.ix_bdg_year ("bdg_year") unique = N
village_store_cfgt_evaluate.ix_village_store_id ("village_store_id") unique = N
village_store_cfgt_evaluate.ix_bdg_year ("bdg_year") unique = N
village_store.ix_village_store_name ("village_store_name") unique = N
village_store.ix_village_id ("village_id") unique = N
village_school_service_staff.ix_village_school_service_id ("village_school_service_id") unique = N
village_school_class.ix_village_school_class_name ("village_school_class_name") unique = Y
village_school.ix_village_id ("village_id") unique = N
village_priest_type.ix_village_priest_type_name ("village_priest_type_name") unique = Y
village_priest.ix_village_temple_id ("village_temple_id") unique = N
village_priest.ix_unique ("person_id") unique = Y
village_organization_type.ix_village_organization_type_name ("village_organization_type_name") unique = Y
village_organization_member_service.ix_mid ("village_organization_mid") unique = N
village_organization_member.ix_idx ("village_organization_id") unique = N
village_organization_member.ix_id ("person_id") unique = N
village_organization.ix_village_id ("village_id") unique = N
village_nursery.ix_village_nursery_name ("village_nursery_name") unique = Y
village_market_type.ix_village_market_type_name ("village_market_type_name") unique = Y
village_market_standard_type.ix_village_market_standard_type_name ("village_market_standard_type_name") unique = Y
village_map_point.ix_village_id ("village_id") unique = N
village_club_member.ix_village_club_id ("village_club_id") unique = N
village_club_member.ix_person_id ("person_id") unique = N
village_club.ix_village_id ("village_id") unique = N
village_agri_surveillance_member.ix_village_agri_surveillance_id ("village_agri_surveillance_id") unique = N
village_agri_surveillance.ix_agrouptype ("village_agri_group_type_id") unique = N
village_agri_group_type.ix_village_agri_group_type_name ("village_agri_group_type_name") unique = Y
village.ix_village_guid ("village_guid") unique = N
village.ix_village_code ("village_code") unique = N
village.ix_hos_guid ("hos_guid") unique = N
vagina_test_place.ix_vagina_test_place_name ("vagina_test_place_name") unique = Y
vagina_cancer_test.ix_vagina_cancer_test_name ("vagina_cancer_test_name") unique = Y
vagina_cancer_result.ix_vagina_cancer_result_name ("vagina_cancer_result_name") unique = Y
vaccine_lookup.ix_unique ("vaccine_code","lookup_value") unique = Y
vaccine_combination.ix_vaccine_code ("vaccine_code") unique = N
vaccine_combination.ix_unique ("vaccine_code","vaccine_combine_code") unique = Y
universal_item_value_list.ix_universal_item_id ("universal_item_id") unique = N
universal_item_value_list.ix_hos_guid ("hos_guid") unique = N
universal_item_value_list.ix_unique ("universal_item_id","universal_item_value_code") unique = Y
universal_item_class.ix_hos_guid ("hos_guid") unique = N
universal_item_class.ix_universal_item_class_name ("universal_item_class_name") unique = Y
universal_item.ix_universal_item_name ("universal_item_name") unique = N
universal_item.ix_hos_guid ("hos_guid") unique = N
universal_head.ix_key_id ("key_id") unique = N
universal_form_type.ix_universal_form_type_name ("universal_form_type_name") unique = Y
universal_form_design.ix_universal_form_id ("universal_form_id") unique = N
universal_form_design.ix_hos_guid ("hos_guid") unique = N
universal_form_department.ix_universal_form_id ("universal_form_id") unique = N
universal_form_department.ix_unique ("universal_form_id","depcode") unique = Y
universal_form.ix_hos_guid ("hos_guid") unique = N
universal_form.ix_universal_form_name ("universal_form_name") unique = Y
universal_detail_subvalue.ix_universal_detail_id ("universal_detail_id") unique = N
universal_detail.ix_universal_head_id ("universal_head_id") unique = N
tip_trick.tip_id_3_unique_unique_unique_unique ("tip_id") unique = N
tip_trick.tip_id_2_unique_unique_unique_unique ("tip_id") unique = N
tip_trick.tip_id_unique_unique_unique_unique ("tip_id") unique = N
tip_trick.tip_type ("tip_type") unique = N
thalassaemia_result.ix_thalassaemia_result_name ("thalassaemia_result_name") unique = Y
thaiaddress_region.region_code ("region_code") unique = N
thaiaddress.tmbpart ("tmbpart") unique = N
thaiaddress.name ("name") unique = N
thaiaddress.codetype ("codetype") unique = N
thaiaddress.chwpart ("chwpart") unique = N
thaiaddress.amppart ("amppart") unique = N
tempreport.reportname ("reportname") unique = N
tempreport.name ("name") unique = N
tempreport.id ("id") unique = N
tempreport.date1 ("date1") unique = N
tempmanoi_xp2.hn_unique ("hn") unique = Y
tempmanoi_xp1.ix_pttypeno ("pttypeno") unique = N
tempmanoi_xp1.ix_cid ("cid") unique = N
tempmanoi_xp1.ix_pttypeno_pttype_unique ("pttypeno","pttype","hn") unique = Y
tempmanoi_xp1.hn_pttypeno_pttype_unique ("hn","pttypeno","pttype") unique = Y
tempdental1.an_code_unique ("an","code") unique = Y
tempcom41.vn_code_unique ("vn","code") unique = Y
tempblue_command1.an_code_unique ("an","code") unique = Y
tempball1.vn_code_unique ("vn","code") unique = Y
temp421d071.vn_code_unique ("vn","code") unique = Y
temp412b091.vn_code_unique ("vn","code") unique = Y
temp412b051.an_code_unique ("an","code") unique = Y
temp412b031.vn_code_unique ("vn","code") unique = Y
temp412a091.vn_code_unique ("vn","code") unique = Y
temp412a071.vn_code_unique ("vn","code") unique = Y
temp412a061.vn_code_unique ("vn","code") unique = Y
table_stat.ix_tablename ("table_name") unique = N
sys_app_script.script_name ("script_name") unique = N
survey_year_period.ix_survey_year_period_name ("survey_year_period_name") unique = Y
surveil_process_status.ix_surveil_process_status_name ("surveil_process_status_name") unique = Y
surveil_member_log.ix_sv_guid ("sv_guid") unique = Y
surveil_member_dw.ix_vn_guid ("vn_guid") unique = N
surveil_member_dw.ix_vn ("vn") unique = N
surveil_member_dw.ix_sv_number ("sv_number") unique = N
surveil_member_dw.ix_pdx ("pdx") unique = N
surveil_member_dw.ix_hospcode ("hospcode") unique = N
surveil_member_dw.ix_hn_guid ("hn_guid") unique = N
surveil_member.ix_last_update ("last_update") unique = N
surveil_member.ix_sv_guid ("sv_guid") unique = N
surveil_member.vn ("vn") unique = N
surveil_member.pdx ("pdx") unique = N
suicide_screen_question.ix_suicide_screen_question_name ("suicide_screen_question_name") unique = Y
suicide_screen_evaluate.ix_suicide_screen_evaluate_name ("suicide_screen_evaluate_name") unique = Y
suicide_screen_answer.ix_depression_screen_id ("depression_screen_id") unique = N
student_vaccine_place.ix_student_vaccine_place_name ("student_vaccine_place_name") unique = Y
student_vaccine.ix_export_vaccine_code ("export_vaccine_code") unique = N
student_vaccine.ix_vaccine_code ("vaccine_code") unique = Y
student_vaccine.ix_student_vaccine_name ("student_vaccine_name") unique = Y
student_thyroid_result.ix_student_thyroid_result_name ("student_thyroid_result_name") unique = Y
student_thalassemia_check_list.ix_village_student_screen_id ("village_student_screen_id") unique = N
student_thalassemia_check.ix_student_thalassemia_check_name ("student_thalassemia_check_name") unique = Y
student_teeth_result.ix_student_teeth_result_name ("student_teeth_result_name") unique = Y
student_skin_result.ix_student_skin_result_name ("student_skin_result_name") unique = Y
student_self_check_list.ix_village_student_screen_id ("village_student_screen_id") unique = N
student_self_check.ix_student_self_check_name ("student_self_check_name") unique = Y
student_nose_result.ix_student_nose_result_name ("student_nose_result_name") unique = Y
student_neck_result.ix_student_neck_result_name ("student_neck_result_name") unique = Y
student_mouth_result.ix_student_mouth_result_name ("student_mouth_result_name") unique = Y
student_lice_check_list.ix_village_student_screen_id ("village_student_screen_id") unique = N
student_lice_check.ix_student_lice_check_name ("student_lice_check_name") unique = Y
student_hear_result.ix_student_hear_result_name ("student_hear_result_name") unique = Y
student_hct_result.ix_student_hct_result_name ("student_hct_result_name") unique = Y
student_hair_result.ix_student_hair_result_name ("student_hair_result_name") unique = Y
student_eye_result.ix_student_eye_result_name ("student_eye_result_name") unique = Y
student_eye_check_list.ix_village_student_screen_id ("village_student_screen_id") unique = N
student_eye_check.ix_student_eye_check_name ("student_eye_check_name") unique = Y
student_ear_result.ix_student_ear_result_name ("student_ear_result_name") unique = Y
student_ear_check_list.ix_village_student_screen_id ("village_student_screen_id") unique = N
student_ear_check.ix_student_ear_check_name ("student_ear_check_name") unique = Y
student_dental_check_list.ix_village_student_screen_id ("village_student_screen_id") unique = N
student_dental_check.ix_student_dental_check_name ("student_dental_check_name") unique = Y
student_anemia_check_list.ix_village_student_screen_id ("village_student_screen_id") unique = N
student_anemia_check.ix_student_anemia_check_name ("student_anemia_check_name") unique = Y
stock_warehouse_room.ix_warehouse_id ("warehouse_id") unique = N
stock_warehouse_room.ix_warehouse_unique ("warehouse_id","stock_warehouse_room_name") unique = Y
stock_warehouse_check.ix_warehouse_item ("warehouse_id","item_id") unique = N
stock_warehouse_check.ix_warehouse_adj_id ("stock_warehouse_adj_head_id") unique = N
stock_warehouse_check.ix_warehouse ("warehouse_id") unique = N
stock_warehouse_check.ix_itemid ("item_id") unique = N
stock_warehouse_adj_detail.ix_stock_warehouse_adj_detail ("stock_warehouse_adj_head_id") unique = N
stock_user_warehouse.ix_stock_user_idw ("stock_user_id","stock_warehouse_id") unique = N
stock_user_warehouse.ix_stock_user_id ("stock_user_id") unique = N
stock_user_right.ix_unique ("stock_user_id","stock_right_id") unique = Y
stock_user.ix_loginname ("loginname") unique = Y
stock_supplier_type.ix_stock_supplier_type_name ("stock_supplier_type_name") unique = Y
stock_supplier_item.supplier_id ("supplier_id") unique = N
stock_supplier_item.item_id ("item_id") unique = N
stock_supplier_agent_type.ix_stock_supplier_agent_type_name ("stock_supplier_agent_type_name") unique = Y
stock_supplier_agent.supplier_id ("supplier_id") unique = N
stock_supplier.ix_warehouse_id ("warehouse_id") unique = N
stock_supplier.ix_supplier_name ("supplier_name") unique = N
stock_supplier.ix_company_type ("company_type") unique = N
stock_supplier.ix_company_code ("company_code") unique = N
stock_subdraw_type.ix_stock_subdraw_type_name ("stock_subdraw_type_name") unique = Y
stock_subdraw_list.ix_item_id ("item_id") unique = N
stock_subdraw.ix_online_subdraw_id ("online_subdraw_id") unique = N
stock_right.ix_stock_right_name ("stock_right_name") unique = Y
stock_return_list.ix_stock_return_item_id ("stock_return_item_id") unique = N
stock_return_list.ix_stock_draw_list_id ("stock_draw_list_id") unique = N
stock_return_list.ix_item_list_id ("item_list_id") unique = N
stock_return_item.ix_stock_return_id ("stock_return_id") unique = N
stock_return_cutpay_list.ix_stock_draw_list_id ("stock_cutpay_list_id") unique = N
stock_return_cutpay_list.ix_item_list_id ("item_list_id") unique = N
stock_request_committee.ix_stock_request_id ("stock_request_id") unique = N
stock_po_item_type.ix_stock_po_item_type_name ("stock_po_item_type_name") unique = Y
stock_po_detail.ix_stock_po_id ("stock_po_id") unique = N
stock_po_detail.ix_stock_item_unit_id ("stock_item_unit_id") unique = N
stock_po_detail.ix_reference_id ("reference_id") unique = N
stock_po.ix_stock_po_no ("stock_po_no") unique = N
stock_po.ix_stock_po_date ("stock_po_date") unique = N
stock_po.ix_reference_id ("reference_id") unique = N
stock_ovst.staff ("staff") unique = N
stock_ovst.department_id ("department_id") unique = N
stock_ovst.department ("department") unique = N
stock_opitemrece_list.ix_ix_vn ("vn") unique = N
stock_opitemrece_list.ix_ix_hos_guid ("hos_guid") unique = N
stock_opitemrece_err.hos_guid ("hos_guid") unique = N
stock_opitemrece.ix_stock_draw_list_id ("stock_draw_list_id") unique = N
stock_opitemrece.ix_ix_vn ("vn") unique = N
stock_opitemrece.hos_guid ("hos_guid") unique = N
stock_manual_item.ix_stock_manual_id ("stock_manual_id") unique = N
stock_manual_detail.ix_reference_id ("reference_id") unique = N
stock_manual_detail.stock_manual_id ("stock_manual_id") unique = N
stock_manual_detail.stock_draw_list_id ("stock_draw_list_id") unique = N
stock_item_warehouse.warehouse_id ("warehouse_id") unique = N
stock_item_warehouse.item_id ("item_id") unique = N
stock_item_unit.ix_item_id_unit_name ("item_id","item_unit_name") unique = N
stock_item_unit.ix_item_id ("item_id") unique = N
stock_item_unit.ix_unique ("item_id","item_unit_name","unit_qty") unique = Y
stock_item_standard.name ("name") unique = N
stock_item_regist.trade_name ("trade_name") unique = N
stock_item_regist.standard_code ("standard_code") unique = N
stock_item_regist.company_code ("company_code") unique = N
stock_item_picture.ix_item_id ("item_id") unique = N
stock_item_month_rate.ix_item_year_month ("item_year","item_month") unique = N
stock_item_month_rate.ix_item_id ("item_id") unique = N
stock_item_list.ix_stock_po_id ("stock_po_id") unique = N
stock_item_list.ix_item_id ("item_id") unique = N
stock_item_list.ix_deliver_detail_id ("stock_deliver_detail_id") unique = N
stock_item_history.ix_snapshot_period ("snapshot_period") unique = N
stock_item_history.ix_item_id ("item_id") unique = N
stock_item_drugitems.item_id ("item_id") unique = N
stock_item_drugitems.icode ("icode") unique = N
stock_item_cost_type.ix_stock_item_cost_type_name ("stock_item_cost_type_name") unique = Y
stock_item_balance_history.ix_stock_item_unit_id_date ("stock_item_unit_id","balance_date") unique = N
stock_item_balance_history.ix_stock_item_unit_id ("stock_item_unit_id") unique = N
stock_item_balance_history.ix_item_id_balance_date ("item_id","balance_date") unique = N
stock_item_balance_history.ix_date_unitid ("balance_date","stock_item_unit_id") unique = N
stock_item_balance_history.ix_date ("balance_date") unique = N
stock_item_balance_history.ix_balance_year_month ("balance_year","balance_month") unique = N
stock_item_balance_history.ix_unique ("stock_item_unit_id","warehouse_id","balance_date") unique = Y
stock_item.ix_stock_class ("stock_class_id") unique = N
stock_item.ix_oldcode ("oldcode") unique = N
stock_item.ix_costtype ("stock_item_cost_type_id") unique = N
stock_item.ix_barcode_number ("barcode_number") unique = N
stock_item.ix_regno ("standard_code") unique = N
stock_item.ix_item_name ("item_name") unique = N
stock_group_standard.name ("name") unique = N
stock_draw_list.ix_stock_draw_left_qty ("stock_draw_left_qty") unique = N
stock_draw_list.ix_stock_draw_item_id ("stock_draw_item_id") unique = N
stock_draw_list.ix_stock_draw_id ("stock_draw_id") unique = N
stock_draw_list.ix_item_list_id ("item_list_id") unique = N
stock_draw_list.ix_ix_confirm_empty ("confirm_empty") unique = N
stock_draw_item.ix_stock_draw_id ("stock_draw_id") unique = N
stock_draw.ix_stock_sub_draw_id ("stock_subdraw_id") unique = N
stock_draw.ix_stock_draw_no ("stock_draw_no") unique = N
stock_draw.ix_stock_draw_date ("stock_draw_date") unique = N
stock_department_route.ix_route_to_id ("route_to_department_id") unique = N
stock_department_route.ix_icode ("icode") unique = N
stock_department_route.ix_department_id ("department_id") unique = N
stock_department_route.ix_unique ("department_id","icode") unique = Y
stock_department_item_level.ix_item_id ("item_id") unique = N
stock_department_item_level.ix_department_id ("item_id") unique = N
stock_department_item_level.ix_unique ("department_id","item_id") unique = Y
stock_department_item.ix_department_id ("department_id") unique = N
stock_department.ix_oldcode ("oldcode") unique = N
stock_department.ix_department_name ("department_name") unique = N
stock_deliver_detail.ix_stock_po_detail_id ("stock_po_detail_id") unique = N
stock_deliver_detail.ix_stock_deliver_id ("stock_deliver_id") unique = N
stock_deliver.ix_stock_po_id ("stock_po_id") unique = N
stock_deliver.ix_inv_receive_no ("inv_receive_no") unique = N
stock_cutpay_list.ix_stock_cutpay_item_id ("stock_cutpay_item_id") unique = N
stock_cutpay_item.ix_stock_cutpay_id ("stock_cutpay_id") unique = N
stock_cutpay.ix_stock_cutpay_date ("stock_cutpay_date") unique = N
stock_cutpay.ix_reference_id ("reference_id") unique = N
stock_cutpay.ix_cutpaytypeid ("cutpay_type_id") unique = N
stock_committee_position.ix_stock_committee_position_name ("stock_committee_position_name") unique = Y
stock_committee.ix_stock_committee_name ("stock_committee_name") unique = Y
stock_class.ix_oldcode ("oldcode") unique = N
stock_class.ix_stock_class_name ("stock_class_name") unique = Y
stock_card.transaction_date ("transaction_date") unique = N
stock_card.warehouse_id ("warehouse_id") unique = N
stock_card.item_id ("item_id") unique = N
stock_card.inv_no ("inv_no") unique = N
stock_card.inv_name ("inv_name") unique = N
stock_card.expire_date ("expire_date") unique = N
stock_budget.ix_oldcode ("oldcode") unique = N
stock_adjust_item.ix_stock_adj_head_id ("stock_adj_head_id") unique = N
stock_adjust_head.adjust_date ("adjust_date") unique = N
stock_adjust_detail.ix_stock_adjust_item_id ("stock_adjust_item_id") unique = N
stock_adjust_detail.stock_draw_list_id ("stock_draw_list_id") unique = N
stat_queue.id_2 ("id") unique = N
stat_queue.queue_type ("queue_type") unique = N
stat_queue.queue_date_time ("queue_date_time") unique = N
stat_queue.id ("id") unique = N
stat_clinic.old_clinic_unique ("old_clinic") unique = Y
sss_chronic_detail.ix_min_icd ("min_icd") unique = N
sss_chronic_detail.ix_max_icd ("max_icd") unique = N
special_prop_type.ix_special_prop_type_name ("special_prop_type_name") unique = Y
spclty.ix_oldcode ("oldcode") unique = N
spclty.ix_spname ("spname") unique = N
spclty.name ("name") unique = N
sp_use.ix_ix_oldcode ("oldcode") unique = N
sp_use.user ("user") unique = N
sp_use.sp_name ("sp_name") unique = N
sp_use.name1_name3_name2 ("name1","name3","name2") unique = N
social_aid.ix_vn_unique_unique_unique_unique_unique_unique ("vn") unique = Y
sigtoidr.sig_unique ("sig") unique = Y
service_time.vstdate ("vstdate") unique = N
service_time.rx_time_type ("rx_time_type") unique = N
service_time.hn ("hn") unique = N
service_right.pttype ("pttype") unique = N
service_right.icode ("icode") unique = N
service_pay.pttype ("pttype") unique = N
service_pay.icode ("icode") unique = N
scshare.code_unique ("code") unique = Y
screen_doctor.vn ("vn") unique = N
screen_doctor.staff ("staff") unique = N
screen_doctor.vn_staff_unique ("vn","staff") unique = Y
scpay.lnnum ("lnnum") unique = N
scmember.code_unique ("code") unique = Y
scloan.lnmonth ("lnmonth") unique = N
scloan.code ("code") unique = N
scloan.cleared ("cleared") unique = N
scloan.lnnum_unique ("lnnum") unique = Y
school_trimester.ix_school_trimester_name ("school_trimester_name") unique = Y
school_officer_check_list.ix_village_student_screen_id ("village_student_screen_id") unique = N
school_officer_check.ix_school_officer_check_name ("school_officer_check_name") unique = Y
schedule_task.task_user ("task_user") unique = N
schedule_task.task_name ("task_name") unique = N
schedule_task.task_due_date ("task_due_date") unique = N
schedule_task.task_date_time ("task_date_time") unique = N
schedule_task.task_complete ("task_complete") unique = N
schedule.doctor_code ("doctor_code") unique = N
sccredit.credittype_unique ("credittype") unique = Y
sc_pg_presenation.ix_sc_pg_presentation_name ("sc_pg_presentation_name") unique = Y
sc_pg_membrane.ix_sc_pg_membrane_name ("sc_pg_membrane_name") unique = Y
sc_pg_af.ix_sc_pg_af_name ("sc_pg_af_name") unique = Y
s_drugitems.icode ("icode") unique = N
s_drugitems.ix_nsu ("name","strength","units") unique = N
s_drugitems.ix_status ("istatus") unique = N
s_drugitems.ix_access ("access_level") unique = N
s_drugitems.ix_name ("name") unique = N
s_drugitems.ix_unique ("icode") unique = N
rx_summary.ix_rx_date ("rx_date") unique = N
rx_summary.ix_icode ("icode") unique = N
rx_doctor.ix_rxdate ("rx_date") unique = N
rx_doctor.ix_prepare_datetime ("prepare_datetime") unique = N
rx_doctor.ix_depcode ("depcode") unique = N
rx_doctor.ix_ix_rcpt_depcode ("rcpt_depcode") unique = N
rx_doctor.ix_ix_prepare_rx ("prepare_rx") unique = N
rx_doctor.ix_ix_financecheckin ("finance_checkin") unique = N
rx_doctor.vn ("vn") unique = N
rx_doctor.doctor ("doctor") unique = N
roomno.an ("an") unique = N
room_status_type.ix_room_status_type_name ("room_status_type_name") unique = Y
room_reserve_type.ix_room_reserve_type_name ("room_reserve_type_name") unique = Y
room_reserve_status.ix_room_reserve_status_name ("room_reserve_status_name") unique = Y
room_reserve.room_reserve_queue_2 ("room_reserve_queue") unique = N
room_reserve.room_reserve_queue ("room_reserve_queue") unique = N
room_reserve.in_date ("in_date") unique = N
room_reserve.hn ("hn") unique = N
room_reserve.call_date ("call_date") unique = N
room_reserve.an ("an") unique = N
room_reserve.an_hn_unique ("an","hn") unique = Y
room_reserve.unique ("hn","an") unique = Y
risk_report.subject ("subject") unique = N
risk_report.report_date_time ("report_date_time") unique = N
risk_report.department_id ("department_id") unique = N
rfrcs0.rfrcs_unique ("rfrcs") unique = Y
reporttemplate.db ("db") unique = N
report_sks.vn ("vn") unique = N
report_sks.finance_number ("finance_number") unique = N
report_access_rule.ix_username ("user_name") unique = N
report_access_rule.ix_report_name ("report_name") unique = N
report_access_log.loginname ("loginname") unique = N
report_access_log.report_name ("report_name") unique = N
report_access_log.department ("department") unique = N
report_access_log.access_date_time ("access_date_time") unique = N
replicate_trigger.ix_replicate_trigger_tablename ("table_name","pkname1","pkvalue1","sync_state") unique = N
replicate_trigger.ix_order ("sync_priority","replicate_trigger_id") unique = N
replicate_trigger.ix_sync_state ("sync_state") unique = N
replicate_log.event_id_unique ("event_id") unique = Y
replicate_cfg.server_unique ("server") unique = Y
referout_status.ix_referout_status_name ("referout_status_name") unique = Y
referout.ix_refer_date ("refer_date") unique = N
referout.ix_hospcode ("hospcode") unique = N
referin.ix_ix_refer_date ("refer_date") unique = N
referin.ix_ix_hospcode ("hospcode") unique = N
referin.ix_ix_hn ("hn") unique = N
refer_type.ix_refer_type_name ("refer_type_name") unique = Y
refer_response_type.ix_refer_response_type_name ("refer_response_type_name") unique = Y
rcpt_refund.ix_an ("an") unique = N
rcpt_print_detail.ix_fn_income ("finance_number","income") unique = N
rcpt_print_detail.ix_finance_number ("finance_number") unique = N
rcpt_print_detail.vn ("vn") unique = N
rcpt_print_detail.rcpno ("rcpno") unique = N
rcpt_print_detail.income ("income") unique = N
rcpt_print_detail.finance_number ("finance_number") unique = N
rcpt_print.ix_bill_date_time ("bill_date_time") unique = N
rcpt_print.ix_pttype ("pttype") unique = N
rcpt_print.ix_billnumber ("bill_number") unique = N
rcpt_print.ix_booknumber ("book_number") unique = N
rcpt_print.vn ("vn") unique = N
rcpt_print.hn ("hn") unique = N
rcpt_print.rcpno_unique ("rcpno") unique = Y
rcpt_debt_detail.ix_income ("income") unique = N
rcpt_debt_detail.ix_debt_id ("debt_id") unique = N
rcpt_debt_cancel.ix_cancel_staff ("cancel_staff") unique = N
rcpt_debt.ix_ix_debt_date_time ("debt_date_time") unique = N
rcpt_debt.debt_id ("debt_id") unique = N
rcpt_debt.ix_ix_vn ("vn") unique = N
rcpt_debt.ix_finance_number ("finance_number") unique = N
rcpt_debt.ix_debt_id ("debt_id") unique = N
rcpt_current_detail.rcpt_current_id ("rcpt_current_id") unique = N
rcpt_current.vn ("vn") unique = N
rcpt_credit_detail.ix_credit_id ("credit_id") unique = N
rcpt_credit.ix_vn ("vn") unique = N
rcpt_credit.ix_finance_number ("finance_number") unique = N
rcpt_bill_type_detail.ix_rcpt_bill_type_id ("rcpt_bill_type_id") unique = N
rcpt_arrear_detail.ix_arrear_id ("arrear_id") unique = N
rcpt_arrear.ix_ix_vn ("vn") unique = N
rcpt_arrear.ix_ix_arrear_date ("arrear_date") unique = N
rcpt_abort.vn ("vn") unique = N
rcpt_abort.user ("user") unique = N
rcpt_abort.hn ("hn") unique = N
rcpt_abort.approve_by ("approve_by") unique = N
pttypeno.hn ("hn") unique = N
pttypehistory.hn ("hn") unique = N
pttype_spp.ix_pttype_spp_name ("pttype_spp_name") unique = Y
pttype_package_detail.ix_package_id ("pttype_package_id") unique = N
pttype_package.ix_package_name ("package_name") unique = Y
pttype_log.staff ("staff") unique = N
pttype_log.hn ("hn") unique = N
pttype.ix_pttype_spp_id ("pttype_spp_id") unique = N
pttype.ix_pcode ("pcode") unique = N
pttype.ix_ix_hipdata_code ("hipdata_code") unique = N
pttype.name ("name") unique = N
pteroprt.vn ("vn") unique = N
pteroprt.hn_vsttime_ercode_unique ("hn","vsttime","ercode","vstdate","eroprtime") unique = Y
ptdepart.vn ("vn") unique = N
ptdepart.status ("status") unique = N
ptdepart.hn ("hn") unique = N
ptdepart.depcode ("depcode") unique = N
ptcardno.ix_cardno ("cardno") unique = N
ptcardno.hn ("hn") unique = N
ptcardno.cardtype ("cardtype") unique = N
pt_subtype.ix_name ("name") unique = N
pt_medication_history.ix_medication_name ("medication_name") unique = N
pt_medication_history.ix_hn ("hn") unique = N
pt_consult.staff ("staff") unique = N
pt_consult.hn ("hn") unique = N
pt_consult.consult_date ("consult_date") unique = N
psychia_visit_type.ix_vn ("vn") unique = N
psychia_member_type.ix_hn ("hn") unique = N
provis_women.ix_pid ("pid") unique = N
provis_women.ix_export_month ("export_month") unique = N
provis_vdrl_rs.ix_name ("name") unique = Y
provis_vcctype.ix_name ("name") unique = Y
provis_typedis.ix_name ("name") unique = Y
provis_typearea.ix_name ("name") unique = Y
provis_tartar.ix_name ("name") unique = Y
provis_surveil.ix_pid ("pid") unique = N
provis_surveil.ix_export_month ("export_month") unique = N
provis_sex.ix_name ("name") unique = Y
provis_service.ix_seq ("seq") unique = N
provis_service.ix_pid ("pid") unique = N
provis_service.ix_export_month ("export_month") unique = N
provis_religion.ix_name ("name") unique = Y
provis_referout.ix_name ("name") unique = Y
provis_referin.ix_name ("name") unique = Y
provis_race.ix_name ("name") unique = Y
provis_pttype.ix_name ("name") unique = Y
provis_proced.ix_export_month ("export_month") unique = N
provis_pp.ix_pid ("pid") unique = N
provis_pp.ix_export_month ("export_month") unique = N
provis_person.ix_pid ("pid") unique = N
provis_person.ix_export_month ("export_month") unique = N
provis_pdeath.ix_name ("name") unique = Y
provis_organism.ix_name ("name") unique = Y
provis_occupa.ix_name ("name") unique = Y
provis_nutri.ix_pid ("pid") unique = N
provis_nutri.ix_export_month ("export_month") unique = N
provis_nofp.ix_name ("name") unique = Y
provis_nlevel.ix_name ("name") unique = Y
provis_nation.ix_name ("name") unique = Y
provis_mstatus.ix_name ("name") unique = Y
provis_mch.ix_export_month ("export_month") unique = N
provis_locatype.ix_name ("name") unique = Y
provis_locate.ix_name ("name") unique = Y
provis_labor.ix_name ("name") unique = Y
provis_intime.ix_name ("name") unique = Y
provis_instype.ix_name ("name") unique = Y
provis_home.ix_export_month ("export_month") unique = N
provis_fstatus.ix_name ("name") unique = Y
provis_fptype.ix_name ("name") unique = Y
provis_fp.ix_export_month ("export_month") unique = N
provis_epi.ix_pid ("pid") unique = N
provis_epi.ix_export_month ("export_month") unique = N
provis_education.ix_name ("name") unique = Y
provis_drug.ix_export_month ("export_month") unique = N
provis_dischar.ix_name ("name") unique = Y
provis_diagtype.ix_name ("name") unique = Y
provis_diag.ix_seq ("seq") unique = N
provis_diag.ix_export_month ("export_month") unique = N
provis_dental.ix_name ("name") unique = Y
provis_death.ix_export_month ("export_month") unique = N
provis_complica.ix_name ("name") unique = Y
provis_code506.ix_name ("name") unique = Y
provis_chronic.ix_export_month ("export_month") unique = N
provis_card.ix_export_month ("export_month") unique = N
provis_btype.ix_name ("name") unique = Y
provis_bplace.ix_name ("name") unique = Y
provis_bgroup.ix_name ("name") unique = Y
provis_bdoctor.ix_name ("name") unique = Y
provis_bcres.ix_name ("name") unique = Y
provis_asphyxia.ix_name ("name") unique = Y
provis_aptype.ix_name ("name") unique = Y
provis_appoint.ix_export_month ("export_month") unique = N
provis_ancres.ix_name ("name") unique = Y
provis_ancno.ix_name ("name") unique = Y
provis_anc.ix_pid ("pid") unique = N
provis_anc.ix_export_month ("export_month") unique = N
promotion_package.ix_promotion_package_name ("promotion_package_name") unique = Y
printserver_document.ix_printok ("print_ok") unique = N
presetdosageregimen.iname ("iname") unique = N
pregnancy_abort_type.ix_pregnancy_abort_type_name ("pregnancy_abort_type_name") unique = Y
pq_screen.staff ("staff") unique = N
pq_screen.next_dep ("next_dep") unique = N
pq_rxorder.request_time ("request_time") unique = N
pq_rxorder.request_date ("request_date") unique = N
pq_rxorder.print ("print") unique = N
pq_rxorder.hn ("hn") unique = N
pq_opdcard_tag.request_time ("request_time") unique = N
pq_opdcard_tag.request_date ("request_date") unique = N
pq_opdcard_tag.print ("print") unique = N
pq_opdcard.request_time ("request_time") unique = N
pq_opdcard.request_date ("request_date") unique = N
pq_opdcard.print ("print") unique = N
pq_ipdorder.order_no ("order_no") unique = N
pq_ipdorder.order_no_unique_unique ("order_no") unique = N
pq_ipdorder.an ("an") unique = N
pq_ipd_rxorder.request_time ("request_time") unique = N
pq_ipd_rxorder.request_date ("request_date") unique = N
pq_ipd_rxorder.print ("print") unique = N
pq_ipd_rxorder.hn ("hn") unique = N
pq_ipd_rxorder.an ("an") unique = N
pq_doctor.staff ("staff") unique = N
pq_doctor.doctor ("doctor") unique = N
pq_doctor.vn ("vn") unique = N
post_care_screen.ix_post_care_screen_name ("post_care_screen_name") unique = Y
physic_type.ix_physic_type_name ("physic_type_name") unique = Y
physic_main_ipd.ix_vstdate ("vstdate") unique = N
physic_main_ipd.ix_hn ("hn") unique = N
physic_main_ipd.ix_an ("an") unique = N
physic_main.ix_ix_vstdate ("vstdate") unique = N
physic_list_ipd.ix_physic_items_id ("physic_items_id") unique = N
physic_list_ipd.ix_physic_main_ipd_id ("physic_main_ipd_id") unique = N
physic_list.vn ("vn") unique = N
physic_list.physic_items_id ("physic_items_id") unique = N
physic_items.name ("name") unique = N
physic_group_doctor.ix_unique ("physic_group_id","doctor") unique = Y
physic_group.ix_physic_group_name ("physic_group_name") unique = Y
personid.personid_unique ("personid") unique = Y
personcardtime.cardid_readtime_unique ("cardid","readtime") unique = Y
person_women_service.ix_person_women_id ("person_women_id&q
หัวข้อ: HOSxP 3.53.10.19 (อ่าน 25240 ครั้ง)