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 |