ALTER TABLE species
    ADD CONSTRAINT fk_species_category
    FOREIGN KEY (categoryID)
    REFERENCES speciesCategories(categoryID)
    ON DELETE CASCADE
    ON UPDATE CASCADE;

ALTER TABLE species
    ADD CONSTRAINT fk_species_subCategory
    FOREIGN KEY (subCategoryID)
    REFERENCES speciesSubCategories(subCategoryID)
    ON DELETE CASCADE
    ON UPDATE CASCADE;
