ADR 007: One database across products
- Status: Proposed
- Owner: Security reviewer
- Date: 2026-11-12
Context
Separate clusters per product cost more and complicate operations.
Decision
One PostgreSQL database with composite foreign keys (id, environment_id, tenant_id) so rows cannot reference another project's or tenant's conversation. A dedicated Fidescript store if the security review requires it.
Consequences
Isolation is enforced by schema, not only by queries (tested). RLS can be added as defense in depth.