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 |