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.