Database Schema Examples

Complete database schemas for real systems, each one a working diagram rather than a picture. Every table, relationship and constraint is explained, and each schema is split into context views so you can read one part of the domain at a time. Open any of them in Schemity Lite and edit your own copy.

Multi-Tenant SaaS Database Schema: 17 Tables for Tenants, Sign-In, Roles and Billing
PostgreSQL 17 entities 5 context views
Multi-Tenant SaaS Database Schema: 17 Tables for Tenants, Sign-In, Roles and Billing
A multi-tenant SaaS database schema in PostgreSQL: 17 tables for tenants, members, password and SSO sign-in, roles, billing and projects, wi...
Library Management Database Schema: 12 Tables for PostgreSQL and MySQL
PostgreSQL 12 entities 3 context views
Library Management Database Schema: 12 Tables for PostgreSQL and MySQL
A complete library management database schema for PostgreSQL and MySQL: 12 tables for books, copies, branches, patrons, loans, holds and fin...
Property Management Database Schema: 13 Tables in PostgreSQL
PostgreSQL 13 entities 5 context views
Property Management Database Schema: 13 Tables in PostgreSQL
A complete PostgreSQL property management database schema: 13 tables for properties, units, tenants, leases, invoices and maintenance, with...