| 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 |
| 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 |
| id | career |
|---|---|
| 1 | Marine Biologist |
| 2 | Zoologist |
| 3 | Veterinarian |
| 4 | Wildlife Rehabilitator |
| 5 | Ecologist |
| id | level |
|---|---|
| 1 | 5 years |
| 2 | 7 years |
| 3 | 3 years |
| 4 | 10 years |
| 5 | 8 years |
| 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 |
| id | name | 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 |
| 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 |