## Employees

id | firstName | lastName | email | phoneNumber | hireDate
--- | --- | --- | --- | --- | ---
1 | John | Doe | john.doe@example.com | 123-456-7890 | 2021-01-01
2 | Jane | Smith | jane.smith@example.com | 098-765-4321 | 2021-02-01

## Departments

id | name | managerId
--- | --- | ---
|  | (→ Employees.id)
1 | Engineering | 1
2 | Human Resources | 2

## Salaries

employeeId | salary | effectiveDate
--- | --- | ---
(→ Employees.id) |  |
1 | 70000 | 2021-01-01
2 | 60000 | 2021-02-01

## Applications

applicationId | applicantId | jobId | resumePath | coverLetterPath | status
--- | --- | --- | --- | --- | ---
| (→ Employees.id) | (→ Positions.position) |  |  |
1 | 1 | 1 | /path/to/resume1.pdf | /path/to/coverletter1.docx | Pending
2 | 2 | 2 | /path/to/resume2.pdf | /path/to/coverletter2.docx | Reviewed

## Positions

Recruiter | position | description
--- | --- | ---
TechCorp | Software Engineer | None
HealthCo | Registered Nurse | None