ALTER TABLE tankStocking
    ADD CONSTRAINT fk_tankStocking_tank
    FOREIGN KEY (tankID)
    REFERENCES tanks(tankID)
    ON DELETE CASCADE
    ON UPDATE CASCADE;

ALTER TABLE tankStocking
    ADD CONSTRAINT fk_tankStocking_species
    FOREIGN KEY (speciesID)
    REFERENCES species(speciesID)
    ON DELETE CASCADE
    ON UPDATE CASCADE;

