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 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

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