The Expenses Table
The Expenses table lists the expenses associated with listed movies. Expenses contains the columns in Table B.4.
Column | Datatype | Description |
---|---|---|
ExpenseID | Numeric (Identity) | Unique expense ID |
FilmID | Numeric | Movie ID |
ExpenseAmount | Real | Expense amount |
Description | Text (100 chars) | Expense description |
Expense Date | Date Time | Expense date |
Primary Key
ExpenseID
Foreign Keys
FilmID related to primary key in 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.