Database Schema

Overview

Solid# uses PostgreSQL 15 with SQLAlchemy 2.0 ORM. All tables enforce Row-Level Security (RLS) for multi-tenant data isolation. Vector embeddings use pgvector extension.

Multi-Tenancy

Every table includes a company_id column. Row-Level Security policies are enforced at the PostgreSQL level, not just application code.

RLS Policy Example

-- Every query is automatically filtered
CREATE POLICY company_isolation ON contacts
  USING (company_id = current_setting('app.company_id')::int);

-- Application sets context before queries
SET app.company_id = 42;
SELECT * FROM contacts;  -- Only returns company 42's contacts

Table Categories

Table Reference

Showing 18 sample tables