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 |