-- Table: public.vnd_aux_business_intelligence

DROP TABLE public.vnd_aux_business_intelligence;

CREATE TABLE public.vnd_aux_business_intelligence
(
    terminal_ip character varying(50) COLLATE pg_catalog."default" NOT NULL,
    filial integer NOT NULL,
    ano_analise character varying(4) COLLATE pg_catalog."default" NOT NULL,
    data_inicial date NOT NULL,
    data_final date NOT NULL,
    vendedor character varying(5000) COLLATE pg_catalog."default" NOT NULL,
    grupo character varying(5000) COLLATE pg_catalog."default" NOT NULL,
    subgrupo character varying(5000) COLLATE pg_catalog."default" NOT NULL,
    fornecedor character varying(5000) COLLATE pg_catalog."default" NOT NULL,
    produto character varying(5000) COLLATE pg_catalog."default" NOT NULL,
    cliente character varying(5000) COLLATE pg_catalog."default" NOT NULL,
    tipo_pgto character varying(5000) COLLATE pg_catalog."default" NOT NULL,
    aplicacao character varying(5000) COLLATE pg_catalog."default" NOT NULL,
    fabricante character varying(5000) COLLATE pg_catalog."default" NOT NULL,
    linha character varying(5000) COLLATE pg_catalog."default" NOT NULL,
    ramo_cli character varying(5000) COLLATE pg_catalog."default" NOT NULL,
    ramo_for character varying(5000) COLLATE pg_catalog."default" NOT NULL,
    var_where character varying(50000) COLLATE pg_catalog."default" NOT NULL,
    CONSTRAINT pk_vnd_aux_business_intelligence PRIMARY KEY (terminal_ip)
)

TABLESPACE pg_default;

ALTER TABLE public.vnd_aux_business_intelligence
    OWNER to postgres;
	
	
	
	
	
	
	
-- Table: public.vnd_aux_business_intelligence_impressao
DROP TABLE public.vnd_aux_business_intelligence_impressao;

CREATE TABLE public.vnd_aux_business_intelligence_impressao
(
    terminal_ip character varying(50) COLLATE pg_catalog."default" NOT NULL,
    tipo character varying(10) COLLATE pg_catalog."default" NOT NULL,
    sequencia integer NOT NULL,
    quebra character varying(10) COLLATE pg_catalog."default" NOT NULL,
    valor numeric(18,6) NOT NULL,
    CONSTRAINT pk_vnd_aux_business_intelligence_impressao PRIMARY KEY (terminal_ip, tipo, sequencia)
)

TABLESPACE pg_default;

ALTER TABLE public.vnd_aux_business_intelligence_impressao
    OWNER to postgres;