Skip to main content

Asset Management Database Documentation

Summary​

Complete Draft persistence documentation for the source-backed Asset Management EF Core model: the AssetDbContext, its seven persisted object sets, the Asset aggregate and its children, tenant query filters, the transactional outbox, compatibility identity, migrations, development seeding, and the transitional backfill.

Audience​

Backend engineers, database reviewers, architects, QA, support, operations, security reviewers, and product owners responsible for Asset Management data.

Overview​

Asset Management persists through one runtime AssetDbContext (Npgsql / PostgreSQL, EF Core 8), a derived backfill context that reuses the same model with transition-specific identity generation, and a design-time context factory. The verified model contains seven persisted object sets across seven tables, seven Guid primary keys, two aggregate-child foreign keys (both cascade), four owned value-object mappings, five tenant query filters, fourteen non-primary-key indexes in the model snapshot, and one authored migration.

The implementation remains Transitional because compatibility identity and backfill paths coexist with canonical persistence, and because production governance, concurrency, retention, and final system-of-record ownership require confirmation.

Documentation map​

  1. Database Overview
  2. Persistence Architecture
  3. Ownership and Boundaries
  4. DbContext and Object Sets
  5. Asset Storage
  6. Assignment History Storage
  7. Document Reference Storage
  8. Workflow Reference Storage
  9. Compatibility Identity Storage
  10. Audit and Timeline Storage
  11. Outbox Storage
  12. Processed Event Storage
  13. Tenant Isolation
  14. Entity Mappings
  15. Keys and Relationships
  16. Indexes and Constraints
  17. Value-Object Conversions
  18. Query Patterns
  19. Data Integrity
  20. Transactions and Save Boundaries
  21. Concurrency
  22. Migrations and Snapshot
  23. Development Seeding
  24. Compatibility Backfill
  25. Retention and Cleanup
  26. Database Testing Guide
  27. Schema Reference
  28. Database Limitations
  29. Source Map

Requires confirmation​

Production ownership, migration governance, retention, recovery, concurrency policy, tenant access exceptions, compatibility retirement, reconciliation sign-off, and final system-of-record status require confirmation.

Source References​

  • microservices/src/asset-service/Infrastructure/AssetDbContext.cs
  • microservices/src/asset-service/Infrastructure/Persistence.cs
  • microservices/src/asset-service/Domain/Asset/Asset.cs
  • microservices/src/asset-service/Infrastructure/Migrations/AssetDbContextModelSnapshot.cs
  • microservices/src/asset-service/Backfill/AssetRecordBackfill.cs
  • microservices/scripts/smoke-asset.ps1

See Also​

Keywords​

  • Asset persistence
  • EF Core
  • Database documentation

Revision Information​

  • Status: Draft
  • Last reviewed: 2026-07-17
  • Review cycle: Quarterly