Skip to main content

Notification Database Source Map

Summary​

One authoritative traceability table from database documentation topic to verified source file. Every file listed exists in the reviewed repository.

Audience​

Engineers, architects, QA, support and security reviewers.

Reference Content​

The verified reference material for this topic is set out in the sections below.

Persistence model​

TopicSource file
Context, DbSets, default schema, all fluent mappings, all 14 indexes, absence of query filters and conversionsmicroservices/src/notification-service/Infrastructure/NotificationDbContext.cs
Design-time factorymicroservices/src/notification-service/Infrastructure/NotificationDbContext.cs
All seven entity shapes and the six string-constant setsmicroservices/src/notification-service/Domain/NotificationEntities.cs

Schema lifecycle​

TopicSource file
Table and index creation, absence of foreign keys and check constraintsmicroservices/src/notification-service/Infrastructure/Migrations/20260705113059_InitialNotificationSchema.cs
Migration model snapshot at generation timemicroservices/src/notification-service/Infrastructure/Migrations/20260705113059_InitialNotificationSchema.Designer.cs
Current model snapshotmicroservices/src/notification-service/Infrastructure/Migrations/NotificationDbContextModelSnapshot.cs
Startup migration, seeding invocation and the skip guardmicroservices/src/notification-service/Program.cs
Default global template seeding and its idempotency checkmicroservices/src/notification-service/Seed/DefaultTemplateSeeder.cs
Seeding toggle and staleness windowmicroservices/src/notification-service/Application/NotificationOptions.cs

Runtime persistence behavior​

TopicSource file
Idempotency check, recipient upsert, message insert, attempt recording, audit writes, ledger write, save boundariesmicroservices/src/notification-service/Application/NotificationDispatcher.cs
Retry bounds applied during persisted delivery attemptsmicroservices/src/notification-service/Application/RetryPolicy.cs
Template resolution query and tenant-then-global fallbackmicroservices/src/notification-service/Application/TemplateEngine.cs
Preference query and in-memory exact-versus-wildcard resolutionmicroservices/src/notification-service/Application/PreferenceEvaluator.cs
Inbox, template, administration and statistics queries; tracking discipline; page-size clampingmicroservices/src/notification-service/Api/NotificationEndpoints.cs
Consumer acknowledgement behavior on persistence failuremicroservices/src/notification-service/Messaging/NotificationEventConsumer.cs

Legacy persistence​

TopicSource file
Legacy DbSets, notification query filters with super-admin bypass, length and index configurationData/AppDbContext.cs
Legacy notification entityModels/Notification.cs
Legacy user-notification entityModels/UserNotification.cs
Legacy template entityModels/NotificationTemplate.cs

Verification​

TopicSource file
Indirect persistence assertions through end-to-end API exercisemicroservices/scripts/smoke-notification.ps1

Classification​

Verified source map.

Requires confirmation​

None — every entry was confirmed to exist in the reviewed repository.

See Also​

Keywords​

  • Notification database
  • Source Map
  • Draft database documentation

Source References​

  • microservices/src/notification-service/Infrastructure/NotificationDbContext.cs
  • microservices/src/notification-service/Domain/NotificationEntities.cs
  • microservices/src/notification-service/Infrastructure/Migrations/20260705113059_InitialNotificationSchema.cs
  • microservices/src/notification-service/Infrastructure/Migrations/NotificationDbContextModelSnapshot.cs
  • microservices/src/notification-service/Infrastructure/Migrations/20260705113059_InitialNotificationSchema.Designer.cs
  • microservices/src/notification-service/Program.cs
  • microservices/src/notification-service/Seed/DefaultTemplateSeeder.cs
  • microservices/src/notification-service/Application/NotificationDispatcher.cs
  • microservices/src/notification-service/Api/NotificationEndpoints.cs
  • Data/AppDbContext.cs
  • microservices/scripts/smoke-notification.ps1

Revision Information​

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