Sakila Data Base ER diagram

This ER diagram shows the main entities and foreign key relationships for the Sakila database.

Sakila Database ERD Entity relationship diagram for Sakila with 15 core tables and explicit foreign key connectors. country PKcountry_id country last_update city PKcity_id FKcountry_id -> country city last_update address PKaddress_id FKcity_id -> city address district phone postal_code last_update store PKstore_id FKmanager_staff_id -> staff FKaddress_id -> address last_update staff PKstaff_id FKaddress_id -> address FKstore_id -> store first_name last_name email username active password picture last_update language PKlanguage_id name last_update category PKcategory_id name last_update film_actor PKFKactor_id PKFKfilm_id last_update film PKfilm_id FKlanguage_id -> language FKoriginal_language_id -> lang title description release_year rental_duration rental_rate length rating special_features replacement_cost last_update inventory PKinventory_id FKfilm_id -> film FKstore_id -> store last_update film_category PKFKfilm_id PKFKcategory_id last_update actor PKactor_id first_name last_name last_update customer PKcustomer_id FKstore_id -> store FKaddress_id -> address first_name last_name email active create_date last_update rental PKrental_id FKinventory_id -> inventory FKcustomer_id -> customer FKstaff_id -> staff rental_date return_date last_update payment PKpayment_id FKcustomer_id -> customer FKstaff_id -> staff FKrental_id -> rental amount payment_date last_update Legend PKPrimary key FKForeign key Child table points to parent table One line per FK relationship No path through table bodies N:1 N:1