The MerchandiseOrders Table
The MerchandiseOrders table (Table 5.12) contains the orders for movie merchandise. Orders are associated with contacts (the buyer), so this table is related to the Contacts table.
| Column | Data Type | Description and Size |
|---|---|---|
| OrderID | Numeric | Unique ID of order (order number); can be populated manually when rows are inserted or automatically (if defined as an Auto Number field) |
| ContactID | Numeric | ID of associated contact |
| OrderDate | Data | Order date |
| ShipAddress | Text | Order ship to address |
| ShipCity | Text | Order ship to city |
| ShipState | Text | Order ship to state (or province) |
| ShipZip | Text | Order ship to ZIP code (or postal code) |
| ShipCountry | Text | Order ship to country |
| ShipDate | Date | Order ship date (when shipped) |
The primary key ...
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.
