| ID | Name |
|---|---|
| 1 | TechCorp |
| 2 | Financial Services Inc. |
| 3 | HealthNet |
| 4 | Software Solutions Ltd. |
| 5 | Education Hub |
| ID | LocationName |
|---|---|
| 1 | New York |
| 2 | Los Angeles |
| 3 | Chicago |
| 4 | Houston |
| 5 | Phoenix |
| 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 |
| ApplicantID | FirstName | LastName | |
|---|---|---|---|
| 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 |
| DepartmentId | DepartmentName |
|---|---|
| 1 | Engineering |
| 2 | Analytics |
| 3 | Medical |
| 4 | Educational |
| 5 | Administrative |
| 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 |
| 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 |
| ManagerId | FirstName | LastName | |
|---|---|---|---|
| 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 |
| 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 |
| AppStatusId | Status | ManagerId |
|---|---|---|
| (→ HiringManagers.ManagerId) | ||
| 1 | Pending Review | 1 |
| 2 | Interview Scheduled | 2 |
| 3 | On Hold | 3 |
| 4 | Rejected | 4 |
| 5 | Offered | 5 |
| 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 |