Hospitality_Job_Postings

job_idjob_titleagencyexperience_levelrequired_skills
1Tour GuideExpediaEntry LevelCommunication Skills
2Tour GuideABC TravelMid LevelMultilingual
3Travel AgentExpediaExperiencedComputer Skills
4Travel AgentXYZ VacationsBeginnerCustomer Service

Agency_Information

agency_namelocationnumber_of_employeesreputation_score
ExpediaNew York10008.7
ABC TravelLos Angeles5007.6
XYZ VacationsChicago8009.1

Applicant_Info

applicant_idfirst_namelast_nameemailphone_numberresume_path
1JohnDoejohndoe@email.com+123456789/resumes/john_doe.pdf
2JaneSmithjanesmith@email.com+987654321/resumes/jane_smith.pdf

Applied_Jobs

applied_job_idapplicant_idjob_idapplication_date
(→ Applicant_Info.applicant_id)(→ Hospitality_Job_Postings.job_id)
1112022-01-01 10:00:00
2232022-01-02 10:00:00

Interview_Schedule

interview_schedule_idapplied_job_idinterviewee_nameinterviewer_namedate_timeduration
(→ Applied_Jobs.applied_job_id)
11John DoeAlice Johnson2022-01-05 10:00:0060.0
22Jane SmithBob Brown2022-01-06 10:00:0045.0

Feedback

feedback_idinterview_schedule_idratingcomments
(→ Interview_Schedule.interview_schedule_id)
118.5Good communication skills.
229.0Very professional and friendly.