id | name | |
---|---|---|
1 | John Doe | john@example.com |
2 | Jane Smith | jane@example.com |
3 | Mike Johnson | mike@example.com |
4 | Emily Davis | emily@example.com |
5 | David Brown | david@example.com |
functionId | description |
---|---|
1 | Recruitment |
2 | Training |
3 | Onboarding |
4 | Offboarding |
5 | Compliance |
hrProfessionalId | functionId |
---|---|
(→ Hr_Professionals.id) | (→ Functions.functionId) |
1 | 1 |
2 | 1 |
3 | 1 |
4 | 1 |
5 | 1 |
5 | 2 |
jobId | title | description |
---|---|---|
1 | Software Engineer | We are looking for a skilled Software Engineer... |
2 | Data Analyst | We need an experienced Data Analyst to join our team... |
3 | Project Manager | A Project Manager is needed to lead our projects... |
4 | HR Specialist | An HR Specialist will support our growing company... |
5 | UX Designer | We are seeking a UX Designer to create user-friendly interfaces... |
applicantId | firstName | lastName | |
---|---|---|---|
1 | Alice | Smith | alice@example.com |
2 | Bob | Doe | bob@example.com |
3 | Charlie | Johnson | charlie@example.com |
4 | Diana | Williams | diana@example.com |
5 | Ethan | Martin | ethan@example.com |
applicationId | applicantId | jobId | dateApplied | status |
---|---|---|---|---|
(→ Applicants.applicantId) | (→ Jobs.jobId) | |||
1 | 1 | 1 | 2024-01-30 19:36:07 | Pending |
2 | 2 | 2 | 2024-01-30 19:36:07 | In Progress |
3 | 3 | 3 | 2024-01-30 19:36:07 | Rejected |
4 | 4 | 4 | 2024-01-30 19:36:07 | Accepted |
5 | 5 | 5 | 2024-01-30 19:36:07 | Interview Scheduled |