PCU หายไปไหน

งานเข้าเลยครับ User แจ้งว่า เพิ่มข้อมูลการเยี่ยมบ้าน การให้บริการวัคซีน ดูแลก่อนและหลังคลอดไม่ได้ เกิดการบันทึกข้อมูลผิดพลาด เข้าไปดูใน database ก็พบว่า ตารางต่าง ๆ ที่เกี่ยวข้องกับ PCU พวก x_Health _x ต่าง ๆ อยู่ครบ แต่ข้อมูลในตารางไม่มีอยู่เลย เป็นตารางเปล่า ๆ หมดเลย 

     [java]     at javax.swing.DefaultButtonModel.setPressed(Unknown Source)
     [java]     at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(Unkn
own Source)
     [java] public void setStatus(String str, int status) การบันทึกข้อมูลผิดพลาด

      ลอง copy  x_Health _x ข้อมูลจาก backup มาก็ยังใช้งานไม่ได้ สงสัยไม่ได้เป็นที่ ตารางและข้อมูลในตารางแน่ ๆ ต้องมีอะไรมากกว่านั้น ลองเปลี่ยนไปใช้ database จากเครื่อง Mirror  กลับทำงานได้ปกติ ผมก็เลยลองเทียบ Schema ดู

พบว่า ตัว database เครื่อง Master Schema ที่เกี่ยวข้องกับ x_Health _x  หายไปหมดเลย ทั้ง ตาราง b  f  t  หายเรียบ ยังหาสาเหตุการเกิดไม่ได้ คาดว่าอาจเกิดจากการ update patch ใด patch หนึ่งก็ได้ 

 

วิธีแก้ สำหรับโรงพยาบาลใดที่อาจเจอปัญหาแบบผม ส่วนสาเหตุที่เกิดยังหาไม่เจอ ต้องรอ ทีมงานต่อไป

copy ตารางที่ข้อมูลหายมาใส่ 
DROP SEQUENCE public.t_health_home_home_serial_seq;

create  sequence ให้เท่ากับจำนวนข้อมูลในตาราง
CREATE  SEQUENCE public.t_health_home_home_serial_seq INCREMENT 1 MINVALUE 1 MAXVALUE 9223372036854775807 START 1296 CACHE 1;

แล้ว Run SQL ตัวด้านล่างนี้ รับรองใช้ได้ตามปกติ  (ของผมทำ Mirror ด้วยนะ ถ้าใครไม่ใช้ mirror ก็ ลบส่วนที่เป็น CREATE TRIGGER ออก)

/* ---------------------------------------------------------------------- */
/* Script  DB Schema                                                */
/* Author:                     bansang hospital                          */
/* Script type:           Alter database script                           */
/* Created on:            2009-04-29 00:53                                */
/* ---------------------------------------------------------------------- */

 

/* ---------------------------------------------------------------------- */
/* Modify table "b_health_epi_group"                                      */
/* ---------------------------------------------------------------------- */

ALTER TABLE public.b_health_epi_group ADD CONSTRAINT b_health_epi_group_pkey
    PRIMARY KEY (b_health_epi_group_id);

/* ---------------------------------------------------------------------- */
/* Modify table "b_health_epi_item"                                       */
/* ---------------------------------------------------------------------- */

ALTER TABLE public.b_health_epi_item ADD CONSTRAINT b_health_epi_item_pkey
    PRIMARY KEY (b_health_epi_item_id);

/* ---------------------------------------------------------------------- */
/* Modify table "b_health_epi_item_drug_setup"                            */
/* ---------------------------------------------------------------------- */

ALTER TABLE public.b_health_epi_item_drug_setup ADD CONSTRAINT b_health_epi_item_drug_setup_pkey
    PRIMARY KEY (b_health_epi_item_drug_setup_id);

/* ---------------------------------------------------------------------- */
/* Modify table "f_health_anc_section"                                    */
/* ---------------------------------------------------------------------- */

ALTER TABLE public.f_health_anc_section ADD CONSTRAINT f_health_anc_section_pkey
    PRIMARY KEY (f_health_anc_section_id);

 

/* ---------------------------------------------------------------------- */
/* Modify table "f_health_family_planing"                                 */
/* ---------------------------------------------------------------------- */

ALTER TABLE public.f_health_family_planing ADD CONSTRAINT f_health_family_planing_pkey
    PRIMARY KEY (f_health_family_planing_id);

/* ---------------------------------------------------------------------- */
/* Modify table "f_health_family_planing_method"                          */
/* ---------------------------------------------------------------------- */

ALTER TABLE public.f_health_family_planing_method ADD CONSTRAINT f_health_family_planing_method_pkey
    PRIMARY KEY (f_health_family_planing_method_id);

