CompanyID | Name | Industry |
---|---|---|
1 | ABC Corporation | Technology |
2 | XYZ Industries | Finance |
LocationID | City | State | Country |
---|---|---|---|
1 | New York | NY | USA |
2 | Los Angeles | CA | USA |
MarketID | Type |
---|---|
1 | B2B |
2 | B2C |
SkillID | Description |
---|---|
1 | Proficient in CRM software |
2 | Excellent communication skills |
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 |
JobID | SkillID |
---|---|
(→ Jobs.JobID) | (→ Skills.SkillID) |
1 | 1 |
1 | 2 |
2 | 3 |
2 | 4 |
3 | 5 |
3 | 6 |
4 | 7 |
4 | 8 |
JobID | MarketID |
---|---|
(→ Jobs.JobID) | (→ TargetMarkets.MarketID) |
1 | 1 |
2 | 2 |
3 | 1 |
4 | 2 |