Sakila Database Structure

The Sakila database includes 16 tables, 7 views, 3 stored procedures, 3 stored functions, and 6 triggers.

Sakila Database ER diagram
Sakila Database ER diagram

  1. The actor table

    This article introduces the structure of the actor table in the Sakila database.

  2. The address table

    This article introduces the structure of the address table in the Sakila database.

  3. The category table

    This article introduces the structure of the category table in the Sakila database.

  4. The city table

    This article introduces the structure of the city table in the Sakila database.

  5. The country table

    This article introduces the structure of the country table in the Sakila database.

  6. The customer table

    This article introduces the structure of the customer table in the Sakila database.

  7. The film table

    This article introduces the structure of the film table in the Sakila database.

  8. The film_actor table

    This article introduces the structure of the film_actor table in the Sakila database.

  9. The film_category table

    This article introduces the structure of the film_category table in the Sakila database.

  10. The film_text table

    This article introduces the structure of the film_text table in the Sakila database.

  11. The inventory table

    This article introduces the structure of the inventory table in the Sakila database.

  12. The language table

    This article introduces the structure of the language table in the Sakila database.

  13. The payment table

    This article introduces the structure of the payment table in the Sakila database.

  14. The rental table

    This article introduces the structure of the rental table in the Sakila database.

  15. The staff table

    This article introduces the structure of the staff table in the Sakila database.

  16. The store table

    This article introduces the structure of the store table in the Sakila database.

  17. Views

    The article describes the views in the Sakila sample database.

  18. Stored Procedures

    The article describes the stored procedures in the Sakila sample database.

  19. Stored Functions

    The article describes the stored functions in the Sakila sample database.

  20. Triggers

    The article describes the triggers in the Sakila sample database.