5.1.7 The film Table

The film table is a list of all films potentially in stock in the stores. The actual in-stock copies of each film are represented in the inventory table.

The film table refers to the language table and is referred to by the film_category, film_actor, and inventory tables.

Columns

• film_id: A 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.

• release_year: The year in which the movie was released.

• language_id: A foreign key pointing at the language table; identifies the language of the film.

• original_language_id: A foreign key pointing at the language table; identifies the original language of the film. Used when a film has been dubbed into a new language.

• rental_duration: The length of the rental period, in days.

• rental_rate: The cost to rent the film for the period specified in the rental_duration column.

• length: The duration of the film, in minutes.

• replacement_cost: The amount charged to the customer if the film is not returned or is returned in a damaged state.

• rating: The rating assigned to the film. Can be one of: G, PG, PG-13, R, or NC-17.

• special_features: Lists which common special features are included on the DVD. Can be zero or more of: Trailers, Commentaries, Deleted Scenes, Behind the Scenes.

• last_update: When the row was created or most recently updated.