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

