Database schema templates and ER diagram examples
Schemas somebody has already worked out, each with its ER diagram. Open a free one in the browser without an account, or copy it into your own workspace and export it as PostgreSQL, MySQL, or SQL Server.
Product Analytics Database Schema
A 27-table product analytics database schema covering events, identity resolution, sessions, feature flags, experiments, funnels, cohorts and dashboards: free ER diagram and DBML.
- tables
- 27
- columns
- 214
- refs
- 48
IoT Device Telemetry Database Schema
A 25-table IoT device telemetry database schema covering devices, gateways, sensor readings, rollups, alerts, commands and firmware rollouts: free ER diagram and DBML.
- tables
- 25
- columns
- 216
- refs
- 51
Multiplayer Game Backend Database Schema
A 30-table multiplayer game backend database schema covering players, wallets, store purchases, matchmaking, ratings, leaderboards, guilds and bans: free ER diagram and DBML.
- tables
- 30
- columns
- 245
- refs
- 67
Photo Sharing Database Schema
A 28-table photo sharing database schema covering profiles, follows, posts and media, comments, likes, stories, notifications and moderation: free ER diagram and DBML.
- tables
- 28
- columns
- 192
- refs
- 60
Music Streaming Database Schema
A 26-table music streaming database schema covering artists, releases, tracks, credits, licensing, playlists, follows, play events, subscriptions and royalties: free ER diagram and DBML.
- tables
- 26
- columns
- 177
- refs
- 40
Restaurant Ordering and POS Database Schema
A 29-table restaurant ordering and POS database schema covering the floor plan, menu, checks, kitchen tickets, voids and comps, payments, cash drawers and day close: free ER diagram and DBML.
- tables
- 29
- columns
- 220
- refs
- 60
Food Delivery Database Schema
A 29-table food delivery database schema covering restaurants, menus with modifiers, orders, couriers, dispatch, tracking, refunds and payouts: free ER diagram and DBML.
- tables
- 29
- columns
- 269
- refs
- 49
Ride-Hailing App Database Schema
A 27-table ride-hailing app database schema covering riders, drivers, vehicles, dispatch offers, trips, surge pricing, fares and driver payouts: free ER diagram and DBML.
- tables
- 27
- columns
- 260
- refs
- 58
Event Ticketing Database Schema
A 27-table event ticketing database schema covering venues, seat maps, performances, seat inventory, holds, orders, tickets, transfers, refunds and door scans: free ER diagram and DBML.
- tables
- 27
- columns
- 203
- refs
- 56
Vacation Rental Marketplace Database Schema
A 24-table vacation rental marketplace database schema covering listings, a nightly availability calendar, pricing rules, bookings, guest payments, host payouts, blind reviews and messaging: free ER diagram and DBML.
- tables
- 24
- columns
- 214
- refs
- 40
Car Rental Database Schema
A 23-table car rental database schema covering locations, fleet, rate plans, reservations, rental agreements, damage and payments: free ER diagram and DBML.
- tables
- 23
- columns
- 174
- refs
- 45
CRM Database Schema
A 24-table CRM database schema covering accounts, contacts, leads, pipelines, opportunities, forecast history, products, quotes and activities: free ER diagram and DBML.
- tables
- 24
- columns
- 216
- refs
- 59
Project Management Database Schema
A 26-table project management database schema covering workspaces, projects, custom workflows, issues, sprints, comments, time tracking and custom fields: free ER diagram and DBML.
- tables
- 26
- columns
- 179
- refs
- 57
Employee and Payroll Management Database Schema
A 25-table employee and payroll database schema covering employees, effective-dated pay and roles, time and leave, deductions, pay runs and pay stubs: free ER diagram and DBML.
- tables
- 25
- columns
- 187
- refs
- 43
Student Information System Database Schema
A 28-table student information system database schema covering students, courses, sections, enrollment, grades, transcripts and student accounts: free ER diagram and DBML.
- tables
- 28
- columns
- 175
- refs
- 46
Library Management System Database Schema
A 24-table library management system database schema covering books, copies, members, loans, holds, fines and acquisitions: free ER diagram and DBML.
- tables
- 24
- columns
- 164
- refs
- 45
Reddit Clone Database Schema
A 108-table Reddit clone database schema with subreddits, karma, hot/best/top ranking, nested comment trees, awards and coins, AutoMod, modmail, chat and the full ad stack — free ER diagram and DBML.
- tables
- 108
- columns
- 890
- refs
- 201
Airline Reservation Database Schema
A 34-table airline reservation database schema with flights, fares, seat inventory, PNR bookings, tickets and coupons, check-in, baggage and loyalty — free ER diagram and DBML.
- tables
- 34
- columns
- 261
- refs
- 56
Forum Database Schema
A 15-table forum database schema with boards, topics, threaded replies, voting, subscriptions, reputation badges and moderation — free ER diagram and DBML.
- tables
- 15
- columns
- 112
- refs
- 31
Blog Database Schema
A 15-table blog database schema with posts, revisions, categories, tags, comments, media, subscribers, SEO metadata and redirects — free ER diagram and DBML.
- tables
- 15
- columns
- 114
- refs
- 19
Banking System Database Schema
A 34-table core banking database schema built on a double-entry ledger — accounts, transactions, transfers, cards, loans, KYC, statements and audit. Free ER diagram and DBML.
- tables
- 34
- columns
- 305
- refs
- 75
Learning Management System Database Schema
A 34-table LMS database schema with courses, modules, lessons, cohorts, enrolment, progress tracking, assignments, rubrics, quizzes, gradebook and certificates — free ER diagram and DBML.
- tables
- 34
- columns
- 252
- refs
- 59
Social Media Database Schema
A 35-table social media database schema with follows, posts, likes, comments, stories, direct messaging, feeds and moderation — free ER diagram and DBML.
- tables
- 35
- columns
- 203
- refs
- 66
Hotel Booking Database Schema
A 16-table hotel booking database schema with per-night rates and availability, reservations, guests, payments, housekeeping and reviews — free ER diagram and DBML.
- tables
- 16
- columns
- 134
- refs
- 23