| id | firstName | lastName | 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 |
| id | name | managerId |
|---|---|---|
| (→ Employees.id) | ||
| 1 | Engineering | 1 |
| 2 | Human Resources | 2 |
| employeeId | salary | effectiveDate |
|---|---|---|
| (→ Employees.id) | ||
| 1 | 70000 | 2021-01-01 |
| 2 | 60000 | 2021-02-01 |
| company | recruitment_agency | position | description |
|---|---|---|---|
| TechCorp | Acme Recruiters | Software Engineer | None |
| HealthCo | Medical Staffing Solutions | Registered Nurse | None |
| 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 |