The Films Table
The Films table (Table 5.2) contains the movies list. The primary key for this table is the FilmID column.
| Column | Data Type | Description and Size |
|---|---|---|
| FilmID | Numeric | Unique ID for each movie; can be populated manually when rows are inserted or automatically (if defined as an Auto Number field) |
| MovieTitle | Text | Movie title |
| PitchText | Text | Movie pitch text; the tag line |
| AmountBudgeted | Numeric, currency | Amount budgeted for movie (may not be equal to the actual cost plus expenses) |
| RatingID | Numeric | ID of associated rating in the FilmsRatings table |
| Summary | Memo or long text | Full movie summary stored in a variable-length text field (to enable longer summaries) |
| ImageName | Text | File name of associated image (if there is one) |
| DateInTheaters |
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.
