Skip to main content

Workflow Value Conversions

Summary​

The model uses eight explicit enum-to-string conversions and four structured JSON columns. No owned value-object or decimal precision mapping exists.

Enum conversions​

Definition status; step approver type, step type and mode; instance status; task approver type and status; and action type are stored as bounded strings.

Structured JSON​

Instance context, audit details, timeline metadata and outbox payload are stored in structured JSON columns. Serialization occurs in command/input handling, writer adapters or shared outbox serialization.

Timestamp compatibility​

Runtime and design-time setup enable the provider’s legacy timestamp behavior. Date/time fields otherwise use CLR date/time-offset types as shown in the migration.

Defaults and precision​

Domain/CLR initializers supply values such as operational status/category/time. No database default expression, precision mapping or custom value converter beyond enums was found.

Requires Confirmation​

Timestamp compatibility retirement, JSON schema governance and database-default policy require confirmation.

Source References​

  • microservices/src/workflow-service/Infrastructure/WorkflowDbContext.cs
  • microservices/src/workflow-service/Program.cs
  • microservices/src/workflow-service/Infrastructure/Persistence.cs

See Also​

Keywords​

Workflow database, EF Core, Workflow schema.

Revision Information​

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