Skip to main content

Workflow Action Storage

Summary​

WorkflowAction is a tenant-tagged child of one instance and records aggregate actions.

Mapping​

The application assigns its GUID. Instance and tenant identifiers, action type and occurrence time are stored. Task identifier, actor email and comment are optional. Action type converts to text.

Relationship and index​

The required instance relationship cascades on instance deletion. An index supports instance action lookup. Task identifier is not configured as a foreign key. Tenant filtering applies.

Lifecycle​

Start, approve, reject, delegate and complete append records. The enum includes Cancel, but no implemented command writes it.

Limitations​

Append-only intent is enforced by application behavior, not database permissions or triggers. No uniqueness/idempotency constraint exists.

Requires Confirmation​

Immutability enforcement, task referential integrity and long-term audit retention require confirmation.

Source References​

  • microservices/src/workflow-service/Domain/Workflow/WorkflowInstance.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