I'm working with same feature and created a db diagram with minimum columns for understanding how it'll work in real application.

Here is my db diagram, where you may get an idea and implement.

Product Variation Wise Price in Ecommerce

Thank you!