consigliere's avatar

Help with database schema for ecommerce site

I'm building an ecommerce site selling (dresses).

The customer will choose a dress then choose a color and then a dropdown of sizes.

|   product   |   | color |   |   image   |   | product_color_image |   | variation(size)        |
|:-----------:|---|:-----:|---|:---------:|---|:-------------------:|---|------------------------|
| name        |   | name  |   | path      |   | product_id          |   | product_color_image_id |
| description |   |       |   | thumbnail |   | image_id            |   | stock                  |
|             |   |       |   |           |   | color_id            |   | size                   |
|             |   |       |   |           |   |                     |   | price                  |

Is my schema ideal? or it would be very slow? and are relationship easy to setup in eloquent?

0 likes
0 replies

Please or to participate in this conversation.