Customer_Service_Advisors

advisorIDnamephoneNumberemailAddresslanguageProficiency
1John Doe+1234567890john@example.comBilingual
2Jane Smith+0987654321jane@example.comMultilingual
3Alice Johnson+7654321987alice@example.comEnglish only
4Michael Brown+1357924680michael@example.comBilingual
5Emma Wilson+0246813579emma@example.comTrilingual

IT_Support_Technicians

technicianIDnamephoneNumberemailAddresslanguageProficiency
1David Lee+1987654320david@example.comBilingual
2James White+0765432198james@example.comMultilingual
3Chris Green+7543219876chris@example.comEnglish only
4Steven Black+1324681357steven@example.comBilingual
5Robert Blue+0254321986robert@example.comTrilingual

Companies

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

Jobs

jobIDtitledescriptionlocationsalary
1Customer Service AdvisorAssist customers with their queries and concerns.New York, NY50000.0
2IT Support TechnicianProvide technical support to clients via phone and email.San Francisco, CA60000.0
3Web DeveloperDesign and develop web applications using HTML, CSS, JavaScript, and other technologies.Berlin, Germany70000.0
4Data AnalystAnalyze data sets and provide insights to improve business performance.London, UK65000.0
5Network EngineerDesign, implement, and maintain computer networks for businesses.Toronto, Canada75000.0

Applications

applicationIDapplicantIDjobIDresumePathcoverLetterPath
(→ Customer_Service_Advisors.advisorID)(→ Jobs.jobID)
111/path/to/resume1.pdf/path/to/coverletter1.docx
222/path/to/resume2.pdf/path/to/coverletter2.docx
333/path/to/resume3.pdf/path/to/coverletter3.docx
444/path/to/resume4.pdf/path/to/coverletter4.docx
555/path/to/resume5.pdf/path/to/coverletter5.docx