Adobe ColdFusion 8 Web Application Construction Kit, Volume 1: Getting Started

The FilmsDirectors Table

The FilmsDirectors table (Table 5.5) is used to relate the Films and Directors tables (so as to associate directors with their movies).

Table 5.5. The FilmsDirectors Table

Column	Data Type	Description and Size
FDRecID	Numeric	Unique ID for each row; can be populated manually when rows are inserted or automatically (if defined as an Auto Number field)
FilmID	Numeric	ID of associated movie
DirectorID	Numeric	ID of associated director
Salary	Numeric, or currency	Director’s salary

The primary key for this table is the FDRecID column.

This table contains two foreign keys:

• The FilmID column is related to the primary key of the Films table.

• The DirectorID column is related to the primary key of the Directors table.