sakila

Custom SQL query

Tables

actor

actor_id, first_name, last_name, last_update

200 rows

address

address_id, address, address2, district, city_id, postal_code, phone, last_update

603 rows

category

category_id, name, last_update

16 rows

city

city_id, city, country_id, last_update

600 rows

country

country_id, country, last_update

109 rows

customer

customer_id, store_id, first_name, last_name, email, address_id, active, create_date, last_update

599 rows

film

film_id, title, description, release_year, language_id, original_language_id, rental_duration, rental_rate, length, replacement_cost, rating, special_features, last_update

1,000 rows

film_actor

actor_id, film_id, last_update

5,462 rows

film_category

film_id, category_id, last_update

1,000 rows

film_text

film_id, title, description

1 row

inventory

inventory_id, film_id, store_id, last_update

4,581 rows

language

language_id, name, last_update

6 rows

payment

payment_id, customer_id, staff_id, rental_id, amount, payment_date, last_update

16,049 rows

rental

rental_id, rental_date, inventory_id, customer_id, return_date, staff_id, last_update

16,044 rows

staff

staff_id, first_name, last_name, address_id, picture, email, store_id, active, username, password, last_update

2 rows

store

store_id, manager_staff_id, address_id, last_update

2 rows

Views

Download SQLite DB: sakila.db 5.9 MB