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

The Films table (Table 5.2) contains the movies list. The primary key for this table is the FilmID column.

Table 5.2. The Films Table
ColumnData TypeDescription and Size
FilmIDNumericUnique ID for each movie; can be populated manually when rows are inserted or automatically (if defined as an Auto Number field)
MovieTitleTextMovie title
PitchTextTextMovie pitch text; the tag line
AmountBudgetedNumeric, currencyAmount budgeted for movie (may not be equal to the actual cost plus expenses)
RatingIDNumericID of associated rating in the FilmsRatings table
SummaryMemo or long textFull movie summary stored in a variable-length text field (to enable longer summaries)
ImageNameTextFile name of associated image (if there is one)
DateInTheaters

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