Companies

CompanyIDNameIndustry
1TechCorpTechnology
2FinancialInstituteBanking
3HealthCareIncHealthcare

Locations

LocationIDCityStateCountry
1New YorkNYUSA
2Los AngelesCAUSA
3LondonEnglandUK

Positions

PositionIDTitleMinEducationLevelMaxYearsExperience
1Software EngineerBachelor2
2AccountantBachelor3
3Data ScientistMaster1

Benefits

BenefitIDTypeAmount
1Health Insurance0.0
2Paid Time Off20.0
3Retirement Plan6.0

JobPostings

PostingIDCompanyIDPositionIDBusinessProfessionCommissionStructurePostedDate
(→ Companies.CompanyID)(→ Positions.PositionID)
111Sales RepresentativeBase Salary Plus Commission2024-03-07 21:07:41
222Sales RepresentativeDraw Against Commissions2024-03-07 21:07:41
313Marketing ManagerBase Salary Plus Commission2024-03-07 21:07:41
424Marketing ManagerNo Commission Structure2024-03-07 21:07:41

JobSalaries

SalaryIDPostingIDStartingSalaryEndingSalary
(→ JobPostings.PostingID)
1150000.070000.0
2245000.065000.0
3380000.090000.0
4470000.085000.0

JobBenefits

BenefitIDPostingID
(→ JobPostings.PostingID)
11
22
13
24