SaaS database schema examples and ER diagrams
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 (4)
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
SaaS Billing Starter
Subscriptions, invoices and the people who pay them.
- tables
- 10
- columns
- 67
- refs
- 11