## Agency

id | name
--- | ---
1 | Expedia
2 | Booking.com

## Tour_Guide

id | guideName | agencyId
--- | --- | ---
|  | (→ Agency.id)
1 | John Doe | 1
2 | Jane Smith | 2
3 | Michael Johnson | 1
4 | Emily Davis | 2
5 | David Brown | 1

## Travel_Agent

id | agentName | agencyId
--- | --- | ---
|  | (→ Agency.id)
1 | Alice Lee | 1
2 | Bob White | 2
3 | Carol Black | 1
4 | Daniel Green | 2
5 | Eva Blue | 1

## Jobs

id | title | description
--- | --- | ---
1 | Software Engineer | Developing web applications.
2 | Data Analyst | Analyzing customer behavior.
3 | Graphic Designer | Creating visuals for marketing materials.
4 | Marketing Specialist | Promoting products and services.
5 | HR Manager | Managing employees and recruitment.

## Applications

tourGuideId | travelAgentId | jobId | applicationDate
--- | --- | --- | ---
(→ Tour_Guide.id) | (→ Travel_Agent.id) | (→ Jobs.id) |
1 | 3 | 1 | 2024-03-13 17:41:57
2 | 4 | 2 | 2024-03-13 17:41:57
3 | 1 | 3 | 2024-03-13 17:41:57
4 | 2 | 4 | 2024-03-13 17:41:57
5 | 1 | 5 | 2024-03-13 17:41:57

## Skills

skillId | skillName
--- | ---
1 | Python Programming
2 | SQL Database Management
3 | JavaScript Development
4 | SEO Optimization
5 | Customer Relationship Management