| CompanyID | Name | Industry |
|---|---|---|
| 1 | TechCorp | Technology |
| 2 | FinancialInstitute | Banking |
| 3 | HealthCareInc | Healthcare |
| LocationID | City | State | Country |
|---|---|---|---|
| 1 | New York | NY | USA |
| 2 | Los Angeles | CA | USA |
| 3 | London | England | UK |
| PositionID | Title | MinEducationLevel | MaxYearsExperience |
|---|---|---|---|
| 1 | Software Engineer | Bachelor | 2 |
| 2 | Accountant | Bachelor | 3 |
| 3 | Data Scientist | Master | 1 |
| BenefitID | Type | Amount |
|---|---|---|
| 1 | Health Insurance | 0.0 |
| 2 | Paid Time Off | 20.0 |
| 3 | Retirement Plan | 6.0 |
| 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 |
| 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 |
| BenefitID | PostingID |
|---|---|
| (→ JobPostings.PostingID) | |
| 1 | 1 |
| 2 | 2 |
| 1 | 3 |
| 2 | 4 |