← All tables and views
Sakila table
film
The film catalogue, including language, rating, rental terms, and special features.
1,000rows
13 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
film_id | INTEGER | yes | PK | — |
title | TEXT | no | — | — |
description | TEXT | yes | — | — |
release_year | TEXT | yes | — | — |
language_id | INTEGER | no | — | language.language_id |
original_language_id | INTEGER | yes | — | language.language_id |
rental_duration | INTEGER | no | — | — |
rental_rate | NUMERIC | no | — | — |
length | INTEGER | yes | — | — |
replacement_cost | NUMERIC | no | — | — |
rating | TEXT | yes | — | — |
special_features | TEXT | yes | — | — |
last_update | TEXT | no | — | — |
Data preview
Sample records
| film_id | title | description | release_year | language_id | original_language_id | rental_duration |
|---|---|---|---|---|---|---|
| 1 | ACADEMY DINOSAUR | A Epic Drama of a Feminist And a Mad Scientist who must Battle a Teacher in The Canadian Rockies | 2006 | 1 | NULL | 6 |
| 2 | ACE GOLDFINGER | A Astounding Epistle of a Database Administrator And a Explorer who must Find a Car in Ancient China | 2006 | 1 | NULL | 3 |
| 3 | ADAPTATION HOLES | A Astounding Reflection of a Lumberjack And a Car who must Sink a Lumberjack in A Baloon Factory | 2006 | 1 | NULL | 7 |
| 4 | AFFAIR PREJUDICE | A Fanciful Documentary of a Frisbee And a Lumberjack who must Chase a Monkey in A Shark Tank | 2006 | 1 | NULL | 5 |
| 5 | AFRICAN EGG | A Fast-Paced Documentary of a Pastry Chef And a Dentist who must Pursue a Forensic Psychologist in The Gulf of Mexico | 2006 | 1 | NULL | 6 |
| 6 | AGENT TRUMAN | A Intrepid Panorama of a Robot And a Boy who must Escape a Sumo Wrestler in Ancient China | 2006 | 1 | NULL | 3 |
| 7 | AIRPLANE SIERRA | A Touching Saga of a Hunter And a Butler who must Discover a Butler in A Jet Boat | 2006 | 1 | NULL | 6 |
| 8 | AIRPORT POLLOCK | A Epic Tale of a Moose And a Girl who must Confront a Monkey in Ancient India | 2006 | 1 | NULL | 6 |
Interactive explorer