## job_posting

id | title | description | it_jobs | operating_system_knowledge | salary | created_at
--- | --- | --- | --- | --- | --- | ---
1 | IT Support Tech | Support users with computer issues. | IT Support Technician | Windows | 30000.0 | 2024-03-07 22:29:45
2 | Linux Admin | Manage Linux servers. | IT Support Technician | Linux | 40000.0 | 2024-03-07 22:29:45
3 | NetAdmin | Maintain network infrastructure. | Network Administrator | Windows | 60000.0 | 2024-03-07 22:29:45
4 | CloudOps Engineer | Implement cloud solutions. | Network Administrator | AWS | 80000.0 | 2024-03-07 22:29:45
5 | Software Developer | Develop software applications. |  |  | 75000.0 | 2024-03-07 22:29:45
6 | Web Designer | Design user interfaces. |  |  | 55000.0 | 2024-03-07 22:29:45

## company

id | name | email | website
--- | --- | --- | ---
1 | TechCorp | info@techcorp.com | www.techcorp.com
2 | SoftDev Inc | contact@softdevinc.com | www.softdevinc.com
3 | Innovate Ltd | helpdesk@innovateltd.com | www.innovateltd.com
4 | DataWarehouse AG | sales@datawarehouseag.com | www.datawarehouseag.com

## location

id | city | state | country
--- | --- | --- | ---
1 | New York | NY | USA
2 | Chicago | IL | USA
3 | London | England | UK
4 | Paris | Ile-de-France | France

## employee

id | name | email | phone | company_id | location_id
--- | --- | --- | --- | --- | ---
|  |  |  | (→ company.id) | (→ location.id)
1 | John Doe | john.doe@example.com | 123-456-7890 | 1 | 1
2 | Jane Smith | jane.smith@example.com | 098-765-4321 | 1 | 2
3 | Alice Johnson | alice.johnson@example.com | 555-123-4567 | 2 | 3
4 | Bob Brown | bob.brown@example.com | 555-987-6543 | 2 | 4