Table LANGUAGE

This table is a lookup table listing the possible languages that films can have for their language and original language values. The table is referred to by the FILM table.

Columns

This table contains 3 columns.

LANGUAGE_ID

INTEGER · NOT NULL

A surrogate primary key used to uniquely identify each language.

NAME

CHAR(20) · NOT NULL

The English name of the language.

LAST_UPDATE

TIMESTAMP · NOT NULL · DEFAULT CURRENT_TIMESTAMP

When the row was created or most recently updated.

Primary key

This table has a primary key.

LANGUAGE

LANGUAGE_ID

Indices

This table has one index.

RDB$PRIMARY12

LANGUAGE_ID