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_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_id | first_name | last_name | 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_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_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_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. |