Sakila schema
Tables and views
Explore the native recordsets with their real names, schema, relationships, row counts, and direct downloads.
table actor Performers available to be associated with films. 4 columns · 0 links · 200 rows · 1 matches in other samples table address Customer, staff, and store addresses, including the source's location geometry as a binary value. 9 columns · 1 links · 603 rows · 4 matches in other samples table category Film categories used to classify the catalogue. 3 columns · 0 links · 16 rows · 1 matches in other samples table city Cities associated with addresses and countries. 4 columns · 1 links · 600 rows · 2 matches in other samples table country Countries associated with cities. 3 columns · 0 links · 109 rows · 1 matches in other samples table customer People registered to rent films from a store. 9 columns · 2 links · 599 rows · 4 matches in other samples table film The film catalogue, including language, rating, rental terms, and special features. 13 columns · 2 links · 1,000 rows · 4 matches in other samples table film_actor The many-to-many association between films and actors. 3 columns · 2 links · 5,462 rows · 2 matches in other samples table film_category The many-to-many association between films and categories. 3 columns · 2 links · 1,000 rows · 2 matches in other samples table film_text Search-oriented title and description copy maintained from the film catalogue by the source trigger. 3 columns · 0 links · 1,000 rows table inventory Film copies held by stores and available for rental. 4 columns · 2 links · 4,581 rows · 3 matches in other samples table language Languages used for original and dubbed films. 3 columns · 0 links · 6 rows · 1 matches in other samples table payment Customer payments recorded for rentals and staff transactions. 7 columns · 3 links · 16,044 rows · 3 matches in other samples table rental Film inventory rentals by customers and staff. 7 columns · 3 links · 16,044 rows · 4 matches in other samples table staff Store staff, including source PNG profile pictures stored as BLOBs. 11 columns · 2 links · 2 rows · 4 matches in other samples table store Rental locations and their managers. 4 columns · 2 links · 2 rows · 4 matches in other samples view actor_info Actor names with their film titles grouped by category, derived from the source view's ordered aggregates. 4 columns · 0 links · 200 rows view customer_list 9 columns · 0 links · 599 rows view film_list 8 columns · 0 links · 1,000 rows view nicer_but_slower_film_list 8 columns · 0 links · 1,000 rows view sales_by_film_category 2 columns · 0 links · 16 rows view sales_by_store 3 columns · 0 links · 2 rows view staff_list 8 columns · 0 links · 2 rows
Relationship map