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