I am trying to add some things to my tshirt website
I have a product that has one category, two images, more than one option(color choices), more than one size and the prices is based off the size. Here are the tables I have created but I know this isn't correct. Can someone help me put the together the correct way. I am really confused so any help will be really appreciated.
Product
ProductID
prod_name
prod_desc
ImageID
CategoryID
OptionID
PriceID
SizeID
Categories
CategoryID
Category
ImageID
ImageID
image
th_image
Options
OptionID
options
Price
PriceID
Price
Size
SizeID
Size
PriceID
