Table film_text
This 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 film table INSERT
, UPDATE
and DELETE
operations.
Schema
This table belongs to schema sakila.
Columns
This table contains 3 columns.
film_id
-
smallint
·NOT NULL
A surrogate primary key used to uniquely identify each film in the table.
title
-
character varying(255)
·NOT NULL
The title of the film.
description
-
A short description or plot summary of the film.
Primary key
This table has a primary key.
film_text
-
film_id
Indices
This table has 2 indices.
film_text_pkey
-
film_id
idx_film_text_title_description
-
title, description