Skip to content

Data model

Prisma models

Key entities in prisma/schema.prisma: - Org, OrgMember - Project - ApiKey - Run - Prompt, PromptVersion - Dataset - Experiment - EvalScore - OrgSecret

Important fields: - Run.promptHash, Run.promptPreview (hash‑only mode option) - Run.costUSD (Decimal(10,5)), Run.costSource ("provider"|"catalog"|"estimated"), Run.costEstimated (boolean) - Run.latencyMs, Run.status, Run.errorCode?, Run.traceId? - Experiment.matrixJson, Experiment.gate - ApiKey.keyHash (SHA‑256), ApiKey.keyEnc (encrypted blob) - OrgSecret.keyEnc (BYOK, AES‑GCM)

See also: prisma/models.md, prisma/tables-runs.md

Relations (ER)

erDiagram
  Org ||--o{ OrgMember : has
  Org ||--o{ Project : has
  Org ||--o{ OrgSecret : has
  Project ||--o{ ApiKey : has
  Project ||--o{ Run : has
  Project ||--o{ Prompt : has
  Project ||--o{ Dataset : has
  Project ||--o{ Experiment : has
  Prompt ||--o{ PromptVersion : has
  PromptVersion ||--o{ Experiment : used_by
  Dataset ||--o{ Experiment : used_by
  Experiment ||--o{ Run : produces
  Run ||--o{ EvalScore : has

See also: convex/schema.ts for live telemetry tables (runs_live, kpis_1m).