The language table

The language table lists all possible values for the film language and original language.

The film table refers to the language table using a foreign key.

Table Structure

The structure of the language table is as follows:

+-------------+------------------+------+-----+-------------------+-----------------------------------------------+
| Field       | Type             | Null | Key | Default           | Extra                                         |
+-------------+------------------+------+-----+-------------------+-----------------------------------------------+
| language_id | tinyint unsigned | NO   | PRI | NULL              | auto_increment                                |
| name        | char(20)         | NO   |     | NULL              |                                               |
| last_update | timestamp        | NO   |     | CURRENT_TIMESTAMP | DEFAULT_GENERATED on update CURRENT_TIMESTAMP |
+-------------+------------------+------+-----+-------------------+-----------------------------------------------+

Table Columns

The following table explains all columns in the language table.

Column	Description
`language_id`	The surrogate primary key used to uniquely identify each language.
`name`	The English name of the language.
`last_update`	The time when the row was created or last updated.