Author

Experienced Oldie

Database developer and data modeler who has spent long enough with schemas to know that every good database starts with a good diagram.

23 posts · writing since 2021

About the author

Experienced Oldie is the pen name of the database developer behind DB Diagrams. The name says it all: someone who has designed, reverse engineered and documented databases for long enough to have seen the same mistakes in many different systems, and who prefers to learn from a good diagram rather than from a production incident.

On this site, Experienced Oldie publishes sample data models for common business domains, ER diagrams of popular open-source systems such as WordPress, Drupal, Moodle or SuiteCRM, and articles on data modeling, database design and tools for database developers. The posts cover MongoDB, PostgreSQL, MySQL, SQL Server and MariaDB.

The diagrams are drawn in Luna Modeler, so you can open each of them, look at the SQL code and adapt the design to your own project. The goal is not breathtaking documentation, but a different perspective on database structures: see how others have solved a problem, and find what you would do differently.

Have a suggestion, found an error, or would you like to publish your own data model? Write to dbdiagrams(at)dbdiagrams.com.

Posts by Experienced Oldie

Newest first

6 data models, 11 ER diagrams and 6 articles.

Mar 1, 2026 · 6 min read

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…

MongoDB Data model · Oct 3, 2025

Subscription Tracking Data Model for noSQL

Subscription tracking data model for MongoDB: licenses, payments, licensees and history as document collections. View the diagram.

PostgreSQL Data model · Sep 5, 2025

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.

PostgreSQL Data model · Sep 5, 2025

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.

PostgreSQL Data model · Sep 5, 2025

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.

Sep 5, 2025 · 2 min read

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.…

MySQL Data model · Sep 4, 2025

E-Commerce System

Sample data model for an e-commerce system created for the MySQL database platform.

Sep 4, 2025 · 1 min read

What is a Data Model?

In this article you will learn what a data model is and why it is so important in databases.

PostgreSQL Data model · Sep 3, 2025

Sport Tournaments

A sample data model created for PostgreSQL. The data model contains ENUM, an object specific for PostgreSQL database platform.

SQL Server ER diagram · Jul 21, 2023 MIT License

AdventureWorks

Microsoft has made available an example database called AdventureWorks that is intended for testing and demonstrating different Microsoft SQL Server functionalities.

MariaDB ER diagram · Jul 21, 2023 GPL v2

osTicket – ER Diagram

by osTicket.com: osTicket is a robust customer support portal system to help your business maintain happy customer relationships.

May 16, 2023 · 2 min read

Creating a Database Diagram

Database diagrams are powerful visual representations of the structure and relationships within a database. Learn how to easily create database designs from scratch or by loading existing database structures.

PostgreSQL ER diagram · Aug 26, 2021 PostgreSQL License

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.

MariaDB ER diagram · Aug 23, 2021 GPL v2+

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.

MariaDB ER diagram · Aug 19, 2021 GPL v2+

MediaWiki – online ER diagram

MediaWiki is a collaboration and documentation platform. See the database structure in a form of an entity relationship diagram.

MariaDB ER diagram · Aug 19, 2021 GPL v2+

Joomla! CMS – online ER diagram

Joomla! is a free and open-source content management system (CMS) for publishing web content…

MariaDB ER diagram · Aug 19, 2021 GPL v2+

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.

Aug 19, 2021 · 1 min read

How to open Data Models and ER Diagrams

The ER diagrams that are available here in the form of an HTML report are created in Luna Modeler. It is a tool for creating ER diagrams, data models, database designs and visualizations of existing structures.

MariaDB ER diagram · Aug 18, 2021 AGPL v3

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.

MariaDB ER diagram · Aug 18, 2021 GPL v3

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

MariaDB ER diagram · Aug 18, 2021 GPL v2

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.

MySQL ER diagram · Aug 18, 2021 GPL v3+

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.