## Companies

id | name | location
--- | --- | ---
1 | Ocean Life | San Francisco
2 | Wild World | New York
3 | Nature Explorers | Los Angeles
4 | Sea Discoveries | Miami
5 | Earth Guardians | Chicago

## Jobs

id | title | description | postedDate | companyId
--- | --- | --- | --- | ---
|  |  |  | (→ Companies.id)
1 | Marine Biologist | Conduct research on marine life. | 2024-03-13 12:20:04 | 1
2 | Zoologist | Study animals and their habitats. | 2024-03-13 12:20:04 | 2
3 | Conservation Officer | Protect endangered species. | 2024-03-13 12:20:04 | 3
4 | Aquarist | Maintain aquatic exhibits. | 2024-03-13 12:20:04 | 4
5 | Environmental Educator | Teach about environmental issues. | 2024-03-13 12:20:04 | 5

## AnimalStudies

id | career
--- | ---
1 | Marine Biologist
2 | Zoologist
3 | Veterinarian
4 | Wildlife Rehabilitator
5 | Ecologist

## ExperienceLevels

id | level
--- | ---
1 | 5 years
2 | 7 years
3 | 3 years
4 | 10 years
5 | 8 years

## JobRequirements

id | jobId | animalCareerId | experienceLevelId
--- | --- | --- | ---
| (→ Jobs.id) | (→ AnimalStudies.id) | (→ ExperienceLevels.id)
1 | 1 | 1 | 1
2 | 1 | 1 | 2
3 | 2 | 2 | 1
4 | 2 | 3 | 3
5 | 3 | 4 | 4

## Applicants

id | name | email | phoneNumber | applicationDate
--- | --- | --- | --- | ---
1 | John Doe | john@example.com | 555-123-4567 | 2024-03-13 12:20:04
2 | Jane Smith | jane@example.com | 555-987-6543 | 2024-03-13 12:20:04
3 | Alice Johnson | alice@example.com | 555-321-9876 | 2024-03-13 12:20:04
4 | Bob Brown | bob@example.com | 555-555-5555 | 2024-03-13 12:20:04
5 | Carol White | carol@example.com | 555-111-2222 | 2024-03-13 12:20:04

## ApplicationJobs

applicantId | jobId | dateApplied
--- | --- | ---
(→ Applicants.id) | (→ Jobs.id) |
1 | 1 | 2022-01-01
1 | 2 | 2022-01-15
2 | 1 | 2022-02-01
2 | 2 | 2022-02-15
3 | 1 | 2022-03-01