| id | name | location |
|---|---|---|
| 1 | Tech Solutions | San Francisco |
| 2 | Software Inc. | New York |
| id | firstName | lastName | phoneNumber | positionId | |
|---|---|---|---|---|---|
| (→ Position.id) | |||||
| 1 | John | Smith | johnsmith@example.com | +1-123-456-7890 | 1 |
| 2 | Jane | Doe | janedoe@example.com | +1-987-654-3210 | 1 |
| id | date | time | applicantId | interviewerId | positionId | status |
|---|---|---|---|---|---|---|
| (→ Applicant.id) | (→ Employee.id) | (→ Position.id) | ||||
| 1 | 2023-01-15 | 10:00 AM | 1 | 1 | 1 | Pending |
| 2 | 2023-01-16 | 11:00 AM | 2 | 2 | 1 | Completed |
| id | firstName | lastName | phoneNumber | role | hireDate | |
|---|---|---|---|---|---|---|
| 1 | Alice | Wonderland | aliceland@example.com | +1-123-456-7890 | HR Manager | 2022-01-01 |
| 2 | Bob | Builder | bobbuilder@example.com | +1-987-654-3210 | Engineering Director | 2021-07-15 |
| id | title | description | salary | companyId |
|---|---|---|---|---|
| (→ Recruiter.id) | ||||
| 1 | Software Engineer | Develop and maintain software applications. | 90000 | 1 |
| 2 | Data Analyst | Analyze data to provide insights and recommendations. | 80000 | 1 |