-- Table: public.dre_modelo
-- DROP TABLE public.dre_modelo;

CREATE TABLE IF NOT EXISTS public.dre_modelo (
    modelo integer NOT NULL,
    nome character varying(30) NOT NULL,
    descricao character varying(200) NOT NULL,
    CONSTRAINT pk_flx_modelo_dre PRIMARY KEY (modelo)
)

TABLESPACE pg_default;
ALTER TABLE public.dre_modelo OWNER to postgres;
COMMENT ON TABLE public.dre_modelo IS 'Cadastro de Modelo de DRE';





-- Table: public.flx_dre_ccusto
-- DROP TABLE public.flx_dre_ccusto;

CREATE TABLE IF NOT EXISTS public.flx_dre_ccusto (
    modelo integer NOT NULL,
    ccusto integer NOT NULL,
    CONSTRAINT pk_flx_dre_ccusto PRIMARY KEY (modelo, ccusto),
    CONSTRAINT fk_flx_dre_ccusto_ccusto FOREIGN KEY (ccusto)
        REFERENCES public.ctb_centro_custo (codigo) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT	
	
)

TABLESPACE pg_default;
ALTER TABLE public.flx_dre_ccusto OWNER to postgres;
COMMENT ON TABLE public.flx_dre_ccusto IS 'Modelo de DRE x Centro de Custo';






-- Table: public.flx_dre_tmvto
-- DROP TABLE public.flx_dre_tmvto;

CREATE TABLE IF NOT EXISTS public.flx_dre_tmvto (
    modelo integer NOT NULL,
    tmvto integer NOT NULL,
    CONSTRAINT pk_flx_dre_tmvto PRIMARY KEY (modelo, tmvto),
    CONSTRAINT fk_flx_dre_tmvto_tmvto FOREIGN KEY (tmvto)
        REFERENCES public.flx_tipo_movimento (codigo) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT	
)

TABLESPACE pg_default;
ALTER TABLE public.flx_dre_tmvto OWNER to postgres;
COMMENT ON TABLE public.flx_dre_tmvto IS 'Modelo de DRE x Tipo de Movimento';






-- Table: public.flx_aux_dre_regime_caixa

-- DROP TABLE public.flx_aux_dre_regime_caixa;

CREATE TABLE IF NOT EXISTS public.flx_aux_dre_regime_caixa(
	
    terminal_ip character varying(15) NOT NULL,
    sequencia integer NOT NULL,
    modelo integer NOT NULL,
    modelo_desc character varying(30) NOT NULL,
    tipo integer NOT NULL,
    jan numeric(18,6) NOT NULL,
    fev numeric(18,6) NOT NULL,
    mar numeric(18,6) NOT NULL,
    abr numeric(18,6) NOT NULL,
    mai numeric(18,6) NOT NULL,
    jun numeric(18,6) NOT NULL,
    jul numeric(18,6) NOT NULL,
    ago numeric(18,6) NOT NULL,
    set numeric(18,6) NOT NULL,
    out numeric(18,6) NOT NULL,
    nov numeric(18,6) NOT NULL,
    dez numeric(18,6) NOT NULL,
    total numeric(18,6) NOT NULL,

	
	
    CONSTRAINT pk_flx_aux_dre_regime_caixa PRIMARY KEY (terminal_ip, sequencia)
)

TABLESPACE pg_default;

ALTER TABLE public.flx_aux_dre_regime_caixa  OWNER to postgres;

COMMENT ON TABLE public.flx_aux_dre_regime_caixa IS 'Auxiliar DRE Regime de Caixa';