DROP TABLE IF EXISTS public.pla_aux_cardapio_mes;

CREATE TABLE public.pla_aux_cardapio_mes
(
    terminal_ip character varying(15) COLLATE pg_catalog."default" NOT NULL,
    grupo integer NOT NULL,
    d_semana integer NOT NULL,
    dia integer NOT NULL,
    semi integer NOT NULL,
    desc_resum character varying(30) COLLATE pg_catalog."default",
    idx integer NOT NULL,
    preco_mercado_com_impostos numeric(18,6) NOT NULL,
    preco_ult_compra_com_impostos numeric(18,6) NOT NULL,
    CONSTRAINT pk_pla_aux_cardapio_mes PRIMARY KEY (terminal_ip, grupo, d_semana, dia, semi)
)
WITH (
    OIDS = FALSE
)
TABLESPACE pg_default;

ALTER TABLE public.pla_aux_cardapio_mes
    OWNER to postgres;

COMMENT ON TABLE public.pla_aux_cardapio_mes
    IS 'Auxiliar do Cardapio Mensal';