Workflow Database Overview
Summary
Workflow Service uses EF Core with the PostgreSQL provider. A single DbContext owns canonical Workflow aggregates and operational records in its configured default schema.
Persistence architecture
Ownership
The context maps 11 entity sets. Canonical data consists of definitions, versions, steps, conditions, instances, tasks and actions. Operational data consists of audit, timeline, outbox and processed-event records.
Runtime composition
The context is scoped and configured in the service composition root. Repositories, query services, writers, unit of work and outbox store share it within their scope.
Maturity
Core mappings, relationships, indexes, tenant filters and one migration exist. Concurrency, retention, cleanup, broad database testing and production governance remain Partial or Not implemented.
Requires Confirmation
Production topology, database ownership controls, recovery objectives and operational governance require confirmation.
Source References
microservices/src/workflow-service/Program.csmicroservices/src/workflow-service/Infrastructure/WorkflowDbContext.csmicroservices/src/workflow-service/workflow-service.csproj
Related Articles
See Also
Keywords
Workflow database, EF Core, Workflow schema.
Revision Information
- Status: Draft
- Last reviewed: 2026-07-20
- Next review: 2026-10-20