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 |