## Software_Engineers

id | name | location | experience | programming_skills
--- | --- | --- | --- | ---
1 | John Doe | New York | 2 years | Python
2 | Jane Smith | San Francisco | 3 years | JavaScript
3 | Michael Johnson | Los Angeles | 5 years | C++
4 | Emily Brown | Chicago | 7 years | Ruby
5 | David Wilson | Dallas | 8 years | Swift

## Data_Scientists

id | name | location | experience | programming_skills
--- | --- | --- | --- | ---
6 | William Thompson | Boston | 4 years | Python
7 | Linda Martinez | Washington | 6 years | R
8 | Thomas Harris | Philadelphia | 9 years | Matlab
9 | Elizabeth Clark | Atlanta | 10 years | Octave
10 | Charles Young | Miami | 12 years | Scala

## Companies

id | company_name | industry
--- | --- | ---
1 | Google | Technology
2 | Amazon | E-commerce
3 | Microsoft | Technology
4 | Facebook | Social Media
5 | Apple | Consumer Electronics

## Jobs

job_id | title | description | salary | posted_date
--- | --- | --- | --- | ---
1 | Software Engineer | Design and develop software applications. | 90000.0 | 2022-01-01
2 | Data Scientist | Analyze complex datasets and provide insights. | 100000.0 | 2022-01-02
3 | Mobile Developer | Create mobile apps using Swift. | 80000.0 | 2022-01-03
4 | Machine Learning Engineer | Build machine learning models. | 120000.0 | 2022-01-04
5 | Web Developer | Develop and maintain websites. | 70000.0 | 2022-01-05

## CompanyJobs

company_id | job_id
--- | ---
(→ Companies.id) | (→ Jobs.job_id)
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5

## EngineerJobs

engineer_id | job_id
--- | ---
(→ Software_Engineers.id) | (→ Jobs.job_id)
1 | 1
2 | 1
3 | 3
4 | 4
5 | 5

## ScientistJobs

scientist_id | job_id
--- | ---
(→ Data_Scientists.id) | (→ Jobs.job_id)
6 | 2
7 | 2
8 | 4
9 | 5
10 | 5