Mar 10, 2016
0
Level 2
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?
Please or to participate in this conversation.