I have a product database working fine.
Products are assigned a main category and a sub category.
What I need to add are product options so the 'rosary beads' sub category will have colour options...red, black, white etc...
I'm wondering what is the best way to do this? A separate 'options' table with the id from the product table?
So the table would be something like...