-- Table: prd_recurso_producao
-- DROP TABLE prd_recurso_producao;

CREATE TABLE IF NOT EXISTS public.prd_recurso_producao(
    codigo integer NOT NULL,
    descricao character varying(50) NOT NULL,
    valor numeric(18,6) NOT NULL,
    CONSTRAINT pk_prd_recurso_producao PRIMARY KEY (codigo)
)

TABLESPACE pg_default;

ALTER TABLE public.prd_recurso_producao OWNER to postgres;
COMMENT ON TABLE public.prd_recurso_producao IS 'Cadastro de Recursos de Producao';


--##############################################################################################
--##############################################################################################
--##############################################################################################


-- Table: prd_apontamento_producao
-- DROP TABLE prd_apontamento_producao;

CREATE TABLE IF NOT EXISTS prd_apontamento_producao(
    filial integer NOT NULL,
    ordem_producao integer NOT NULL,
    sequencia integer NOT NULL,
    operador integer NOT NULL,
    etapa integer NOT NULL,
    recurso integer NOT NULL,
    data_inicial date NOT NULL,
    data_final date NOT NULL,
    hora_inicial time without time zone NOT NULL,	
    hora_final time without time zone NOT NULL,	
    valor numeric(18,6) NOT NULL,
    observacao character varying(500) NOT NULL,
    filial_usu integer NOT NULL,
    usuario integer NOT NULL,
    data date NOT NULL,
    hora time without time zone NOT NULL,	
    terminal_ip character varying(15) NOT NULL,
	
    CONSTRAINT pk_prd_apontamento_producao PRIMARY KEY (filial, ordem_producao, sequencia)
)

TABLESPACE pg_default;

ALTER TABLE prd_apontamento_producao OWNER to postgres;
COMMENT ON TABLE prd_apontamento_producao IS 'Cadastro de Apontamentos de Producao';