CREATE TABLE public.rlc_cliente_x_fornecedor
(
    filial_cli integer NOT NULL,
    cliente integer NOT NULL,
    filial_for integer NOT NULL,
    fornecedor integer NOT NULL,
    CONSTRAINT pk_rlc_cliente_x_fornecedor PRIMARY KEY (filial_cli, cliente, filial_for, fornecedor),
    CONSTRAINT fk_rlc_cliente_x_fornecedor_cliente FOREIGN KEY (filial_cli, cliente)
        REFERENCES public.cli_cliente (filial, codigo) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT,
    CONSTRAINT fk_rlc_cliente_x_fornecedor_fornecedor FOREIGN KEY (fornecedor, filial_for)
        REFERENCES public.for_fornecedor (codigo, filial) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT
)

TABLESPACE pg_default;

ALTER TABLE public.rlc_cliente_x_fornecedor
    OWNER to postgres;
COMMENT ON TABLE public.rlc_cliente_x_fornecedor
    IS 'Cadastro de relacionamento de cliente com o fornecedor.';