The MerchandiseOrdersItems Table
The MerchandiseOrdersItems table (Table 5.13) contains the individual items within an order. Order items are associated with an order and the merchandise being ordered, so this table is related to both the MerchandiseOrders and Merchandise tables.
| Column | Data Type | Description and Size |
|---|---|---|
| OrderItemID | Numeric | Unique ID of order items; can be populated manually when rows are inserted or automatically (if defined as an Auto Number field) |
| OrderID | Numeric | ID of associated order |
| ItemID | Numeric | ID of item ordered |
| OrderQty | Numeric | Item quantity |
| ItemPrice | Numeric or currency | Per-item price |
The primary key for this table is the OrderItemID column.
This table contains two foreign keys:
The OrderID ...
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.
