5.1.3 The category Table

The category table lists the categories that can be assigned to a film.

The category table is joined to the film table by means of the film_category table.

Columns
  • category_id: A surrogate primary key used to uniquely identify each category in the table.

  • name: The name of the category.

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