CREATE TABLE public.rcb_contrato
(
    filial_cli integer NOT NULL,
    cliente integer NOT NULL,
    dia_vencimento integer NOT NULL,
    mes_reajuste integer NOT NULL,
    vlr_duplicata numeric(18,6) NOT NULL,
    vlr_duplicata_reajustado numeric(18,6) NOT NULL,
    tipo_pgto integer NOT NULL,
    tipo_duplicata integer NOT NULL,
    banco integer NOT NULL,
    agencia character varying(10) COLLATE pg_catalog."default" NOT NULL,
    conta character varying(15) COLLATE pg_catalog."default" NOT NULL,
    CONSTRAINT pk_rcb_contrato PRIMARY KEY (filial_cli, cliente),
    CONSTRAINT fk_rcb_contrato_cliente FOREIGN KEY (filial_cli, cliente)
        REFERENCES public.cli_cliente (filial, codigo) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT,
    CONSTRAINT fk_rcb_contrato_conta FOREIGN KEY (banco, conta, agencia)
        REFERENCES public.flx_conta_banc (banco, conta, agencia) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.rcb_contrato
    OWNER to postgres;