| id | name | location |
|---|---|---|
| 1 | TechCorp | New York |
| 2 | SoftwareInc | San Francisco |
| id | departmentName | companyId |
|---|---|---|
| (→ Companies.id) | ||
| 1 | Engineering | 1 |
| 2 | Data Science | 1 |
| 3 | Marketing | 2 |
| id | positionName | departmentId |
|---|---|---|
| (→ Departments.id) | ||
| 1 | Software Engineer | 1 |
| 2 | Data Scientist | 1 |
| 3 | Product Manager | 2 |
| id | title | description | positionId | salary |
|---|---|---|---|---|
| (→ Positions.id) | ||||
| 1 | Senior Software Engineer | Design and develop complex software systems. | 1 | 90000.0 |
| 2 | Mid-Level Data Scientist | Analyze large datasets to provide insights. | 2 | 80000.0 |
| 3 | Associate Product Manager | Manage product roadmap and features. | 3 | 70000.0 |
| id | firstName | lastName | emailAddress |
|---|---|---|---|
| 1 | John | Doe | john.doe@example.com |
| 2 | Jane | Smith | jane.smith@example.com |
| id | status | applicantId | jobPostId |
|---|---|---|---|
| (→ Applicants.id) | (→ JobPosts.id) | ||
| 1 | Interview Scheduled | 1 | 1 |
| 2 | Rejected | 1 | 2 |
| id | role |
|---|---|
| 1 | Project Manager |
| 2 | Business Analyst |
| id | duration |
|---|---|
| 1 | 4 weeks |
| 2 | 6 weeks |
| jobPostId | managementRoleId | projectDurationId |
|---|---|---|
| (→ JobPosts.id) | (→ ManagementRoles.id) | (→ ProjectDurations.id) |
| 1 | 1 | 1 |
| 1 | 1 | 2 |
| 2 | 2 | 1 |
| 2 | 2 | 2 |