5.1.9 The film_category Table

The film_category table is used to support a many-to-many relationship between films and categories. For each category applied to a film, there will be one row in the film_category table listing the category and film.

The film_category table refers to the film and category tables using foreign keys.

  • film_id: A foreign key identifying the film.

  • category_id: A foreign key identifying the category.

  • 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