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.
Columns
This table contains 3 columns.
CATEGORY_ID-
INTEGER·NOT NULLA surrogate primary key used to uniquely identify each category in the table.
NAME-
VARCHAR(25)·NOT NULLThe name of the category.
LAST_UPDATE-
TIMESTAMP·NOT NULL·DEFAULT CURRENT_TIMESTAMPWhen 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.
RDB$PRIMARY3-
CATEGORY_ID