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 |