## Agency

id | name
--- | ---
1 | Expedia
2 | Booking.com
3 | Travelsupermarket.com
4 | Thomson Holidays
5 | Lastminute.com

## HospitalityJobType

id | job_type
--- | ---
1 | Tour Guide
2 | Travel Agent

## JobPosting

id | title | description | posted_date | agency_id | hospitality_job_type_id
--- | --- | --- | --- | --- | ---
|  |  |  | (→ Agency.id) | (→ HospitalityJobType.id)
1 | Seeking Tour Guides | We need experienced tour guides to join our team. | 2024-03-13 13:06:58 | 1 | 1
2 | Experienced Travel Agents Wanted | If you have experience in travel agency, apply now! | 2024-03-13 13:06:58 | 1 | 2
3 | Join Our Team of Tour Guides |  | 2024-03-13 13:06:58 | 2 | 1
4 | Travel Agents Needed |  | 2024-03-13 13:06:58 | 3 | 2
5 | Looking For Enthusiastic Tour Guides |  | 2024-03-13 13:06:58 | 4 | 1
6 | Senior Travel Agents Required |  | 2024-03-13 13:06:58 | 5 | 2

## Applicant

id | first_name | last_name | email | phone_number
--- | --- | --- | --- | ---
1 | John | Doe | john@example.com | +1234567890
2 | Jane | Smith | jane@example.com | +0987654321

## Application

application_id | job_posting_id | applicant_id | application_date | status
--- | --- | --- | --- | ---
| (→ JobPosting.id) | (→ Applicant.id) |  |
1 | 1 | 1 | 2024-03-13 13:06:58 | Applied
2 | 2 | 2 | 2024-03-13 13:06:58 | Rejected