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.
