# Candidate Entities {#candidate-entities}


Entities for applicant tracking: candidates, interviews, feedback, skills, education, and experience.


## Candidate {#candidate}


| Column             | Type    | Description                    |
| ------------------ | ------- | ------------------------------ |
| `rating`           | number? | Overall candidate rating       |
| `payPeriod`        | enum?   | Expected pay period            |
| `billRateValue`    | number? | Expected billing rate          |
| `billRateCurrency` | string? | Billing currency               |
| `minimumBudget`    | number? | Minimum budget                 |
| `rejectDate`       | Date?   | Rejection date                 |
| `hiredDate`        | Date?   | Hire date                      |
| `status`           | enum?   | `APPLIED`, `REJECTED`, `HIRED` |
| `userId`           | UUID    | FK to user (1:1)               |
| `sourceId`         | UUID?   | FK to candidate source         |

**Relations:** `user` (OneToOne), `interview` (OneToMany), `feedbacks` (OneToMany), `skills` (OneToMany), `educations` (OneToMany), `experience` (OneToMany), `documents` (OneToMany), `tags` (ManyToMany)


## CandidateInterview {#candidateinterview}


| Column        | Type    | Description     |
| ------------- | ------- | --------------- |
| `title`       | string  | Interview title |
| `startTime`   | Date?   | Start time      |
| `endTime`     | Date?   | End time        |
| `location`    | string? | Location        |
| `note`        | string? | Notes           |
| `rating`      | number? | Average rating  |
| `candidateId` | UUID    | FK to candidate |

**Relations:** `interviewers` (OneToMany CandidateInterviewers), `feedbacks` (OneToMany CandidateFeedback), `technologies` (OneToMany)


## CandidateFeedback {#candidatefeedback}


| Column          | Type    | Description       |
| --------------- | ------- | ----------------- |
| `description`   | string? | Feedback text     |
| `rating`        | number  | Rating (1-5)      |
| `status`        | enum?   | Feedback status   |
| `candidateId`   | UUID    | FK to candidate   |
| `interviewId`   | UUID?   | FK to interview   |
| `interviewerId` | UUID?   | FK to interviewer |


## CandidateSkill / CandidateEducation / CandidateExperience {#candidateskill--candidateeducation--candidateexperience}


Each captures different profile sections with fields like `name`, `description`, `institution`, `degree`, `startDate`, `endDate`.


## CandidateSource {#candidatesource}


| Column | Type   | Description                            |
| ------ | ------ | -------------------------------------- |
| `name` | string | Source name (e.g., LinkedIn, Referral) |


## Related Pages {#related-pages}


- [Candidate Endpoints](https://sourcey-gauzy.pages.dev/api/candidate-endpoints/index.md) — API reference
- [ATS / Candidates](https://sourcey-gauzy.pages.dev/features/ats-candidates/index.md) — feature guide
- [Recruitment](https://sourcey-gauzy.pages.dev/features/recruitment/index.md) — recruitment overview