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.

DBDiagrams.com - professor
  • subscription-tracking data model

    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.

    Read more: Subscription Tracking
  • Data model Art Gallery system visualized in Luna Modeler

    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.

    Read more: Art Gallery
  • Auction System data model for PostgreSQL

    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.

    Read more: Auction System
  • A diagram showing an e-commerce system for MySQL

    E-Commerce System

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

    Read more: E-Commerce System
  • Sport tournaments - data model sample for PostgreSQL

    Sport Tournaments

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

    Read more: Sport Tournaments
  • ERD for SQL Server - AdventureWorks sample

    AdventureWorks

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

    Read more: AdventureWorks
  • ER diagram - osTicket

    osTicket – ER Diagram

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

    Read more: osTicket – ER Diagram
  • Pagila - Sample for PostgreSQL. A screenshot of the ER diagram made with Luna Modeler

    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.

    Read more: Pagila
  • MariaDB entity relationship diagram for Drupal

    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.

    Read more: Drupal CMS – online ER diagram
  • MariaDB ERD - MediaWiki

    MediaWiki – online ER diagram

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

    Read more: MediaWiki – online ER diagram
  • Entity relationship diagram for Joomla CMS

    Joomla! CMS – online ER diagram

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

    Read more: Joomla! CMS – online ER diagram
  • ERD WordPress

    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.

    Read more: WordPress CMS – online ER diagram
  • SuiteCRM - database diagram

    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.

    Read more: SuiteCRM – online ER diagram
  • ERD Sample - Opencart

    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

    Read more: OpenCart – online ER diagram
  • ER Diagram - phpBB forum

    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.

    Read more: phpBB forum – database diagram
  • Entity relationship diagram - MariaDB or MySQL. Moodle.

    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.

    Read more: Moodle – online ER diagram