Skip to main content

Workflow Audit and Timeline Storage

Summary​

Audit and timeline are separate tenant-filtered operational entities written by adapters and saved with command changes.

Audit storage​

Audit rows contain entity reference, action, actor, optional structured details and occurrence time. Required text fields have length limits. Tenant/time is indexed.

Timeline storage​

Timeline rows contain entity reference, entry type, category, actor, optional description/structured metadata and occurrence time. Tenant/time is indexed.

Save behavior​

Command handlers call writer ports before the unit-of-work save. Writers add rows to the same DbContext without independent saves.

Query behavior​

Both feeds are read newest-first with a bounded item count and no tracking.

Limitations​

No foreign keys connect entity references to canonical rows. No retention, partitioning, immutability control or dedicated public projection exists.

Requires Confirmation​

Retention, access governance, entity-reference integrity and archival require confirmation.

Source References​

  • microservices/src/workflow-service/Infrastructure/WorkflowDbContext.cs
  • microservices/src/workflow-service/Infrastructure/Persistence.cs
  • microservices/src/workflow-service/Application/Queries/WorkflowQueries.cs

See Also​

Keywords​

Workflow database, EF Core, Workflow schema.

Revision Information​

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