## Company

id | name
--- | ---
1 | TechCorp
2 | HealthPlus
3 | GreenTech
4 | SoftWare
5 | MedicalPioneers

## Department

id | companyId | departmentName
--- | --- | ---
| (→ Company.id) |
1 | 1 | Biotechnology
2 | 2 | Chemistry
3 | 3 | Physics
4 | 4 | Computer Science
5 | 5 | Mathematics

## PositionType

id | typeName
--- | ---
1 | Full Time
2 | Part Time
3 | Contractual
4 | Internship
5 | Volunteering

## LabPosition

id | positionTypeId | labPosition | gender | minimumEducation | experienceInYears | salaryRange
--- | --- | --- | --- | --- | --- | ---
| (→ PositionType.id) |  |  |  |  |
1 | 1 | Research Scientist | Female | PhD | 5 | 60k - 90k
2 | 1 | Research Scientist | Male | PhD | 7 | 80k - 110k
3 | 2 | Laboratory Technician | Female | BSc | 3 | 40k - 60k
4 | 2 | Laboratory Technician | Male | BSc | 4 | 50k - 70k
5 | 3 | Data Analyst | Non-binary | MS | 2 | 60k - 80k

## Employee

id | firstName | lastName | dateOfBirth | email | phoneNumber | hireDate | jobTitle | departmentId | gender
--- | --- | --- | --- | --- | --- | --- | --- | --- | ---
|  |  |  |  |  |  |  | (→ Department.id) |
1 | John | Smith | 1990-01-15 | johnsmith@email.com | +1 (234) 567-8910 | 2021-06-01 | Research Scientist | 1 | Male
2 | Jane | Doe | 1988-03-20 | janedoe@email.com | +1 (123) 456-7890 | 2021-07-01 | Laboratory Technician | 2 | Female
3 | Tom | Hanks | 1985-09-05 | thomhanks@email.com | +1 (345) 678-9012 | 2021-08-01 | Engineer | 3 | Male
4 | Alice | Williams | 1992-11-10 | alicewilliams@email.com | +1 (456) 789-0123 | 2021-09-01 | Analyst | 4 | Female
5 | Chris | Evans | 1989-06-25 | chrisevans@email.com | +1 (567) 890-1234 | 2021-10-01 | Manager | 5 | Male