Companies

CompanyIDNameLocation
1TechCorpNew York
2MedicalInnovationsSan Francisco

Departments

DepartmentIDNameDescriptionCompanyID
(→ Companies.CompanyID)
1EngineeringDeveloping new technologies.1
2BiotechnologyResearching genetic engineering.2

Jobs

JobIDTitleSalaryStartDateEndDateDepartmentID
(→ Departments.DepartmentID)
1Software Engineer750002023-01-01None1
2Molecular Biologist650002023-01-01None2
3Research Scientist800002023-01-01None1
4Research Scientist800002023-01-01None2
5Laboratory Technician600002023-01-01None2

Applicants

ApplicationIDFirstNameLastNameEmailPhoneNumberGenderJobID
(→ Jobs.JobID)
1JohnDoejohn.doe@example.com+1234567890male1
2JaneSmithjane.smith@example.com+1234567890female1
3AliceBrownalice.brown@example.com+1234567890female2
4RobertGreenrobert.green@example.com+1234567890male3
5CharlotteWhitecharlotte.white@example.com+1234567890female4
6WilliamBlackwilliam.black@example.com+1234567890male5