I have a problem with the database organization for ecommerce product variations. Googling, I found a lot of articles and every article says that if the product has more variations, it should be in a separate table with a relation. Each variation (sku) has its own price etc...
What interests me is the following: Where do I store the price of the product if the product does not have a variation? For example, the product is in one color, one size!
Can someone look at my diagram and suggest if I'm doing something wrong?
The first picture shows a product with variations, while the second picture shows a product without variations