| 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 |