id | name |
---|---|
1 | English |
2 | Spanish |
3 | French |
4 | German |
5 | Chinese |
id | advisor_name | language_id |
---|---|---|
(→ Languages.id) | ||
1 | Alice | 1 |
2 | Bob | 3 |
3 | Carol | None |
4 | Dave | 5 |
5 | Eve | 2 |
id | technician_name | language_id |
---|---|---|
(→ Languages.id) | ||
1 | Frank | 1 |
2 | Grace | 3 |
3 | Hannah | None |
4 | Isaac | 5 |
5 | Jackie | 2 |
id | title | description | location | salary | posted_date |
---|---|---|---|---|---|
1 | CS Advisor | Assist customers via phone and email. | New York | 60000 | 2024-03-13 20:10:28 |
2 | IT Support Tech | Troubleshoot hardware and software issues. | San Francisco | 70000 | 2024-03-13 20:10:28 |
3 | Manager | Oversee operations of a department. | Los Angeles | 90000 | 2024-03-13 20:10:28 |
4 | Engineer | Design and develop new products. | Chicago | 80000 | 2024-03-13 20:10:28 |
5 | Analyst | Analyze data and provide insights. | Miami | 75000 | 2024-03-13 20:10:28 |
job_posting_id | customer_service_advisor_id |
---|---|
(→ Job_Postings.id) | (→ Customer_Service_Advisors.id) |
1 | 1 |
1 | 3 |
job_posting_id | it_support_technician_id |
---|---|
(→ Job_Postings.id) | (→ IT_Support_Technicians.id) |
2 | 4 |
2 | 5 |
3 | 2 |