5.1.8 The film_actor Table

The film_actor table is used to support a many-to-many relationship between films and actors. For each actor in a given film, there will be one row in the film_actor table listing the actor and film.

The film_actor table refers to the film and actor tables using foreign keys.

  • actor_id: A foreign key identifying the actor.

  • film_id: A foreign key identifying the film.

  • last_update: The time that the row was created or most recently updated.

Download this Manual
PDF (US Ltr) - 177.1Kb
PDF (A4) - 176.7Kb