language
| Documentation | Sakila |
| Name | language |
| Module | Inventory |
The language table is a lookup table listing the possible languages that films can have for their language and original language values.
The language table is referred to by the film table.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | language_id | unsigned tinyint(3, 0) | Identity / Auto increment column | A surrogate primary key used to uniquely identify each language. | ||||
| A surrogate primary key used to uniquely identify each language. Identity / Auto increment column |
||||||||
| 2 | name | char(20) | The English name of the language. | |||||
| The English name of the language. |
||||||||
| 3 | last_update | timestamp | Default: CURRENT_TIMESTAMP | The time that the row was created or most recently updated. | ||||
| The time that the row was created or most recently updated. Default: CURRENT_TIMESTAMP |
||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| film | language | film.language_id = language.language_id | fk_film_language Foreign key constraint referencing language.language_id |
|
|
film.language_id = language.language_id Name: fk_film_languageForeign key constraint referencing language.language_id |
||||
| film | language | film.original_language_id = language.language_id | fk_film_language_original Foreign key constraint referencing language.language_id |
|
|
film.original_language_id = language.language_id Name: fk_film_language_originalForeign key constraint referencing language.language_id |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PRIMARY | language_id | Primary key. | |
| Primary key. | |||
Exported: 2018-10-12 17:43, Last imported: 2018-08-06 10:44