sakila

Tables (3)

film (Untitled)

  • film_id — SMALLINT — Primary key — NOT NULL
  • title — VARCHAR
  • description — TEXT
  • release_year — YEAR
  • language_id — TINYINT — NOT NULL
  • original_language_id — TINYINT
  • rental_duration — TINYINT
  • rental_rate — DECIMAL — NOT NULL
  • length — SMALLINT
  • replacement_cost — DECIMAL — NOT NULL
  • rating — DECIMAL — NOT NULL
  • special_features — SET — 'Trailers','Commentaries','Deleted Scenes','Behind the Scenes'
  • last_update — TIMESTAMP

film_actor

  • actor_id — SMALLINT — Primary key — NOT NULL
  • film_id — SMALLINT — Primary key — NOT NULL
  • film_id (film_id2) — SMALLINT — Foreign key → film.film_id — NOT NULL
  • last_update — TIMESTAMP — NOT NULL

film_category

  • film_id — SMALLINT — Primary key — NOT NULL
  • category_id — TINYINT — Primary key — NOT NULL
  • film_id (film_id2) — SMALLINT — Foreign key → film.film_id — NOT NULL
  • last_update — TIMESTAMP — NOT NULL