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

The Merchandise table (Table 5.11) contains a list of merchandise for sale. Merchandise is associated with movies, so this table is related to the Films table.

Table 5.11. The Merchandise Table
ColumnData TypeDescription and Size
MerchIDNumericUnique ID for each item of merchandise; can be populated manually when rows are inserted or automatically (if defined as an Auto Number field)
FilmIDNumericID of associated movie
MerchNameTextItem name
MerchDescriptionTextItem description
MerchPriceNumeric or currencyItem price
ImageNameSmallTextFile name of small image of item (if present)
ImageNameLargeTextFile name of large image of item (if present)

The primary key for this table is the MerchID column.

This table contains a single foreign ...

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