Table category

This table lists the categories that can be assigned to a film. The table is joined to the film table by means of the film_category table.

Schema

This table belongs to schema sakila.

Columns

This table contains 3 columns.

category_id

smallint · NOT NULL

A surrogate primary key used to uniquely identify each category in the table.

name

character varying(25) · NOT NULL

The name of the category.

last_update

timestamp(0) without time zone · NOT NULL · CURRENT_TIMESTAMP

When the row was created or most recently updated.

Primary key

This table has a primary key.

category

category_id

Indices

This table has one index.

category_pkey

category_id