## Companies

CompanyID | Name | Industry
--- | --- | ---
1 | ABC Corporation | Technology
2 | XYZ Industries | Finance

## Locations

LocationID | City | State | Country
--- | --- | --- | ---
1 | New York | NY | USA
2 | Los Angeles | CA | USA

## TargetMarkets

MarketID | Type
--- | ---
1 | B2B
2 | B2C

## Skills

SkillID | Description
--- | ---
1 | Proficient in CRM software
2 | Excellent communication skills

## Jobs

JobID | Title | Salary | DatePosted | Sales_and_marketing | CompanyID | LocationID
--- | --- | --- | --- | --- | --- | ---
|  |  |  |  | (→ Companies.CompanyID) | (→ Locations.LocationID)
1 | Sales Associate | 60000.0 | 2024-03-13 13:38:07 | 1 | 1 | 1
2 | Sales Associate | 60000.0 | 2024-03-13 13:38:07 | 1 | 2 | 2
3 | Marketing Specialist | 70000.0 | 2024-03-13 13:38:07 | 1 | 1 | 1
4 | Marketing Specialist | 70000.0 | 2024-03-13 13:38:07 | 1 | 2 | 2

## JobSkills

JobID | SkillID
--- | ---
(→ Jobs.JobID) | (→ Skills.SkillID)
1 | 1
1 | 2
2 | 3
2 | 4
3 | 5
3 | 6
4 | 7
4 | 8

## JobMarkets

JobID | MarketID
--- | ---
(→ Jobs.JobID) | (→ TargetMarkets.MarketID)
1 | 1
2 | 2
3 | 1
4 | 2