CREATE TABLE IF NOT EXISTS public.flx_cheque_deposito
(
    sequencia integer NOT NULL,

	usuario integer NOT NULL,
	data date NOT NULL,
	hora time without time zone NOT NULL,

	banco integer NOT NULL,
    agencia character varying(10) NOT NULL,
    conta character varying(12) NOT NULL,

	valor_total numeric(18, 6) NOT NULL,
	situacao character varying(1) NOT NULL,
	data_credito date NOT NULL,
	
    observacao character varying NOT NULL,
	
    CONSTRAINT pk_flx_cheque_deposito PRIMARY KEY (sequencia),
	
    CONSTRAINT fk_flx_cheque_deposito_bco_cta 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.flx_cheque_deposito
    OWNER to postgres;

COMMENT ON TABLE public.flx_cheque_deposito
    IS 'Tabela de Controle de Repasse Cheque Recebido';


CREATE TABLE IF NOT EXISTS public.flx_cheque_deposito_cheque
(
    deposito integer NOT NULL,
	sequencia_cheque integer NOT NULL,
    CONSTRAINT pk_flx_cheque_deposito_cheque PRIMARY KEY (deposito, sequencia_cheque),
    CONSTRAINT fk_flx_cheque_deposito_cheque FOREIGN KEY (sequencia_cheque)
        REFERENCES public.flx_cheque (sequencia) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.flx_cheque_deposito_cheque
    OWNER to postgres;

COMMENT ON TABLE public.flx_cheque_deposito_cheque
    IS 'Tabela de Controle de Repasse Cheque Recebido';