## Recruiter

id | name | location
--- | --- | ---
1 | Tech Solutions | San Francisco
2 | Software Inc. | New York

## Applicant

id | firstName | lastName | email | phoneNumber | positionId
--- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Position.id)
1 | John | Smith | johnsmith@example.com | +1-123-456-7890 | 1
2 | Jane | Doe | janedoe@example.com | +1-987-654-3210 | 1

## Interview

id | date | time | applicantId | interviewerId | positionId | status
--- | --- | --- | --- | --- | --- | ---
|  |  | (→ Applicant.id) | (→ Employee.id) | (→ Position.id) |
1 | 2023-01-15 | 10:00 AM | 1 | 1 | 1 | Pending
2 | 2023-01-16 | 11:00 AM | 2 | 2 | 1 | Completed

## Employee

id | firstName | lastName | email | phoneNumber | role | hireDate
--- | --- | --- | --- | --- | --- | ---
1 | Alice | Wonderland | aliceland@example.com | +1-123-456-7890 | HR Manager | 2022-01-01
2 | Bob | Builder | bobbuilder@example.com | +1-987-654-3210 | Engineering Director | 2021-07-15

## Position

id | title | description | salary | companyId
--- | --- | --- | --- | ---
|  |  |  | (→ Recruiter.id)
1 | Software Engineer | Develop and maintain software applications. | 90000 | 1
2 | Data Analyst | Analyze data to provide insights and recommendations. | 80000 | 1