AdventureWorks

View the diagram Open full screen
ERD for SQL Server - AdventureWorks sample

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

You can download the sample from Microsoft’s website or Github.

HTML report / online ER Diagram#

The Database Diagram was created by loading the database structure from locally installed AdventureWorks sample. The target database was SQL Server 2022.

How to use the ER diagram/HTML report: click on a db table in the online ER Diagram. A new window opens – and in the window you can view the details of the table, including how indexes are defined and other details of the selected SQL Server database table.

In this ER diagram you can see tables grouped and aligned to subject areas, for example Person, Production, Purchasing, Sales and DBO etc.

MediaWiki · ER diagramOpen in new tab

Details#

Target database
SQL Server
Luna Modeler project file
https://www.dbdiagrams.com/online-diagrams/adventureworks.dmm
AdventureWorks license
MIT License

Build on AdventureWorks#

Improve the system

Extend AdventureWorks

Planning a plugin, module or extension? Find the tables you will work with, then model your own tables and amendments right next to them, before you write a line of code.

Get inspired

Craft a new system

Building something of your own? Study how AdventureWorks structures its data, take the ideas that work, and design a data model that fits your project.

Respect the license. AdventureWorks is released under the MIT License. This permissive license lets you reuse and adapt the work, as long as you keep the original copyright and license notice. Whatever you build, read the license and follow its terms.

More ER diagrams

All in SQL Server
PostgreSQL ER diagram 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 GPL v2

osTicket – ER Diagram

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

MariaDB ER diagram 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.