Companies

CompanyIDCompanyNameAddressCityStateZipCode
1Company A123 Main StNew YorkNY10001
2Company B456 Elm StLos AngelesCA90001
3Company C789 Oak StChicagoIL60601
4Company D001 Pine StHoustonTX77001
5Company E111 Fir StMiamiFL33101

JobPosts

JobPostIDTitleDescriptionLocationPostedDateDeadlineDateCompanyID
(→ Companies.CompanyID)
1Real Estate AgentSell properties on commissionAnywhere2022-01-012022-02-011
2Real Estate AgentAssist clients buying/selling homesAnywhere2022-01-152022-02-152
3Property ManagerManage rental propertiesAnywhere2022-01-052022-02-053
4Property ManagerOversee maintenance and leasing of commercial buildingsAnywhere2022-01-102022-02-104
5Real Estate AnalystAnalyze market trends and provide insightsAnywhere2022-01-022022-02-025

RealEstateJobTypes

TypeIDTypeDescription
1Residential Sales
2Commercial Leasing
3Property Management
4Real Estate Analysis
5Appraisal Services

JobRoles

RoleIDRoleTitleCommissionRate
1Sales Agent5%
2Associate Broker6%
3Broker7%
4Leasing Specialist5%
5Asset ManagerN/A

AssignedJobs

AssignmentIDJobPostIDRoleIDTypeID
(→ JobPosts.JobPostID)(→ JobRoles.RoleID)(→ RealEstateJobTypes.TypeID)
1111
2221
3332
4442
5553