## Architects

id | name | experience
--- | --- | ---
1 | John Doe | 10
2 | Jane Smith | 7
3 | Michael Johnson | 5
4 | Emily Williams | 8
5 | David Brown | 6

## Building_Types

id | type
--- | ---
1 | Residential
2 | Commercial
3 | Industrial
4 | Institutional
5 | Mixed-Use

## Job_Postings

id | title | description | required_skills | salary | post_date
--- | --- | --- | --- | --- | ---
1 | Senior Residential Architect | Design residential buildings. | AutoCAD, Revit, SketchUp, knowledge of local building codes | 90000.0 | 2024-01-30 19:16:14
2 | Junior Commercial Architect | Assist in designing commercial projects. | AutoCAD, Revit, basic understanding of structural systems | 60000.0 | 2024-01-30 19:16:14
3 | Architectural Designer | Support architects on various project types. | SketchUp, InDesign, Adobe Creative Suite | 50000.0 | 2024-01-30 19:16:14
4 | Project Manager | Oversee construction projects from start to finish. | PMP certification, strong communication skills, knowledge of contract law | 80000.0 | 2024-01-30 19:16:14
5 | BIM Coordinator | Create and manage BIM models for projects. | Revit, Navisworks, Dynamo, Rhino | 65000.0 | 2024-01-30 19:16:14

## Architects_Building_Types

architect_id | building_type_id
--- | ---
(→ Architects.id) | (→ Building_Types.id)
1 | 1
1 | 2
2 | 1
2 | 2
3 | 1
3 | 2
4 | 1
4 | 2
5 | 1
5 | 2