Recruitment Offer Storage

Summary

Offer is an aggregate root with owned compensation and cascade-owned letter, revision, and approval records.

Audience

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

Overview

Offer has a primary key and three explicit indexes: unique compatibility identity, unique public token, and tenant/candidate lookup. Candidate and opening identifiers are logical references without EF foreign keys.

Compensation is an owned value stored with Offer. Letter, revision, and approval children each have an Offer foreign key with cascade delete. The snapshot adds a relationship-support index plus the configured tenant/offer composite for each child.

Document identifiers and storage metadata are references; content remains external. Compensation values and formulas 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.cs
• microservices/src/recruitment-service/Domain/Recruitment/Offer.cs
• microservices/src/recruitment-service/Infrastructure/Migrations/RecruitmentDbContextModelSnapshot.cs

Related Articles

• Recruitment database documentation
• Data integrity and transactions

See Also

• Recruitment technical documentation
• Recruitment API documentation

Keywords

• Recruitment database
• Offer Storage

Revision Information

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