## Companies

CompanyID | Name | Industry
--- | --- | ---
1 | TechCorp | Technology
2 | FinancialInstitute | Banking
3 | HealthCareInc | Healthcare

## Locations

LocationID | City | State | Country
--- | --- | --- | ---
1 | New York | NY | USA
2 | Los Angeles | CA | USA
3 | London | England | UK

## Positions

PositionID | Title | MinEducationLevel | MaxYearsExperience
--- | --- | --- | ---
1 | Software Engineer | Bachelor | 2
2 | Accountant | Bachelor | 3
3 | Data Scientist | Master | 1

## Benefits

BenefitID | Type | Amount
--- | --- | ---
1 | Health Insurance | 0.0
2 | Paid Time Off | 20.0
3 | Retirement Plan | 6.0

## JobPostings

PostingID | CompanyID | PositionID | BusinessProfession | CommissionStructure | PostedDate
--- | --- | --- | --- | --- | ---
| (→ Companies.CompanyID) | (→ Positions.PositionID) |  |  |
1 | 1 | 1 | Sales Representative | Base Salary Plus Commission | 2024-03-07 21:07:41
2 | 2 | 2 | Sales Representative | Draw Against Commissions | 2024-03-07 21:07:41
3 | 1 | 3 | Marketing Manager | Base Salary Plus Commission | 2024-03-07 21:07:41
4 | 2 | 4 | Marketing Manager | No Commission Structure | 2024-03-07 21:07:41

## JobSalaries

SalaryID | PostingID | StartingSalary | EndingSalary
--- | --- | --- | ---
| (→ JobPostings.PostingID) |  |
1 | 1 | 50000.0 | 70000.0
2 | 2 | 45000.0 | 65000.0
3 | 3 | 80000.0 | 90000.0
4 | 4 | 70000.0 | 85000.0

## JobBenefits

BenefitID | PostingID
--- | ---
| (→ JobPostings.PostingID)
1 | 1
2 | 2
1 | 3
2 | 4