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 |
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 |
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 |
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 |
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 |