Agency

idname
1Expedia
2Booking.com
3Travelsupermarket.com
4Thomson Holidays
5Lastminute.com

HospitalityJobType

idjob_type
1Tour Guide
2Travel Agent

JobPosting

idtitledescriptionposted_dateagency_idhospitality_job_type_id
(→ Agency.id)(→ HospitalityJobType.id)
1Seeking Tour GuidesWe need experienced tour guides to join our team.2024-03-13 13:06:5811
2Experienced Travel Agents WantedIf you have experience in travel agency, apply now!2024-03-13 13:06:5812
3Join Our Team of Tour Guides2024-03-13 13:06:5821
4Travel Agents Needed2024-03-13 13:06:5832
5Looking For Enthusiastic Tour Guides2024-03-13 13:06:5841
6Senior Travel Agents Required2024-03-13 13:06:5852

Applicant

idfirst_namelast_nameemailphone_number
1JohnDoejohn@example.com+1234567890
2JaneSmithjane@example.com+0987654321

Application

application_idjob_posting_idapplicant_idapplication_datestatus
(→ JobPosting.id)(→ Applicant.id)
1112024-03-13 13:06:58Applied
2222024-03-13 13:06:58Rejected