Subscription Tracking Data Model for noSQL
Subscription tracking data model for MongoDB: licenses, payments, licensees and history as document collections. View the diagram.
Free library of database designs
Data models. ER diagrams. Database designs.
Discover how database structures are built and organized. Explore ready-to-use data models for common use cases and interactive ER diagrams of popular open-source systems.
- Data models
- 6
- ER diagrams
- 11
- Platforms
- 5
Browse by database platform
Data models
Start from a proven design
Sample data models for common business domains. Adapt them to the needs of your own project.
Subscription Tracking
This 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
Data 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
In 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
Sample data model for an e-commerce system created for the MySQL database platform.
Sport Tournaments
A sample data model created for PostgreSQL. The data model contains ENUM, an object specific for PostgreSQL database platform.
ER diagrams
Extend a real system, or build your own
Interactive diagrams reverse engineered from WordPress, Drupal, Moodle and other open-source systems. Planning a plugin? Find the tables you will work with and design your amendments. Starting something new? Learn from data models that run thousands of sites.
AdventureWorks
Microsoft has made available an example database called AdventureWorks that is intended for testing and demonstrating different Microsoft SQL Server functionalities.
osTicket – ER Diagram
by osTicket.com: osTicket is a robust customer support portal system to help your business maintain happy customer relationships.
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.
Drupal CMS – online ER diagram
Drupal 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
MediaWiki is a collaboration and documentation platform. See the database structure in a form of an entity relationship diagram.
Joomla! CMS – online ER diagram
Joomla! is a free and open-source content management system (CMS) for publishing web content…
WordPress CMS – online ER diagram
According 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
From 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
By 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
By 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
From 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.
How it works
From a diagram to a better system
-
Pick a design
Browse data models and ER diagrams by database platform or by the kind of system you are building.
-
Explore the diagram
Every diagram is an interactive report. Click a table to see its columns, keys, indexes and relationships.
-
Extend or improve
Open the project file in Luna Modeler to plan an extension or an improvement you can contribute back, within the license of the system.
Blog
Learn data modeling
Top 5 Data Modeling Software Products to Know in 2026
Data modelling is a key skill for any data professional. It helps to design, organize and optimize data structures and processes. But how do you choose the right tool for the right type of data model? In this blog post, I’ll introduce you to five data modeling software options, each of which is suitable for…
Best Data Modeling Tools in 2026: A Practical Guide for Developers, Architects, and Data Teams
If you’ve ever built a database without a clear plan, you know how fast things can spiral. Tables get messy. Relationships break. Queries slow down. That’s why data modeling matters – and why the right tool can save you hours of rework. In this guide, you’ll discover the 6 best data modeling tools in 2026,…
How to Set Up PostgreSQL with Docker Desktop
When you’re designing databases – especially physical data models – it’s a good idea to use a testing environment that’s simple to create. For example, if you’re interested in working with the PostgreSQL database, you don’t need to install it directly on your computer. But you can easily create a test environment using Docker Desktop.…
Open any diagram in Luna Modeler
View the SQL code, edit the diagram or start your own project from one of the data models.