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 |