Skip to main content

Workflow Condition Storage

Summary​

WorkflowCondition is a tenant-tagged child of one version and associates routing data with a step order.

Mapping​

The application assigns its GUID. Field, operator and value are required and length-bounded. Step order and tenant are stored directly.

Relationship​

A required version foreign key cascades from version deletion. The migration/model provides the foreign-key index. Tenant filtering applies.

Lifecycle​

Conditions are rebuilt with steps when draft contents are replaced. Runtime associates them to stages by matching step order.

Limitations​

No uniqueness constraint, operator check constraint, typed value storage or explicit relationship to one step exists.

Requires Confirmation​

Condition schema evolution, operator governance and indexing for complex routing 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