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

