CREATE TABLE public.ubiturso (
    codubi character varying(51) NOT NULL,
    codtd character varying(51) NOT NULL,
    nsca double precision,
    nrip double precision,
    poee double precision
);
COMMENT ON TABLE public.ubiturso IS 'Soglie per la coppia ubicaz-turnidet';
COMMENT ON COLUMN public.ubiturso.codubi IS 'Codice della location';
COMMENT ON COLUMN public.ubiturso.codtd IS 'Codice di turnidet';
COMMENT ON COLUMN public.ubiturso.nsca IS 'Soglia su numero di scarti';
COMMENT ON COLUMN public.ubiturso.nrip IS 'Soglia su numero di ripassi';
COMMENT ON COLUMN public.ubiturso.poee IS 'Soglia su percentuale OEE';
ALTER TABLE ONLY public.ubiturso
    ADD CONSTRAINT ix_ubiturso_key PRIMARY KEY (codubi, codtd);
ALTER TABLE ONLY public.ubiturso
    ADD CONSTRAINT ix_ubiturso_codtd FOREIGN KEY (codtd) REFERENCES public.turnidet(codice) ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE ONLY public.ubiturso
    ADD CONSTRAINT ix_ubiturso_codubi FOREIGN KEY (codubi) REFERENCES public.ubicaz(codice) ON UPDATE CASCADE ON DELETE CASCADE;