DROP TABLE IF EXISTS public.vnd_aux_business_intelligence_impressao;
DROP TABLE IF EXISTS public.vnd_aux_business_intelligence;


CREATE TABLE public.vnd_aux_business_intelligence
(
    terminal_ip character varying(15) 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)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.vnd_aux_business_intelligence
    OWNER to postgres;



CREATE TABLE public.vnd_aux_business_intelligence_impressao
(
    terminal_ip character varying(15) 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, sequencia)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.vnd_aux_business_intelligence_impressao
    OWNER to postgres;