## Customer_Service_Advisors

advisorID | name | phoneNumber | emailAddress | languageProficiency
--- | --- | --- | --- | ---
1 | John Doe | +1234567890 | john@example.com | Bilingual
2 | Jane Smith | +0987654321 | jane@example.com | Multilingual
3 | Alice Johnson | +7654321987 | alice@example.com | English only
4 | Michael Brown | +1357924680 | michael@example.com | Bilingual
5 | Emma Wilson | +0246813579 | emma@example.com | Trilingual

## IT_Support_Technicians

technicianID | name | phoneNumber | emailAddress | languageProficiency
--- | --- | --- | --- | ---
1 | David Lee | +1987654320 | david@example.com | Bilingual
2 | James White | +0765432198 | james@example.com | Multilingual
3 | Chris Green | +7543219876 | chris@example.com | English only
4 | Steven Black | +1324681357 | steven@example.com | Bilingual
5 | Robert Blue | +0254321986 | robert@example.com | Trilingual

## Companies

companyID | companyName | address | phoneNumber | emailAddress
--- | --- | --- | --- | ---
1 | Example Inc. | 123 Main St., New York, NY | +1123456789 | info@exampleinc.com
2 | Tech Solutions LLC | 456 Elm St., San Francisco, CA | +1234567809 | contact@techsolutionsllc.com
3 | IT Support Services AG | 789 Oak St., Berlin, Germany | +49301234567 | support@itss.de
4 | Global Enterprises Ltd. | 135 Pine St., London, UK | +442012345678 | enquiries@globalenterprises.co.uk
5 | Software Developers Co. | 246 Maple St., Toronto, Canada | +16471234567 | inquiry@softdevco.ca

## Jobs

jobID | title | description | location | salary
--- | --- | --- | --- | ---
1 | Customer Service Advisor | Assist customers with their queries and concerns. | New York, NY | 50000.0
2 | IT Support Technician | Provide technical support to clients via phone and email. | San Francisco, CA | 60000.0
3 | Web Developer | Design and develop web applications using HTML, CSS, JavaScript, and other technologies. | Berlin, Germany | 70000.0
4 | Data Analyst | Analyze data sets and provide insights to improve business performance. | London, UK | 65000.0
5 | Network Engineer | Design, implement, and maintain computer networks for businesses. | Toronto, Canada | 75000.0

## Applications

applicationID | applicantID | jobID | resumePath | coverLetterPath
--- | --- | --- | --- | ---
| (→ Customer_Service_Advisors.advisorID) | (→ Jobs.jobID) |  |
1 | 1 | 1 | /path/to/resume1.pdf | /path/to/coverletter1.docx
2 | 2 | 2 | /path/to/resume2.pdf | /path/to/coverletter2.docx
3 | 3 | 3 | /path/to/resume3.pdf | /path/to/coverletter3.docx
4 | 4 | 4 | /path/to/resume4.pdf | /path/to/coverletter4.docx
5 | 5 | 5 | /path/to/resume5.pdf | /path/to/coverletter5.docx