Templates
Start from a well-structured schema and make it yours.
Multi-tenant SaaS
Organizations, members, roles, plans and subscriptions with tenant-scoped data.
6 tables · 6 relationships
E-commerce store
Customers, catalog, categories, orders, payments and shipping addresses.
7 tables · 8 relationships
Blog & CMS
Authors, posts, tags, comments and revisions with draft/publish workflow.
6 tables · 7 relationships
Project management
Workspaces, projects, tasks with assignees, labels, comments and time tracking.
8 tables · 12 relationships
Social network
Profiles, follows, posts, likes, direct messages and notifications.
8 tables · 11 relationships
Double-entry ledger
Accounts, journal entries and balanced postings for an accounting system.
5 tables · 7 relationships
Geospatial store locator
PostGIS regions, stores, delivery zones, vehicles and routes with spatial indexes.
6 tables · 5 relationships
AI knowledge base (pgvector)
Documents split into chunks with vector embeddings, HNSW similarity search and trigram text search.
6 tables · 6 relationships
Time-series readings (partitioned)
Devices and metrics with a monthly RANGE-partitioned readings table, BRIN index and alert rules.
6 tables · 7 relationships
Room booking (no double-booking)
Buildings, rooms, amenities and bookings, with an EXCLUDE constraint that makes overlapping bookings impossible.
6 tables · 5 relationships
CRM
Companies, contacts, deals moving through pipeline stages, and the activities logged against them.
7 tables · 10 relationships
Helpdesk and ticketing
Customers, tickets with priorities and statuses, agent assignment, replies and tags.
7 tables · 7 relationships
Inventory and warehouse
Products, warehouses and bins, stock levels, purchase orders and the movements that change them.
8 tables · 10 relationships
HR and employee directory
Employees, departments, positions, reporting lines, leave requests and balances.
6 tables · 9 relationships
Learning management (LMS)
Courses made of modules and lessons, enrollments and progress, quizzes and attempts.
8 tables · 10 relationships
Clinic and appointments
Patients, practitioners, their schedules, appointments, visit notes and prescriptions.
7 tables · 6 relationships
Restaurant ordering
Menu categories and items with modifiers, tables, orders, order lines and payments.
7 tables · 6 relationships
Hotel reservations
Properties, room types and rooms, nightly rates, guests, reservations and stays.
7 tables · 7 relationships
Event ticketing
Organizers, events and venues, ticket types with capacity, orders and the tickets issued.
7 tables · 6 relationships
Subscription billing
Customers, plans and prices, subscriptions, invoices with line items, payments and credits.
7 tables · 7 relationships
Multi-vendor marketplace
Vendors with their own listings, buyers, carts, orders split by vendor, payouts and reviews.
7 tables · 8 relationships
Job board and applicant tracking
Employers, job postings, candidates, applications moving through hiring stages and interviews.
8 tables · 8 relationships
Real estate listings
Agents and agencies, properties and their photos, listings for sale or rent, viewings and offers.
7 tables · 6 relationships
Library management
Books and copies, authors, members, loans with due dates, reservations and fines.
8 tables · 8 relationships
Fitness and workout tracker
Exercises and muscle groups, workout plans, logged sessions with sets, and body measurements.
8 tables · 9 relationships
Music streaming catalog
Artists, albums and tracks, genres, listeners, playlists and the plays that feed recommendations.
9 tables · 9 relationships
Video streaming
Titles, seasons and episodes, cast, profiles, watchlists and watch history with resume position.
9 tables · 10 relationships
Chat and messaging
Workspaces, channels and direct messages, threaded messages, reactions, attachments and read state.
7 tables · 9 relationships
Q&A forum
Questions, answers and comments, tags, votes, accepted answers and reputation.
7 tables · 12 relationships
Survey and form builder
Surveys with ordered questions and choices, respondents, responses and the answers to each question.
6 tables · 7 relationships
Feature flags and audit log
Projects and environments, flags with targeting rules and variants, segments and an audit trail.
8 tables · 12 relationships
IoT devices and telemetry
Customers, sites, devices and firmware, sensors, readings and alert rules with their events.
8 tables · 7 relationships
API platform: keys, usage and webhooks
Developer accounts, applications and API keys, rate limits, usage records and webhook deliveries.
7 tables · 6 relationships
School management
Students and guardians, classes and subjects, teachers, enrollments, attendance and grades.
9 tables · 10 relationships