Inventory management schema
Model products, warehouses, stock balances, immutable movements, purchase orders, and received quantities.
Read the worked exampleDatabase Schema Examples
Each example starts with a real design problem, explains the relationships and tradeoffs, and includes SQL DDL you can paste into the diagram generator. These are reference models, not production templates: adapt keys, indexes, retention rules, and security controls to your workload.
Multi-tenant SaaS schema
Separate organizations, memberships, projects, subscriptions, invoices, and audit events without losing tenant boundaries.
Read the worked exampleE-commerce schema
Understand line-item price snapshots, payment attempts, product categories, and order ownership.
Read the worked exampleForeign-key relationship examples
Compare one-to-many, one-to-one, many-to-many, optional, and self-referencing table relationships.
Read the relationship guide