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