Recruitment Database Documentation
Summary
Recruitment uses one EF Core persistence model with 18 persisted object sets, 18 primary keys, 35 snapshot indexes, 8 cascade relationships, and 5 migrations.
Audience
Developers, QA and support engineers, data reviewers, implementation partners, solution architects, and security reviewers.
Overview
Confirmed inventory
- Runtime DbContext: one.
- Design-time factory: one factory for the same runtime model.
- Derived compatibility or backfill DbContexts: Not implemented.
- Persisted object sets: 18.
- Primary keys: 18.
- Snapshot secondary indexes: 35 total; 10 unique and 25 non-unique.
- Explicit model indexes: 31; four additional relationship-support indexes appear in the snapshot.
- Configured relationships: 8, all cascade delete.
- Owned value objects: 2.
- Global-filtered object types: 16 of 18.
- Migrations: 5, plus the current snapshot.
Documentation map
- Database overview
- Ownership and boundaries
- Requisition storage
- Job-opening storage
- Candidate storage
- Application storage
- Interview storage
- Interview-feedback storage
- Offer storage
- Onboarding storage
- Document-reference storage
- Audit and timeline storage
- Outbox storage
- Processed-event storage
- Tenant isolation
- Migrations and seeding
- Indexing and query patterns
- Compatibility and transition
- Data integrity and transactions
- Schema reference
- Database testing guide
All documentation remains Draft. Physical database names, connection information, SQL, seed values, and sensitive Recruitment data are intentionally excluded.
Requires confirmation
Production migration governance, rollback ownership, reconciliation, retention, privacy, performance, query optimization, concurrency, and operational ownership require confirmation.
Source References
microservices/src/recruitment-service/Infrastructure/RecruitmentDbContext.csmicroservices/src/recruitment-service/Infrastructure/Persistence.csmicroservices/src/recruitment-service/Infrastructure/Migrations/RecruitmentDbContextModelSnapshot.csmicroservices/src/recruitment-service/Program.cs
Related Articles
See Also
Keywords
- Recruitment database
- Database Overview
Revision Information
- Status: Draft
- Last reviewed: 2026-07-16
- Review cycle: Quarterly