The MerchandiseOrdersItems Table
The MerchandiseOrdersItems table contains the items in each order. MerchandiseOrdersItems contains the columns in Table B.11.
Column | Datatype | Description |
---|---|---|
OrderItemID | Numeric (Identity) | Unique order item ID |
OrderID | Numeric | Order ID |
ItemID | Numeric | Ordered item ID |
OrderQty | Numeric | Number of items ordered |
ItemPrice | Real | Item sale price |
Primary Key
OrderItemID
Foreign Keys
OrderID related to primary key in MerchandiseOrders table
ItemID related to primary key in Merchandise table
Get Adobe ColdFusion 8 Web Application Construction Kit, Volume 1: Getting Started now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.