CREATE TABLE public.rlc_dup_pagar_x_cheque_recebido
(
  filial_dup_pag integer NOT NULL,
  sequencia_dup_pag integer NOT NULL,
  sequencia_cheque integer NOT NULL,
  banco_cheque integer NOT NULL,
  agencia_cheque character varying(10) NOT NULL,
  conta_cheque character varying(12) NOT NULL,
  numero_cheque character varying(14) NOT NULL,
  CONSTRAINT pk_rlc_dup_pagar_x_cheque_recebido PRIMARY KEY (filial_dup_pag, sequencia_dup_pag, sequencia_cheque, banco_cheque, agencia_cheque, conta_cheque, numero_cheque),
  CONSTRAINT fk_rlc_dup_pagar_x_cheque_recebido_cheque FOREIGN KEY (sequencia_cheque)
      REFERENCES public.flx_cheque (sequencia) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE RESTRICT,
  CONSTRAINT fk_rlc_dup_pagar_x_cheque_recebido_duplic FOREIGN KEY (filial_dup_pag, sequencia_dup_pag)
      REFERENCES public.pag_duplicata_pagar (filial_dup_pag, sequencia) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE RESTRICT
)
WITH (
  OIDS=FALSE
);
ALTER TABLE public.rlc_dup_pagar_x_cheque_recebido
  OWNER TO postgres;
GRANT ALL ON TABLE public.rlc_dup_pagar_x_cheque_recebido TO postgres;
COMMENT ON TABLE public.rlc_dup_pagar_x_cheque_recebido
  IS 'Relacionamento entre a duplicata a pagar e o cheque recebido';