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.

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...