CompanyID | Name | Location |
---|---|---|
1 | TechCorp | New York |
2 | MedicalInnovations | San Francisco |
DepartmentID | Name | Description | CompanyID |
---|---|---|---|
(→ Companies.CompanyID) | |||
1 | Engineering | Developing new technologies. | 1 |
2 | Biotechnology | Researching genetic engineering. | 2 |
JobID | Title | Salary | StartDate | EndDate | DepartmentID |
---|---|---|---|---|---|
(→ Departments.DepartmentID) | |||||
1 | Software Engineer | 75000 | 2023-01-01 | None | 1 |
2 | Molecular Biologist | 65000 | 2023-01-01 | None | 2 |
3 | Research Scientist | 80000 | 2023-01-01 | None | 1 |
4 | Research Scientist | 80000 | 2023-01-01 | None | 2 |
5 | Laboratory Technician | 60000 | 2023-01-01 | None | 2 |
ApplicationID | FirstName | LastName | PhoneNumber | Gender | JobID | |
---|---|---|---|---|---|---|
(→ Jobs.JobID) | ||||||
1 | John | Doe | john.doe@example.com | +1234567890 | male | 1 |
2 | Jane | Smith | jane.smith@example.com | +1234567890 | female | 1 |
3 | Alice | Brown | alice.brown@example.com | +1234567890 | female | 2 |
4 | Robert | Green | robert.green@example.com | +1234567890 | male | 3 |
5 | Charlotte | White | charlotte.white@example.com | +1234567890 | female | 4 |
6 | William | Black | william.black@example.com | +1234567890 | male | 5 |