Quote:
Originally Posted by gj15987
As it stands I have a category field in each animal record where I put its lowest category, in this case pythons.
I have a category table: category(id, name, parent). Parent being the parent category of that category.
|
Remove the category field from the animals table, and add in a linking table that connects categories to animals.
e.g.
category_animal(category_id, animal_id)