An entry is created in Orders , and details are moved to Order_Items .
AddressID , UserID (FK), Street , City , ZipCode , Type (Billing/Shipping). 2. Inventory & Catalog Categories: CategoryID , Name , Description . An entry is created in Orders , and
OrderItemID , OrderID (FK), ProductID (FK), Quantity , PriceAtPurchase . An entry is created in Orders
ProductID , CategoryID (FK), SKU , Name , BasePrice , StockQuantity . Product_Images: ImageID , ProductID (FK), URL , IsPrimary . 3. Sales & Transactions Description . OrderItemID
