CREATE TABLE public.rlc_aux_dup_pagar_x_cheque_recebido
(
    terminal_ip character varying(15) COLLATE pg_catalog."default" NOT NULL,
    sequencia integer NOT NULL,
    sequencia_cheque integer NOT NULL,
    banco_cheque integer NOT NULL,
    agencia_cheque character varying(10) COLLATE pg_catalog."default" NOT NULL,
    conta_cheque character varying(12) COLLATE pg_catalog."default" NOT NULL,
    numero_cheque character varying(14) COLLATE pg_catalog."default" NOT NULL,
    CONSTRAINT pk_rlc_aux_dup_pagar_x_cheque_recebido PRIMARY KEY (terminal_ip, sequencia, sequencia_cheque, banco_cheque, agencia_cheque, conta_cheque, numero_cheque),
    CONSTRAINT fk_rlc_aux_dup_pagar_x_cheque_recebido_cheque FOREIGN KEY (sequencia_cheque)
        REFERENCES public.flx_cheque (sequencia) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.rlc_aux_dup_pagar_x_cheque_recebido
    OWNER to postgres;
COMMENT ON TABLE public.rlc_aux_dup_pagar_x_cheque_recebido
    IS 'Auxiliar do Relacionamento entre a duplicata a pagar e o cheque recebido';