The MerchandiseOrders Table
The MerchandiseOrders table stores online merchandise order information. MerchandiseOrders contains the columns in Table B.10.
Column | Datatype | Description |
---|---|---|
OrderID | Numeric (Identity) | Unique order ID |
ContactID | Numeric | Buyer contact ID |
OrderDate | Date Time | Order date |
ShipAddress | Text (100 chars) | Ship to address |
ShipCity | Text (50 chars) | Ship to city |
ShipState | Text (5 chars) | Ship to state |
ShipZip | Text (10 chars) | Ship to ZIP |
ShipCountry | Text (50 chars) | Ship to country |
ShipDate | Date Time | Ship date |
Primary Key
OrderID
Foreign Keys
ContactID related to primary key in Contacts 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.