## Companies

id | name | location
--- | --- | ---
1 | TechCorp | New York
2 | SoftwareInc | San Francisco

## Departments

id | departmentName | companyId
--- | --- | ---
|  | (→ Companies.id)
1 | Engineering | 1
2 | Data Science | 1
3 | Marketing | 2

## Positions

id | positionName | departmentId
--- | --- | ---
|  | (→ Departments.id)
1 | Software Engineer | 1
2 | Data Scientist | 1
3 | Product Manager | 2

## JobPosts

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

## Applicants

id | firstName | lastName | emailAddress
--- | --- | --- | ---
1 | John | Doe | john.doe@example.com
2 | Jane | Smith | jane.smith@example.com

## ApplicationStatuses

id | status | applicantId | jobPostId
--- | --- | --- | ---
|  | (→ Applicants.id) | (→ JobPosts.id)
1 | Interview Scheduled | 1 | 1
2 | Rejected | 1 | 2

## ManagementRoles

id | role
--- | ---
1 | Project Manager
2 | Business Analyst

## ProjectDurations

id | duration
--- | ---
1 | 4 weeks
2 | 6 weeks

## JobsAndDurations

jobPostId | managementRoleId | projectDurationId
--- | --- | ---
(→ JobPosts.id) | (→ ManagementRoles.id) | (→ ProjectDurations.id)
1 | 1 | 1
1 | 1 | 2
2 | 2 | 1
2 | 2 | 2