According to https://github.com/devrimgunduz/pagila:
“Pagila is a port of the Sakila example database available for MySQL, which was originally developed by Mike Hillyer of the MySQL AB documentation team. It is intended to provide a standard schema that can be used for examples in books, tutorials, articles, samples, etc.“
For more information visit https://github.com/devrimgunduz/pagila
HTML report / online ER diagram
Here you can find the ER diagram created by loading the database structure from the Pagila schema installed on PostgreSQL 13.
When you click on a database table in the online ER diagram, a new window opens where you can see the details of the table, including defined indexes and other details.
The Pagila database design includes definitions of tables, relationships, foreign keys, functions, triggers, domains and views.
Details
Target database:
PostgreSQL 13
Diagram URL:
https://www.dbdiagrams.com/online-diagrams/Pagila-2-1-0
Luna Modeler project file:
https://www.dbdiagrams.com/online-diagrams/pagila.dmm
How to open a data model file in Luna Modeler
About Luna Modeler
Luna Modeler is an intuitive data modeling tool for relational databases.
With this powerful tool, you can create ER diagrams, design and visualize database structures, generate SQL scripts, and document your data models with ease. A feature-limited trial version is available for Windows, macOS and Linux.
For more information visit https://www.datensen.com
If you have suggestions or comments, send us a message to dbdiagrams(at)dbdiagrams.com.