CREATE TABLE public.stq_requis_item_cpl
(
    filial_req integer NOT NULL,
    requisicao integer NOT NULL,
    sequencia integer NOT NULL,
    sequencia_lote integer NOT NULL,
    CONSTRAINT pk_stq_requis_item_cpl PRIMARY KEY (filial_req, requisicao, sequencia),
    CONSTRAINT fk_stq_requis_item_cpl 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 public.stq_requis_item_cpl
    OWNER to postgres;

COMMENT ON TABLE public.stq_requis_item
    IS 'Item da requisicao Complemento indicacao do nr do lote.';