Online Shopping Systemвђ“database — Design ~ Bhupal Blogs

Should I include like coupon codes or reviews? SQL comparison for this system?

An entry is created in Orders , and details are moved to Order_Items . Should I include like coupon codes or reviews

ProductID , CategoryID (FK), SKU , Name , BasePrice , StockQuantity . Product_Images: ImageID , ProductID (FK), URL , IsPrimary . 3. Sales & Transactions StockQuantity . Product_Images: ImageID

OrderItemID , OrderID (FK), ProductID (FK), Quantity , PriceAtPurchase . Should I include like coupon codes or reviews