/* ---------------------------------------------------------------------- */
/* Modify table "f_health_home_charactor"                                 */
/* ---------------------------------------------------------------------- */

ALTER TABLE public.f_health_home_charactor ADD CONSTRAINT f_health_home_charactor_pkey
    PRIMARY KEY (f_health_home_charactor_id);

/* ---------------------------------------------------------------------- */
/* Modify table "f_health_home_community_charac"                          */
/* ---------------------------------------------------------------------- */

ALTER TABLE public.f_health_home_community_charac ADD CONSTRAINT f_health_home_community_charac_pkey
    PRIMARY KEY (f_health_home_community_charac_id);

/* ---------------------------------------------------------------------- */
/* Modify table "f_health_home_garbage_method"                            */
/* ---------------------------------------------------------------------- */

ALTER TABLE public.f_health_home_garbage_method ADD CONSTRAINT f_health_home_garbage_method_pkey
    PRIMARY KEY (f_health_home_garbage_method_id);

/* ---------------------------------------------------------------------- */
/* Modify table "f_health_home_water_type"                                */
/* ---------------------------------------------------------------------- */

ALTER TABLE public.f_health_home_water_type ADD CONSTRAINT f_health_home_water_type_pkey
    PRIMARY KEY (f_health_home_water_type_id);

/* ---------------------------------------------------------------------- */
/* Modify table "f_health_postpartum_birth_place"                         */
/* ---------------------------------------------------------------------- */

ALTER TABLE public.f_health_postpartum_birth_place ADD CONSTRAINT f_health_postpartum_birth_place_pkey
    PRIMARY KEY (f_health_postpartum_birth_place_id);

/* ---------------------------------------------------------------------- */
/* Modify table "f_health_postpartum_episiotomy_type"                     */
/* ---------------------------------------------------------------------- */

ALTER TABLE public.f_health_postpartum_episiotomy_type ADD CONSTRAINT f_health_postpartum_episiotomy_type_pkey
    PRIMARY KEY (f_health_postpartum_episiotomy_type_id);

/* ---------------------------------------------------------------------- */
/* Modify table "f_health_postpartum_givebirth_result"                    */
/* ---------------------------------------------------------------------- */

ALTER TABLE public.f_health_postpartum_givebirth_result ADD CONSTRAINT f_health_postpartum_givebirth_result_pkey
    PRIMARY KEY (f_health_postpartum_givebirth_result_id);

/* ---------------------------------------------------------------------- */
/* Modify table "f_health_postpartum_status_result"                       */
/* ---------------------------------------------------------------------- */

ALTER TABLE public.f_health_postpartum_status_result ADD CONSTRAINT f_health_postpartum_status_result_pkey
    PRIMARY KEY (f_health_postpartum_status_result_id);

/* ---------------------------------------------------------------------- */
/* Modify table "f_health_pregnancy_birth_doctor_type"                    */
/* ---------------------------------------------------------------------- */

ALTER TABLE public.f_health_pregnancy_birth_doctor_type ADD CONSTRAINT f_health_pregnancy_birth_doctor_type_pkey
    PRIMARY KEY (f_health_pregnancy_birth_doctor_type_id);

/* ---------------------------------------------------------------------- */
/* Modify table "f_health_pregnancy_birth_high_risk"                      */
/* ---------------------------------------------------------------------- */

ALTER TABLE public.f_health_pregnancy_birth_high_risk ADD CONSTRAINT f_health_pregnancy_birth_high_risk_pkey
    PRIMARY KEY (f_health_pregnancy_birth_high_risk_id);

/* ---------------------------------------------------------------------- */
/* Modify table "f_health_pregnancy_conduct"                              */
/* ---------------------------------------------------------------------- */

ALTER TABLE public.f_health_pregnancy_conduct ADD CONSTRAINT f_health_pregnancy_conduct_pkey
    PRIMARY KEY (f_health_pregnancy_conduct_id);

/* ---------------------------------------------------------------------- */
/* Modify table "f_health_pregnancy_posture_baby_status"                  */
/* ---------------------------------------------------------------------- */

ALTER TABLE public.f_health_pregnancy_posture_baby_status ADD CONSTRAINT f_health_pregnancy_posture_baby_status_pkey
    PRIMARY KEY (f_health_pregnancy_posture_baby_status_id);

/* ---------------------------------------------------------------------- */
/* Modify table "f_health_pregnancy_pregnant_level"                       */
/* ---------------------------------------------------------------------- */

ALTER TABLE public.f_health_pregnancy_pregnant_level ADD CONSTRAINT f_health_pregnancy_pregnant_level_pkey
    PRIMARY KEY (f_health_pregnancy_pregnant_level_id);

