The FilmsActors Table
The FilmsActors table associates actors with the movies they are in. FilmsActors contains the columns in Table B.6. Retrieving actors with their movies requires a three-way join (Films, Actors, and FilmsActors).
| Column | Datatype | Description |
|---|---|---|
| FARecID | Numeric (Identity) | Unique film actor ID |
| FilmID | Numeric | Movie ID |
| ActorID | Numeric | Actor ID |
| IsStarringRole | Small Integer | Is star flag |
| Salary | Real | Actor salary |
Primary Key
FARecID
Foreign Keys
FilmID related to primary key in Films table
ActorID related to primary key in Actors 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.
