Recruitment Persistence Object Reference

Summary

The current model snapshot confirms 18 persisted object types.

Audience

Developers, QA and support engineers, data reviewers, implementation partners, solution architects, and security reviewers.

Overview

Reference Content

Persisted object	Role	Tenant filter	Relationship role
JobRequisition	Aggregate root	Yes	Logical opening/workflow references
JobOpening	Aggregate root	Yes	Logical requisition reference
Candidate	Aggregate root	Yes	Principal for four child collections
CandidateApplication	Candidate child	Yes	Candidate foreign key
CandidateStageHistory	Candidate child	Yes	Candidate foreign key
CandidateNote	Candidate child	Yes	Candidate foreign key
CandidateDocumentReference	Candidate child	Yes	Candidate foreign key
Interview	Aggregate root	Yes	Principal for feedback
InterviewFeedback	Interview child	Yes	Interview foreign key
Offer	Aggregate root	Yes	Principal for three child collections
OfferLetter	Offer child	Yes	Offer foreign key
OfferRevision	Offer child	Yes	Offer foreign key
OfferApproval	Offer child	Yes	Offer foreign key
Onboarding	Aggregate root	Yes	Logical candidate/offer/employee references
RecruitmentAuditLog	Operational evidence	Yes	Logical entity identifier
RecruitmentTimeline	Operational evidence	Yes	Logical entity identifier
ProcessedIntegrationEvent	Idempotency ledger	No global filter	No EF relationship
OutboxMessage	Publication intent	No global filter	No EF relationship

Every object has a configured primary key. Physical schema/table identifiers, column listings, SQL types, and sensitive data fields are intentionally omitted.

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.cs
• microservices/src/recruitment-service/Infrastructure/Migrations/RecruitmentDbContextModelSnapshot.cs

Related Articles

• Recruitment database documentation
• Recruitment technical documentation

See Also

• Recruitment API documentation
• Recruitment module

Keywords

• Recruitment database
• Schema Reference

Revision Information

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