## Engineers

id | name | age | experience | salary
--- | --- | --- | --- | ---
1 | John Doe | 26 | 3 | 90000.0
2 | Jane Smith | 31 | 7 | 100000.0
3 | Alice Johnson | 28 | 5 | 80000.0
4 | Bob Brown | 35 | 10 | 120000.0
5 | Chris White | 29 | 4 | 95000.0

## Architects

id | name | age | experience | salary
--- | --- | --- | --- | ---
1 | David Black | 32 | 6 | 80000.0
2 | Emma Green | 30 | 5 | 90000.0
3 | Frank Blue | 33 | 7 | 100000.0
4 | Grace Red | 27 | 4 | 95000.0
5 | Helen Yellow | 25 | 3 | 85000.0

## Companies

id | name | location
--- | --- | ---
1 | CompanyA | New York
2 | CompanyB | Los Angeles
3 | CompanyC | San Francisco
4 | CompanyD | Chicago
5 | CompanyE | Houston

## Jobs

id | title | description | required_skills | posted_date
--- | --- | --- | --- | ---
1 | Software Developer | Design and develop software applications. | Python, Java, C++, .NET | 2022-01-01 00:00:00
2 | Web Designer | Create visually appealing website layouts. | HTML, CSS, JavaScript, UI/UX | 2022-01-02 00:00:00
3 | Data Analyst | Analyze data sets and provide insights. | SQL, R, Python, Excel | 2022-01-03 00:00:00
4 | Graphic Designer | Create visual content for marketing materials. | Adobe Illustrator, Photoshop, InDesign, Sketch | 2022-01-04 00:00:00
5 | Project Manager | Oversee projects and ensure timely completion. | PMP, Agile, Scrum, MS Project | 2022-01-05 00:00:00

## EngineeringJobs

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

## ArchitectureJobs

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