film_text
| Documentation | Sakila |
| Name | film_text |
| Module | Inventory |
The film_text table contains the film_id, title and description columns of the film table, with the contents of the table kept in synchrony with the film table by means of triggers on the film table's INSERT, UPDATE and DELETE operations (see Section 5.5, “Triggers”).
Before MySQL server 5.6.10, the film_text table was the only table in the Sakila sample database that used the MyISAM storage engine. This is because full-text search is used for titles and descriptions of films listed in the film table. MyISAM was used because full-text search support with InnoDB was not available until MySQL server 5.6.10.
The contents of the film_text table should never be modified directly. All changes should be made to the film table instead.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | film_id | smallint(5, 0) | inventory | A surrogate primary key used to uniquely identify each film in the table. | ||||
| A surrogate primary key used to uniquely identify each film in the table. References: inventory |
||||||||
| 2 | title | varchar(255) | The title of the film. | |||||
| The title of the film. |
||||||||
| 3 | description | text | A short description or plot summary of the film. | |||||
| A short description or plot summary of the film. |
||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| film_text | inventory | film_text.film_id = inventory.film_id | fk_film_text Foreign key constraint referencing inventory.film_id |
|
|
film_text.film_id = inventory.film_id Name: fk_film_textForeign key constraint referencing inventory.film_id |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PRIMARY | film_id | Primary key. | |
| Primary key. | |||
Uses
| Name |
|---|
|
film_text
|
Exported: 2018-10-12 17:43, Last imported: 2018-08-06 10:44