id | experience |
---|---|
1 | 5 years |
2 | 10 years |
3 | 3 years |
4 | 6 months |
5 | 2 years |
id | name | age | salary |
---|---|---|---|
(→ Experience.id) | |||
1 | John Doe | 30 | 70000.0 |
2 | Jane Smith | 35 | 80000.0 |
3 | Michael Johnson | 29 | 65000.0 |
4 | Emily Brown | 32 | 75000.0 |
5 | David Wilson | 28 | 60000.0 |
id | name | age | salary |
---|---|---|---|
(→ Experience.id) | |||
1 | Lisa Thompson | 27 | 68000.0 |
2 | Robert Martin | 31 | 72000.0 |
3 | William Taylor | 26 | 62000.0 |
4 | Amy Clark | 29 | 69000.0 |
5 | Steven Davis | 25 | 58000.0 |
id | companyName | location |
---|---|---|
1 | Ocean Life Inc. | Los Angeles |
2 | Wildlife Exploration LLC | New York |
3 | Animal Research Corporation | Chicago |
4 | Eco Discovery Group | Houston |
5 | Nature Conservation Association | Philadelphia |
jobId | jobTitle | description | postedDate | marineBiologist | zoologist | foreignKeyID |
---|---|---|---|---|---|---|
(→ MarineBiologists.id) | (→ Companies.id) | |||||
1 | Marine Biologist Position | Study and protect marine life. | 2021-01-01 | 1 | 0 | 1 |
2 | Zoologist Position | Study and conserve various species of animals. | 2021-01-02 | 0 | 1 | 2 |
3 | Research Scientist | Conduct research on animal behavior. | 2021-01-03 | 1 | 1 | 3 |
4 | Curator | Manage a collection of live animals and plants. | 2021-01-04 | 1 | 1 | 4 |
5 | Field Technician | Assist researchers in field studies. | 2021-01-05 | 0 | 0 | 5 |
applicationId | applicantName | appliedJobId | appliedCompanyId | applyDate |
---|---|---|---|---|
(→ Jobs.jobId) | (→ Companies.id) | |||
1 | John Smith | 1 | 1 | 2021-01-06 |
2 | Alice Jones | 2 | 2 | 2021-01-07 |
3 | Bob Williams | 3 | 3 | 2021-01-08 |
4 | Carol Brown | 4 | 4 | 2021-01-09 |
5 | Daniel Davis | 5 | 5 | 2021-01-10 |