September 2007
Intermediate to advanced
600 pages
20h 21m
English
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 ...
Read now
Unlock full access