pg set FK

/*set foren key*/
ALTER TABLE IF EXISTS public.listbrigade
    ADD CONSTRAINT " TypeWork" FOREIGN KEY (typidfk)
    REFERENCES public.listtypework (typidpk) MATCH SIMPLE
    ON UPDATE NO ACTION
    ON DELETE NO ACTION
    NOT VALID;
/*set foren key*/
ALTER TABLE IF EXISTS public.listbrigade
    ADD CONSTRAINT " Employees" FOREIGN KEY (IdPersonFK)
    REFERENCES public. lisrEmployees (IdPersonPK) MATCH SIMPLE
    ON UPDATE NO ACTION
    ON DELETE NO ACTION
    NOT VALID;