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