/* ---------------------------------------------------------------------- */
/* Modify table "f_health_pregnancy_uterus_level"                         */
/* ---------------------------------------------------------------------- */

ALTER TABLE public.f_health_pregnancy_uterus_level ADD CONSTRAINT f_health_pregnancy_uterus_level_pkey
    PRIMARY KEY (f_health_pregnancy_uterus_level_id);

 

/* ---------------------------------------------------------------------- */
/* Modify table "f_patient_religion"                                      */
/* ---------------------------------------------------------------------- */

ALTER TABLE public.f_patient_religion ADD CONSTRAINT f_patient_religion_pkey
    PRIMARY KEY (f_patient_religion_id);

 

/* ---------------------------------------------------------------------- */
/* Modify table "t_health_check_healthy"                                  */
/* ---------------------------------------------------------------------- */

ALTER TABLE public.t_health_check_healthy DROP CONSTRAINT t_health_check_healthy_pkey;

ALTER TABLE public.t_health_check_healthy ADD CONSTRAINT t_health_check_healthy_id_pk
    PRIMARY KEY (t_health_check_healthy_id);

/* ---------------------------------------------------------------------- */
/* Modify table "t_health_delivery"                                       */
/* ---------------------------------------------------------------------- */

ALTER TABLE public.t_health_delivery ADD
    t_health_family_id CHARACTER VARYING(255) DEFAULT '''''::character varying';

ALTER TABLE public.t_health_delivery ADD
    health_delivery_survey_date CHARACTER VARYING(255) DEFAULT '''''::character varying';

ALTER TABLE public.t_health_delivery ADD CONSTRAINT t_health_delivery_pkey
    PRIMARY KEY (t_health_delivery_id);

CREATE INDEX delivery_visit_id ON public.t_health_delivery (t_visit_id);

CREATE UNIQUE INDEX delivery_primary_key ON public.t_health_delivery (t_health_delivery_id);

CREATE INDEX delivery_patient_id ON public.t_health_delivery (t_patient_id);

CREATE INDEX delivery_icd10_id ON public.t_health_delivery (b_icd10_id);

CREATE INDEX delivery_family_id ON public.t_health_delivery (t_health_family_id);

 

/* ---------------------------------------------------------------------- */
/* Modify table "t_health_family_planing"                                 */
/* ---------------------------------------------------------------------- */

ALTER TABLE public.t_health_family_planing ADD
    t_health_family_id CHARACTER VARYING(255) DEFAULT '''''::character varying';

ALTER TABLE public.t_health_family_planing ADD
    health_family_planing_date CHARACTER VARYING(255) DEFAULT '''''::character varying';

ALTER TABLE public.t_health_family_planing ADD
    health_family_planing_cervix_method CHARACTER VARYING(255) DEFAULT '''''::character varying';

ALTER TABLE public.t_health_family_planing ADD CONSTRAINT t_health_family_planing_pkey
    PRIMARY KEY (t_health_family_planing_id);

CREATE INDEX family_planing_visit_id ON public.t_health_family_planing (t_visit_id);

CREATE UNIQUE INDEX family_planing_primary_key ON public.t_health_family_planing (t_health_family_planing_id);

CREATE INDEX family_planing_patient_id ON public.t_health_family_planing (t_patient_id);

CREATE INDEX family_planing_family_id ON public.t_health_family_planing (t_health_family_id);

/* ---------------------------------------------------------------------- */
/* Modify table "t_health_home"                                           */
/* ---------------------------------------------------------------------- */

ALTER TABLE public.t_health_home DROP CONSTRAINT t_health_home_pkey1;

ALTER TABLE public.t_health_home ADD CONSTRAINT temp_home_pkey
    PRIMARY KEY (t_health_home_id);

/* ---------------------------------------------------------------------- */
/* Modify table "t_health_postpartum"                                     */
/* ---------------------------------------------------------------------- */

ALTER TABLE public.t_health_postpartum ADD
    t_health_family_id CHARACTER VARYING(255) DEFAULT '''''::character varying';

ALTER TABLE public.t_health_postpartum ADD
    postpartum_survey_date CHARACTER VARYING(255) DEFAULT '''''::character varying';

ALTER TABLE public.t_health_postpartum ADD CONSTRAINT t_health_postpartum_pkey
    PRIMARY KEY (t_health_postpartum_id);

CREATE INDEX postpartum_visit_id ON public.t_health_postpartum (t_visit_id);

CREATE UNIQUE INDEX postpartum_primary_key ON public.t_health_postpartum (t_health_postpartum_id);

CREATE INDEX postpartum_patient_id ON public.t_health_postpartum (t_patient_id);

CREATE INDEX postpartum_family_id ON public.t_health_postpartum (t_health_family_id);

CREATE INDEX postpartum_delivery_id ON public.t_health_postpartum (t_health_delivery_id);

/* ---------------------------------------------------------------------- */
/* Modify table "t_health_pp"                                             */
/* ---------------------------------------------------------------------- */

ALTER TABLE public.t_health_pp ADD
    t_health_family_id CHARACTER VARYING(255) DEFAULT '''''::character varying';

