Skip to main content

Workflow Version Storage

Summary​

WorkflowVersion is a tenant-tagged child of one definition and parent of steps and conditions.

Mapping and lifecycle​

The application assigns its GUID. Stored state includes definition foreign key, tenant, version number, publication flag/time and creation time. Draft replacement rebuilds children; publication makes later domain replacement invalid.

Relationships​

Definition-to-version, version-to-step and version-to-condition relationships are required and cascade on parent deletion.

Indexes and constraints​

Definition identifier plus version number is unique. A tenant query filter applies. Foreign-key indexes are represented by the migration/model.

Limitations​

No row version, version-level soft delete, checksum, author metadata or rollback marker exists.

Requires Confirmation​

Version retention, rollback and audit ownership require confirmation.

Source References​

  • microservices/src/workflow-service/Domain/Workflow/WorkflowDefinition.cs
  • microservices/src/workflow-service/Infrastructure/WorkflowDbContext.cs
  • microservices/src/workflow-service/Infrastructure/Migrations/20260706165438_InitialWorkflowSchema.cs

See Also​

Keywords​

Workflow database, EF Core, Workflow schema.

Revision Information​

  • Status: Draft
  • Last reviewed: 2026-07-20
  • Next review: 2026-10-20