CREATE TABLE public.par_conciliacao_conta_data
(
    banco integer NOT NULL,
    agencia character varying(10) COLLATE pg_catalog."default" NOT NULL,
    conta character varying(20) COLLATE pg_catalog."default" NOT NULL,
    data date NOT NULL,
    CONSTRAINT pk_par_conciliacao_conta_data PRIMARY KEY (banco, agencia, conta),
    CONSTRAINT fk_par_conciliacao_conta_data FOREIGN KEY (banco, agencia, conta)
        REFERENCES public.flx_conta_banc (banco, agencia, conta) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.par_conciliacao_conta_data
    OWNER to postgres;

COMMENT ON TABLE public.par_conciliacao_conta_data
    IS 'Controle de importacao de conciliacao.';