ALTER TABLE thermometers
    ADD CONSTRAINT fk_thermometer_manufacturerID
    FOREIGN KEY (manufacturerID)
    REFERENCES manufacturers(manufacturerID)
    ON DELETE CASCADE
    ON UPDATE CASCADE;

