Skip to main content

Core ER Diagram

The core (domain-agnostic) data model, reproduced faithfully. Plugin-specific tables are not shown here — see the Plugin ER Diagram for how they clip on.

Orientation​

  • entity is the plugin registry; workspace_status and workflow are scoped to an entity type via entity_id / belongs_to_entity_id.
  • The workspace carries no FK to any entity object — that relationship is owned by each plugin's join table. Likewise workflow_execution links to the core workspace, not to a plugin entity.
  • The configuration graph — model, agent, prompt_family/prompt/prompt_version, workflow_config/workflow_agent_assignment, service/service_config_set/service_assignment — is the dependency graph behind the disable cascade.
  • workflow_execution carries the four immutable snapshots and links to workflow_execution_log (the per-step, per-cost record) and optionally to itself via retry_of.
  • Core workspace rows are never deleted; there are no is_deleted/is_archived columns here.