Documentation

ChatPilot

Database Schema

Database table groups, pgvector requirements, and index guidance.

![Database entity relationship diagram](/img/database-erd.svg)

The schema has core tables grouped into tenancy, conversations, commerce, campaigns, content/vector search, analytics, integrations, and idempotency.

Enable pgvector. Add tenant_id indexes on tenant-scoped tables, GIN indexes on JSONB fields used in filters, and HNSW indexes on embedding columns.