## Companies

CompanyID | Name | Location
--- | --- | ---
1 | TechCorp | New York
2 | MedicalInnovations | San Francisco

## Departments

DepartmentID | Name | Description | CompanyID
--- | --- | --- | ---
|  |  | (→ Companies.CompanyID)
1 | Engineering | Developing new technologies. | 1
2 | Biotechnology | Researching genetic engineering. | 2

## Jobs

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

## Applicants

ApplicationID | FirstName | LastName | Email | 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