Companies

IDName
1TechCorp
2Financial Services Inc.
3HealthNet
4Software Solutions Ltd.
5Education Hub

Locations

IDLocationName
1New York
2Los Angeles
3Chicago
4Houston
5Phoenix

Jobs

JobIDTitleDescriptionCompanyID
(→ Companies.ID)
1Software EngineerDesign and develop software applications.1
2Data AnalystAnalyze data sets and provide insights.2
3DoctorDiagnose and treat patients.3
4NurseAdminister medical care to patients.4
5TeacherInstruct students on various subjects.5

Applicants

ApplicantIDFirstNameLastNameEmail
1JohnDoejohn.doe@example.com
2JaneSmithjane.smith@example.com
3AliceJohnsonalice.johnson@example.com
4MichaelWilliamsmichael.williams@example.com
5DavidBrowndavid.brown@example.com

Departments

DepartmentIdDepartmentName
1Engineering
2Analytics
3Medical
4Educational
5Administrative

Roles

RoleIdRoleTitleSupportRolesSkillsMinExperience
1Customer Service RepresentativeNoneProactivity1
2Customer Service RepresentativeNoneTeamwork1
3Call Center AgentNoneProactivity1
4Call Center AgentNoneCommunication1

Employees

EmployeeIdFirstNameLastNameDateOfBirthDepartmentId
(→ Departments.DepartmentId)
1JohnDoe1980-06-151
2JaneSmith1990-07-202
3AliceJohnson1985-08-253
4MichaelWilliams1992-09-304
5DavidBrown1988-10-155

HiringManagers

ManagerIdFirstNameLastNameEmail
1SamanthaMillersamantha.miller@example.com
2TomJacksontom.jackson@example.com
3LindaGreenlinda.green@example.com
4KevinBlackkevin.black@example.com
5LauraWhitelaura.white@example.com

OpenPositions

PositionIdPositionTitleSalaryRangeDepartmentId
(→ Departments.DepartmentId)
1Managerial Position$80k-$100k1
2Technical Lead$90k-$110k2
3Head Nurse$70k-$90k3
4Principal$85k-$105k4
5Director of Education$90k-$110k5

ApplicationStatuses

AppStatusIdStatusManagerId
(→ HiringManagers.ManagerId)
1Pending Review1
2Interview Scheduled2
3On Hold3
4Rejected4
5Offered5

Applications

ApplicationIdAppStatusIdPositionIdApplicantId
(→ ApplicationStatuses.AppStatusId)(→ OpenPositions.PositionId)(→ Applicants.ApplicantId)
1111
2212
3313
4414
5515