id | name | address |
---|---|---|
1 | Company A | 123 Main St |
2 | Company B | 456 Elm St |
3 | Company C | 789 Oak St |
4 | Company D | 098 Maple Ave |
5 | Company E | 543 Pine St |
id | name |
---|---|
1 | Department of Geosciences |
2 | Department of Chemistry |
3 | Department of Biology |
4 | Department of Physics |
5 | Department of Mathematics |
id | jobTitle | departmentId | companyId |
---|---|---|---|
(→ Departments.id) | (→ Companies.id) | ||
1 | Research Scientist | 1 | 1 |
2 | Laboratory Technician | 1 | 2 |
3 | Field Geologist | 2 | 3 |
4 | Teaching Assistant | 3 | 4 |
5 | Data Analyst | 4 | 5 |
id | firstName | lastName | title | startDate | endDate | earthScienceCareer | university |
---|---|---|---|---|---|---|---|
1 | John | Doe | Chemist | 2010-01-01 | None | Chemist | MIT |
2 | Jane | Smith | Chemist | 2015-01-01 | None | Chemist | UCLA |
3 | Michael | Brown | Geoscientist | 2010-01-01 | None | Geoscientist | MIT |
4 | Emily | White | Geoscientist | 2015-01-01 | None | Geoscientist | Stanford |
5 | David | Black | Engineer | 2010-01-01 | None | Engineer | Caltech |
employeeId | degree | major | institution | yearGraduated |
---|---|---|---|---|
(→ Employees.id) | ||||
None | PhD | Chemistry | Harvard | 2008 |
None | MS | Physics | Yale | 2010 |
None | BS | Biology | Princeton | 2012 |
None | BA | Mathematics | Columbia | 2014 |
None | MA | Computational Science | Berkeley | 2016 |