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 |