InterviewSchedule
The InterviewSchedule entity, mapped to the interview_schedule table.
| Table | interview_schedule |
| Tenant-scoped | Yes — extends TenantOwned |
| Columns | 6 |
| Relationships | 2 |
| Source | backend/src/main/java/com/motorph/payroll/model/InterviewSchedule.java |
Columns
| Field | Type | Column | Null | Notes |
|---|---|---|---|---|
interviewId | Integer | interview_id | — | primary key, generated |
interviewRound | String | interview_round | Yes | — |
scheduledAt | LocalDateTime | scheduled_at | — | — |
location | String | location | Yes | — |
status | String | status | — | — |
notes | String | notes | Yes | — |
Plus tenant_id, inherited from TenantOwned. Hibernate stamps it on insert and adds where tenant_id = ? to every query, so it is never written or read by application code.
Relationships
| Field | Kind | Target | Join column | Required |
|---|---|---|---|---|
applicant | @ManyToOne | JobApplicant | applicant_id | Yes |
interviewer | @ManyToOne | Employee | interviewer_id | Yes |
Referenced by
| Entity | Field | Kind |
|---|---|---|
| InterviewFeedback | interview | @ManyToOne |
Neighbourhood
Repository
InterviewScheduleRepository
Declared over InterviewSchedule with id type Integer, with JpaSpecificationExecutor for dynamic filtering. Source: backend/src/main/java/com/motorph/payroll/repository/InterviewScheduleRepository.java
| Method | Returns | Notes |
|---|---|---|
findWithDetailsByInterviewId(Integer interviewId) | Optional<InterviewSchedule> | derived |
countByScheduledAtBetweenAndStatus(LocalDateTime from, LocalDateTime to, String status) | long | derived |
findAllByScheduledAtBetween(LocalDateTime from, LocalDateTime to) | List<InterviewSchedule> | derived |
Reached by
These controllers hold — directly or through a service they depend on — a repository over InterviewSchedule.
| Controller | Base path | Endpoints | Module |
|---|---|---|---|
| InterviewFeedbackController | /api/interview-feedback | 2 | Recruitment |
| InterviewScheduleController | /api/interview-schedules | 8 | Recruitment |
| ReportingController | /api/reports | 16 | Platform Misc |
Generated page
This page is rebuilt from the source on every docs build by docs-site/scripts/gen-code-wiki.mjs. Editing it has no effect — change the code, or, if what you want to say is prose, write it in docs/.