The film_text table

The content of film_text table is kept in synchrony with the film table by means of triggers on the film table INSERT, UPDATE and DELETE operations。

Table Structure

The structure of the film_text table is as follows:

+-------------+--------------+------+-----+---------+-------+
| Field       | Type         | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| film_id     | smallint     | NO   | PRI | NULL    |       |
| title       | varchar(255) | NO   | MUL | NULL    |       |
| description | text         | YES  |     | NULL    |       |
+-------------+--------------+------+-----+---------+-------+

Table Columns

The following table explains all columns in the film_text table.

Column	Description
`film_id`	The surrogate primary key used to uniquely identify each film in the table.
`title`	The title of the film.
`description`	A short description or plot summary of the film.

Never directly modify the film_text table contents. All changes should be made to the film table instead.