CREATE TABLE ctl_usuario_filial
(
    usuario integer NOT NULL,
    filial integer NOT NULL,
    CONSTRAINT pk_ctl_usuario_filial PRIMARY KEY (usuario, filial),
    CONSTRAINT fk_ctl_usuario_filial_filial FOREIGN KEY (filial)
        REFERENCES public.bas_filial (codigo) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT
)

TABLESPACE pg_default;

ALTER TABLE ctl_usuario_filial  OWNER to postgres;

COMMENT ON TABLE public.ctl_usuario_filial  IS 'Permissão Acesso Usuario / Filial';