PS4 - database design
I am trying to understand the db design for the store. I am replacing an older store (hand rolled, ancient) with PS4, so am trying to understand structure for the easiest migration.
In my older design, I had a table for color and one for sizes. Then in each product, I had a color_ID and a size_ID, and just applied it for each product, with 1 for each entry that applied.
However, in studying PS4 set up, it uses Options but each product has it's own set of options, but not tied to an optionID. So in my testing, I end up with OptionId 5 = Medium as well as OptionID 14 = Medium.
I'd much rather have each product have keys for medium, large etc. but I'm guessing that would be a major rewrite of product pages.
Or am I totally off the mark with database design principals?
Any comments, most appreciated.
PS: If I added optionID to the products, what would I need to do to the product detail pages to pull in that information?