## Hospitality_Job_Postings

job_id | job_title | agency | experience_level | required_skills
--- | --- | --- | --- | ---
1 | Tour Guide | Expedia | Entry Level | Communication Skills
2 | Tour Guide | ABC Travel | Mid Level | Multilingual
3 | Travel Agent | Expedia | Experienced | Computer Skills
4 | Travel Agent | XYZ Vacations | Beginner | Customer Service

## Agency_Information

agency_name | location | number_of_employees | reputation_score
--- | --- | --- | ---
Expedia | New York | 1000 | 8.7
ABC Travel | Los Angeles | 500 | 7.6
XYZ Vacations | Chicago | 800 | 9.1

## Applicant_Info

applicant_id | first_name | last_name | email | phone_number | resume_path
--- | --- | --- | --- | --- | ---
1 | John | Doe | johndoe@email.com | +123456789 | /resumes/john_doe.pdf
2 | Jane | Smith | janesmith@email.com | +987654321 | /resumes/jane_smith.pdf

## Applied_Jobs

applied_job_id | applicant_id | job_id | application_date
--- | --- | --- | ---
| (→ Applicant_Info.applicant_id) | (→ Hospitality_Job_Postings.job_id) |
1 | 1 | 1 | 2022-01-01 10:00:00
2 | 2 | 3 | 2022-01-02 10:00:00

## Interview_Schedule

interview_schedule_id | applied_job_id | interviewee_name | interviewer_name | date_time | duration
--- | --- | --- | --- | --- | ---
| (→ Applied_Jobs.applied_job_id) |  |  |  |
1 | 1 | John Doe | Alice Johnson | 2022-01-05 10:00:00 | 60.0
2 | 2 | Jane Smith | Bob Brown | 2022-01-06 10:00:00 | 45.0

## Feedback

feedback_id | interview_schedule_id | rating | comments
--- | --- | --- | ---
| (→ Interview_Schedule.interview_schedule_id) |  |
1 | 1 | 8.5 | Good communication skills.
2 | 2 | 9.0 | Very professional and friendly.