CREATE TABLE IF NOT EXISTS public.ent_balanca_relac_requisicao
(
    pesagem integer NOT NULL,
    filial_req integer NOT NULL,
    requisicao integer NOT NULL,
    CONSTRAINT pk_ent_balanca_relac_requisicao PRIMARY KEY (pesagem, filial_req, requisicao),
    CONSTRAINT fk_ent_balanca_relac_requisicao_peso FOREIGN KEY (pesagem)
        REFERENCES public.ent_balanca_peso (sequencia) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT,
	CONSTRAINT fk_ent_balanca_relac_requisicao FOREIGN KEY (filial_req, requisicao)
        REFERENCES public.stq_requis (filial_req, requisicao) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE RESTRICT
)

TABLESPACE pg_default;

ALTER TABLE IF EXISTS public.ent_balanca_relac_requisicao
    OWNER to postgres;