e commerce database help
Hello, I came up with database base design, but I'm not sure if it's correct. If it's correct can you help me with the request to fetch data for the product page efficiently? User can choose product size and color in dropdowns and based on choice, I display price for a certain variant of product. Right know I only have an idea to fetch all variants.
1 Reply
it would be helpful to show some sample data for each table, it give some perspective to answer your question.