SaaS database schemas
What a SaaS schema usually contains
A SaaS schema has to answer who belongs to which account before it answers anything else. These templates model tenancy, membership and roles as first-class tables, with subscriptions and invoices hanging off the account rather than the user.
Templates (11)
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
Inventory Management Database Schema
A 16-table inventory management database schema with stock ledger, bin locations, purchase orders, goods receipts, transfers and cycle counts — free ER diagram and DBML.
- tables
- 16
- columns
- 126
- refs
- 29
Hospital Management System Database Schema
A 38-table hospital management system database schema covering patients, doctors, appointments, admissions, prescriptions, lab results and billing — free ER diagram and DBML.
- tables
- 38
- columns
- 272
- refs
- 67
E-commerce Database Schema
A complete 36-table e-commerce database schema with products, variants, cart, orders, inventory, payments and returns — free ER diagram and DBML.
- tables
- 36
- columns
- 236
- refs
- 46
SaaS Billing Starter
Subscriptions, invoices and the people who pay them.
- tables
- 10
- columns
- 67
- refs
- 11