O'Reilly logo

Adobe ColdFusion 8 Web Application Construction Kit, Volume 1: Getting Started by Charlie Arehart, Raymond Camden, Ben Forta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

Table 5.12. The MerchandiseOrders Table
ColumnData TypeDescription and Size
OrderIDNumericUnique ID of order (order number); can be populated manually when rows are inserted or automatically (if defined as an Auto Number field)
ContactIDNumericID of associated contact
OrderDateDataOrder date
ShipAddressTextOrder ship to address
ShipCityTextOrder ship to city
ShipStateTextOrder ship to state (or province)
ShipZipTextOrder ship to ZIP code (or postal code)
ShipCountryTextOrder ship to country
ShipDateDateOrder ship date (when shipped)

The primary key ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required