The MerchandiseOrders Table

The MerchandiseOrders table stores online merchandise order information. MerchandiseOrders contains the columns in Table B.10.

Table B.10. The MerchandiseOrders Table
ColumnDatatypeDescription
OrderIDNumeric (Identity)Unique order ID
ContactIDNumericBuyer contact ID
OrderDateDate TimeOrder date
ShipAddressText (100 chars)Ship to address
ShipCityText (50 chars)Ship to city
ShipStateText (5 chars)Ship to state
ShipZipText (10 chars)Ship to ZIP
ShipCountryText (50 chars)Ship to country
ShipDateDate TimeShip 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.