## Companies

ID | Name
--- | ---
1 | TechCorp
2 | Financial Services Inc.
3 | HealthNet
4 | Software Solutions Ltd.
5 | Education Hub

## Locations

ID | LocationName
--- | ---
1 | New York
2 | Los Angeles
3 | Chicago
4 | Houston
5 | Phoenix

## Jobs

JobID | Title | Description | CompanyID
--- | --- | --- | ---
|  |  | (→ Companies.ID)
1 | Software Engineer | Design and develop software applications. | 1
2 | Data Analyst | Analyze data sets and provide insights. | 2
3 | Doctor | Diagnose and treat patients. | 3
4 | Nurse | Administer medical care to patients. | 4
5 | Teacher | Instruct students on various subjects. | 5

## Applicants

ApplicantID | FirstName | LastName | Email
--- | --- | --- | ---
1 | John | Doe | john.doe@example.com
2 | Jane | Smith | jane.smith@example.com
3 | Alice | Johnson | alice.johnson@example.com
4 | Michael | Williams | michael.williams@example.com
5 | David | Brown | david.brown@example.com

## Departments

DepartmentId | DepartmentName
--- | ---
1 | Engineering
2 | Analytics
3 | Medical
4 | Educational
5 | Administrative

## Roles

RoleId | RoleTitle | SupportRoles | Skills | MinExperience
--- | --- | --- | --- | ---
1 | Customer Service Representative | None | Proactivity | 1
2 | Customer Service Representative | None | Teamwork | 1
3 | Call Center Agent | None | Proactivity | 1
4 | Call Center Agent | None | Communication | 1

## Employees

EmployeeId | FirstName | LastName | DateOfBirth | DepartmentId
--- | --- | --- | --- | ---
|  |  |  | (→ Departments.DepartmentId)
1 | John | Doe | 1980-06-15 | 1
2 | Jane | Smith | 1990-07-20 | 2
3 | Alice | Johnson | 1985-08-25 | 3
4 | Michael | Williams | 1992-09-30 | 4
5 | David | Brown | 1988-10-15 | 5

## HiringManagers

ManagerId | FirstName | LastName | Email
--- | --- | --- | ---
1 | Samantha | Miller | samantha.miller@example.com
2 | Tom | Jackson | tom.jackson@example.com
3 | Linda | Green | linda.green@example.com
4 | Kevin | Black | kevin.black@example.com
5 | Laura | White | laura.white@example.com

## OpenPositions

PositionId | PositionTitle | SalaryRange | DepartmentId
--- | --- | --- | ---
|  |  | (→ Departments.DepartmentId)
1 | Managerial Position | $80k-$100k | 1
2 | Technical Lead | $90k-$110k | 2
3 | Head Nurse | $70k-$90k | 3
4 | Principal | $85k-$105k | 4
5 | Director of Education | $90k-$110k | 5

## ApplicationStatuses

AppStatusId | Status | ManagerId
--- | --- | ---
|  | (→ HiringManagers.ManagerId)
1 | Pending Review | 1
2 | Interview Scheduled | 2
3 | On Hold | 3
4 | Rejected | 4
5 | Offered | 5

## Applications

ApplicationId | AppStatusId | PositionId | ApplicantId
--- | --- | --- | ---
| (→ ApplicationStatuses.AppStatusId) | (→ OpenPositions.PositionId) | (→ Applicants.ApplicantId)
1 | 1 | 1 | 1
2 | 2 | 1 | 2
3 | 3 | 1 | 3
4 | 4 | 1 | 4
5 | 5 | 1 | 5