Recruitment Interview Storage

Summary

Interview is an aggregate root with a cascade-owned feedback collection and public-token lookup.

Audience

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

Overview

Interview has a primary key and three secondary indexes: unique compatibility identity, unique feedback token, and tenant/candidate lookup. CandidateId and JobOpeningId are logical references without configured foreign keys.

The feedback token is globally unique in the model. Public lookup deliberately bypasses tenant filters and uses the token. Token lifecycle and retention require confirmation.

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

Related Articles

• Recruitment database documentation
• Data integrity and transactions

See Also

• Recruitment technical documentation
• Recruitment API documentation

Keywords

• Recruitment database
• Interview Storage

Revision Information

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