MySQL :: Sakila Sample Database :: 5.1.9 The film

Sakila Sample Database :: 5 Structure :: 5.1 Tables :: 5.1.9 The film_category Table

Section Navigation [Toggle]

5.1 Tables
5.1.1 The actor Table
5.1.2 The address Table
5.1.3 The category Table
5.1.4 The city Table
5.1.5 The country Table
5.1.6 The customer Table
5.1.7 The film Table
5.1.8 The film_actor Table
5.1.9 The film_category Table
5.1.10 The film_text Table
5.1.11 The inventory Table
5.1.12 The language Table
5.1.13 The payment Table
5.1.14 The rental Table
5.1.15 The staff Table
5.1.16 The store Table

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.

Columns:

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.

Top / Previous / Next / Up / Table of Contents