francoisbass Posted November 4, 2014 Share Posted November 4, 2014 Hi Larry, I'm looking at the customers tables design, page 188, and there is something I don't understand. For me it looks like the order_contents table can store only one item per order, with its product_id, quantity and price. But if an order contains several items, how can it be stored in the order_contents table with each product_id, quantity and price? Thank you Francois Link to comment Share on other sites More sharing options...
francoisbass Posted November 4, 2014 Author Share Posted November 4, 2014 Ok , I got it! Each item is an entry in the order_contents table with its quantity, price, etc... Am I right? Thank you Francois Link to comment Share on other sites More sharing options...
Larry Posted November 6, 2014 Share Posted November 6, 2014 Exactly! Link to comment Share on other sites More sharing options...
Recommended Posts