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: When the row was created or most recently updated.