| id | name |
|---|---|
| 1 | Expedia |
| 2 | Booking.com |
| 3 | Travelsupermarket.com |
| 4 | Thomson Holidays |
| 5 | Lastminute.com |
| id | job_type |
|---|---|
| 1 | Tour Guide |
| 2 | Travel Agent |
| 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 |
| id | first_name | last_name | phone_number | |
|---|---|---|---|---|
| 1 | John | Doe | john@example.com | +1234567890 |
| 2 | Jane | Smith | jane@example.com | +0987654321 |
| 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 |