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.

  • 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.