| id | name | location |
|---|---|---|
| 1 | Tech Solutions | San Francisco |
| 2 | Software Inc. | New York |
| id | agencyName | contactEmail | contactPhone |
|---|---|---|---|
| 1 | Top Talent Agency | toptalent@example.com | +1-800-123-4567 |
| 2 | Job Connect | jobconnect@example.com | +1-900-987-6543 |
| id | title | description | salary | companyId | recruitmentAgencyId |
|---|---|---|---|---|---|
| (→ Company.id) | (→ Recruitment_Agency.id) | ||||
| 1 | Software Engineer | Develop and maintain software applications. | 90000 | 1 | 1 |
| 2 | Data Analyst | Analyze data to provide insights and recommendations. | 80000 | 1 | 2 |
| 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 |