The Expenses Table
The Expenses table (Table 5.3) contains the expenses associated with any movies listed in the Films table.
| Column | Data Type | Description and Size |
|---|---|---|
| ExpenseID | Numeric | Unique ID for each expense; can be populated manually when rows are inserted or automatically (if defined as an Auto Number field) |
| FilmID | Numeric | ID of associated movie |
| ExpenseAmount | Numeric, or currency | Expense amount |
| Description | Text | Expense description |
| ExpenseDate | Date | Expense date |
The primary key for this table is the ExpenseID column.
This table contains a single foreign key:
The FilmID column is related to the primary key of the Films table.
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.
