Analytics database schemas
What a Analytics schema usually contains
Analytics schemas separate what happened from what it means. These templates model events, dimensions and rollups so raw capture and reporting are not fighting over the same table.
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