## Languages

id | name
--- | ---
1 | English
2 | Spanish
3 | French
4 | German
5 | Chinese

## Customer_Service_Advisors

id | advisor_name | language_id
--- | --- | ---
|  | (→ Languages.id)
1 | Alice | 1
2 | Bob | 3
3 | Carol | None
4 | Dave | 5
5 | Eve | 2

## IT_Support_Technicians

id | technician_name | language_id
--- | --- | ---
|  | (→ Languages.id)
1 | Frank | 1
2 | Grace | 3
3 | Hannah | None
4 | Isaac | 5
5 | Jackie | 2

## Job_Postings

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

## CS_Jobs

job_posting_id | customer_service_advisor_id
--- | ---
(→ Job_Postings.id) | (→ Customer_Service_Advisors.id)
1 | 1
1 | 3

## IT_Jobs

job_posting_id | it_support_technician_id
--- | ---
(→ Job_Postings.id) | (→ IT_Support_Technicians.id)
2 | 4
2 | 5
3 | 2