CREATE TABLE IF NOT EXISTS public.ent_balanca_peso
(
sequencia integer NOT NULL,
placa character varying(10) NOT NULL,
filial_fornecedor integer NOT NULL,
fornecedor integer NOT NULL,
produto integer NOT NULL,
peso numeric(18,6) NOT NULL,
preco numeric(18,6) NOT NULL,
valor_total numeric(18,6) NOT NULL,
data date NOT NULL,
situacao character varying(1) NOT NULL,
motorista character varying(50) NOT NULL,
hora time without time zone NOT NULL,
pesagem_inicial numeric(18,6) NOT NULL,
pesagem_final numeric(18,6) NOT NULL,
operador character varying(50) NOT NULL,

 CONSTRAINT pk_ent_balanca_peso PRIMARY KEY (sequencia),
 CONSTRAINT fk_ent_balanca_peso_fornec FOREIGN KEY (filial_fornecedor, fornecedor)
        REFERENCES public.for_fornecedor (filial, codigo) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.ent_balanca_peso
    OWNER to postgres;

COMMENT ON TABLE public.ent_balanca_peso
    IS 'Cadastro Pesagem de Materia Prima';