-- Table: public.par_b2b_cliente

-- DROP TABLE public.par_b2b_cliente;

CREATE TABLE public.par_b2b_cliente (
    filial integer NOT NULL,
    usuario integer NOT NULL,
    cliente integer NOT NULL,
    situacao character varying(1) COLLATE pg_catalog."default" NOT NULL,
    CONSTRAINT pk_par_b2b_cliente PRIMARY KEY (filial, usuario),
    CONSTRAINT fk_par_b2b_cliente_cliente FOREIGN KEY (cliente, filial)
        REFERENCES public.cli_cliente (codigo, filial) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION,
    CONSTRAINT fk_par_b2b_cliente_usuario FOREIGN KEY (filial, usuario)
        REFERENCES public.ctl_usuario (usufilial, usucod) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.par_b2b_cliente    OWNER to postgres;

COMMENT ON TABLE public.par_b2b_cliente    IS 'Parametro Cliente - B2B';