agent-platform/docs/agent-platform-database-design.md

Agent Platform Database Design

This document now describes a single-workspace deployment. Business tables are keyed by their own primary IDs and foreign keys only; no workspace partition column is part of the schema.

Core Rule

Do not add partition fields for workspace isolation to API payloads, domain contracts, SQLAlchemy models, indexes, or migrations.

Primary Domains

• Auth: users, roles, role assignments, tokens, permission checks.
• Workflow: apps, app versions, workflow definitions, workflow versions.
• Runtime: workflow runs, node runs, logs, artifacts, traces.
• Agent, team, tool, skill, memory, knowledge, human task, event, scheduler, and gateway domains use direct entity identifiers and service-local indexes.