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 |