The Directors Table
The Directors table (Table 5.4) contains the list of directors. This table is related to the Films table via the FilmsDirectors table.
| Column | Data Type | Description and Size |
|---|---|---|
| DirectorID | Numeric | Unique ID for each director; can be populated manually when rows are inserted or automatically (if defined as an Auto Number field) |
| FirstName | Text | Director’s first name |
| LastName | Text | Director’s last name |
The primary key for this table is the DirectorID column.
This table contains no foreign keys.
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.
