The Films Table
The Films table lists all movies and related information. Films contains the columns in Table B.5.
| Column | Datatype | Description |
|---|---|---|
| FilmID | Numeric (Identity) | Unique movie ID |
| MovieTitle | Text (255 chars) | Movie title |
| PitchText | Text (100 chars) | Movie one-liner |
| AmountBudgeted | Currency (or numeric) | Movie budget (planned) |
| RatingID | Numeric | Movie rating ID |
| Summary | Memo (or text) | Movie plot summary |
| ImageName | Text (50 chars) | Movie poster image file name |
| DateInTheaters | Date Time | Date movie is in theaters |
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.
