Recruitment Interview Feedback Storage

Summary

Interview feedback is an interview-owned child with a cascade foreign key and interview lookup index.

Audience

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

Overview

InterviewFeedback has a primary key, TenantId, InterviewId, submitter evidence, rating, recommendation, optional feedback, and submission time. InterviewId is a configured foreign key to Interview with cascade delete and a supporting index.

The model does not configure a uniqueness constraint limiting an interview to one feedback record. Command behavior, rather than the database, handles retry/idempotency expectations. Notes, identities, and example values 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/Interview.cs

Related Articles

• Recruitment database documentation
• Data integrity and transactions

See Also

• Recruitment technical documentation
• Recruitment API documentation

Keywords

• Recruitment database
• Interview Feedback Storage

Revision Information

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