Company

idname
1TechCorp
2HealthPlus
3GreenTech
4SoftWare
5MedicalPioneers

Department

idcompanyIddepartmentName
(→ Company.id)
11Biotechnology
22Chemistry
33Physics
44Computer Science
55Mathematics

PositionType

idtypeName
1Full Time
2Part Time
3Contractual
4Internship
5Volunteering

LabPosition

idpositionTypeIdlabPositiongenderminimumEducationexperienceInYearssalaryRange
(→ PositionType.id)
11Research ScientistFemalePhD560k - 90k
21Research ScientistMalePhD780k - 110k
32Laboratory TechnicianFemaleBSc340k - 60k
42Laboratory TechnicianMaleBSc450k - 70k
53Data AnalystNon-binaryMS260k - 80k

Employee

idfirstNamelastNamedateOfBirthemailphoneNumberhireDatejobTitledepartmentIdgender
(→ Department.id)
1JohnSmith1990-01-15johnsmith@email.com+1 (234) 567-89102021-06-01Research Scientist1Male
2JaneDoe1988-03-20janedoe@email.com+1 (123) 456-78902021-07-01Laboratory Technician2Female
3TomHanks1985-09-05thomhanks@email.com+1 (345) 678-90122021-08-01Engineer3Male
4AliceWilliams1992-11-10alicewilliams@email.com+1 (456) 789-01232021-09-01Analyst4Female
5ChrisEvans1989-06-25chrisevans@email.com+1 (567) 890-12342021-10-01Manager5Male