September 2007
Intermediate to advanced
600 pages
20h 21m
English
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 |
OrderItemID
OrderID related to primary key in MerchandiseOrders table
ItemID related to primary key in Merchandise table
Read now
Unlock full access