Data Models.
ER Diagrams.
Database Designs.
Discover how database structures are built and organized.
Our growing library contains data models and database designs for various use cases. You will also find here ER diagrams based on open source systems.

-
Subscription Tracking
Read more: Subscription TrackingThis sample model serves as a basis for creating a subscription management system. The goal is to store information about purchased software licenses, subscription payments, licensees assigned to users, and tracking history.
-
Art Gallery
Read more: Art GalleryData model for Art, Gallery, and Exhibitions management. This model uses subject areas, which, in more complex diagrams, help to group tables that belong together for various reasons. Groups of objects include Artist, Artwork, Gallery, Exhibition, Sale, and Loan.
-
Auction System
Read more: Auction SystemIn this data model, you will find the structure for the Auction System. The basic elements are User, Auction, Bid, Payment, and Shipping. The target database is PostgreSQL.
-
E-Commerce System
Read more: E-Commerce SystemSample data model for an e-commerce system created for the MySQL database platform.
-
Sport Tournaments
Read more: Sport TournamentsA sample data model created for PostgreSQL. The data model contains ENUM, an object specific for PostgreSQL database platform.
-
AdventureWorks
Read more: AdventureWorksMicrosoft has made available an example database called AdventureWorks that is intended for testing and demonstrating different Microsoft SQL Server functionalities.
-
osTicket – ER Diagram
Read more: osTicket – ER Diagramby osTicket.com: osTicket is a robust customer support portal system to help your business maintain happy customer relationships.
-
Pagila
Read more: PagilaPagila 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.
-
Drupal CMS – online ER diagram
Read more: Drupal CMS – online ER diagramDrupal is content management software. It’s used to make many of the websites and applications you use every day. Drupal has great standard features, like easy content authoring, reliable performance, and excellent security.
-
MediaWiki – online ER diagram
Read more: MediaWiki – online ER diagramMediaWiki is a collaboration and documentation platform. See the database structure in a form of an entity relationship diagram.
-
Joomla! CMS – online ER diagram
Read more: Joomla! CMS – online ER diagramJoomla! is a free and open-source content management system (CMS) for publishing web content…
-
WordPress CMS – online ER diagram
Read more: WordPress CMS – online ER diagramAccording to WordPress.com: WordPress is open source software you can use to create a beautiful website, blog, or app. See the ERD here.
-
SuiteCRM – online ER diagram
Read more: SuiteCRM – online ER diagramFrom suiteCRM.com: Feature-rich enterprise-ready alternative to Salesforce provides all the benefits of CRM at substantially lower costs with the freedoms and flexibility of Open Source.
-
OpenCart – online ER diagram
Read more: OpenCart – online ER diagramBy OpenCart.org: Opencart is an easy to-use, powerful, Open Source online store management program that can manage multiple online stores from a single back-end
-
phpBB forum – database diagram
Read more: phpBB forum – database diagramBy phpbb.com: phpBB is a free flat-forum bulletin board software solution that can be used to stay in touch with a group of people or can power your entire website.
-
Moodle – online ER diagram
Read more: Moodle – online ER diagramFrom moodle.org: Moodle is a learning platform designed to provide educators, administrators and learners with a single robust, secure and integrated system to create personalised learning environments.