Downloads
Schema explorer

Databases & Relationships

Explore any sample database live. Drag the tables around, see every primary and foreign key, and click a relationship to try each kind of join.

About this database

Pick an engine and database above to explore it.

๐ŸŽฎ Now build one yourself: the Model builder game โ†’

๐Ÿ’ก How to read this page

In the mind map, click any table to center on it; solid lines are declared foreign keys and dashed lines are inferred from column names. The cards list each tableโ€™s columns; the ๐Ÿ”‘ marks the primary key, and the ๐Ÿ”— marks columns that reference another table (either a declared foreign key, or a column named like SomethingId by convention). New to all this? Start with the beginner guide.

Legend

๐Ÿ”‘Primary key โ€” unique identifier
๐Ÿ”—Foreign / reference key โ€” links to another table
๐Ÿ“Regular field โ€” data column

Table relationships

๐Ÿ“ Example queries

๐Ÿš€ Try these in the Playground