ALTER TABLE public.t_health_pp ADD
    pp_survey_date CHARACTER VARYING(255) DEFAULT '''''::character varying';

ALTER TABLE public.t_health_pp ADD CONSTRAINT t_health_pp_pkey
    PRIMARY KEY (t_health_pp_id);

CREATE INDEX pp_visit_id ON public.t_health_pp (t_visit_id);

CREATE UNIQUE INDEX pp_primary_key ON public.t_health_pp (t_health_pp_id);

CREATE INDEX pp_patient_id ON public.t_health_pp (t_patient_id);

CREATE INDEX pp_family_id ON public.t_health_pp (t_health_family_id);

 

/* ---------------------------------------------------------------------- */
/* Repair/add triggers                                                    */
/* ---------------------------------------------------------------------- */

CREATE TRIGGER "b_health_epi_item_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.b_health_epi_item FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "b_health_epi_item_drug_setup_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.b_health_epi_item_drug_setup FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_health_anc_section_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_health_anc_section FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_health_behav_accident_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_health_behav_accident FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_health_behav_alcohol_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_health_behav_alcohol FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_health_behav_ciga_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_health_behav_ciga FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_health_behav_drug_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_health_behav_drug FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_health_behav_eat_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_health_behav_eat FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_health_behav_hx_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_health_behav_hx FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_health_behav_mood_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_health_behav_mood FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_health_behav_p_type_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_health_behav_p_type FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_health_behav_sexbeh_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_health_behav_sexbeh FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_health_behav_sexprotect_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_health_behav_sexprotect FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_health_behav_strain_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_health_behav_strain FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_health_exercise_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_health_exercise FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_health_family_planing_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_health_family_planing FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_health_family_planing_method_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_health_family_planing_method FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_health_home_charactor_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_health_home_charactor FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_health_home_community_charac_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_health_home_community_charac FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_health_home_garbage_method_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_health_home_garbage_method FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_health_home_water_type_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_health_home_water_type FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_health_is_join_agr_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_health_is_join_agr FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_health_postpartum_birth_place_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_health_postpartum_birth_place FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_health_postpartum_episiotomy_type_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_health_postpartum_episiotomy_type FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_health_postpartum_givebirth_result_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_health_postpartum_givebirth_result FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_health_postpartum_status_result_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_health_postpartum_status_result FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_health_pregnancy_birth_doctor_type_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_health_pregnancy_birth_doctor_type FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_health_pregnancy_birth_high_risk_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_health_pregnancy_birth_high_risk FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_health_pregnancy_conduct_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_health_pregnancy_conduct FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_health_pregnancy_posture_baby_status_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_health_pregnancy_posture_baby_status FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_health_pregnancy_pregnant_level_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_health_pregnancy_pregnant_level FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_health_pregnancy_uterus_level_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_health_pregnancy_uterus_level FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_health_reason_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_health_reason FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_health_result_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_health_result FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_health_work_place_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_health_work_place FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "f_patient_religion_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.f_patient_religion FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "t_health_anc_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.t_health_anc FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "t_health_anc_detail_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.t_health_anc_detail FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "t_health_behavior_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.t_health_behavior FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "t_health_check_health_year_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.t_health_check_health_year FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "t_health_check_healthy_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.t_health_check_healthy FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "t_health_delivery_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.t_health_delivery FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "t_health_diabetes_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.t_health_diabetes FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "t_health_elder_agr_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.t_health_elder_agr FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "t_health_epi_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.t_health_epi FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "t_health_epi_detail_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.t_health_epi_detail FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "t_health_exercise_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.t_health_exercise FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "t_health_family_planing_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.t_health_family_planing FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "t_health_home_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.t_health_home FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "t_health_postpartum_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.t_health_postpartum FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "t_health_pp_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.t_health_pp FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "t_health_pregnancy_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.t_health_pregnancy FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "t_health_pressure_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.t_health_pressure FOR EACH ROW EXECUTE PROCEDURE recordchange();

CREATE TRIGGER "t_health_to_be_Trig" AFTER INSERT OR DELETE OR UPDATE ON public.t_health_to_be FOR EACH ROW EXECUTE PROCEDURE recordchange();