CompanyID | CompanyName | Address | City | State | ZipCode |
---|---|---|---|---|---|
1 | Company A | 123 Main St | New York | NY | 10001 |
2 | Company B | 456 Elm St | Los Angeles | CA | 90001 |
3 | Company C | 789 Oak St | Chicago | IL | 60601 |
4 | Company D | 001 Pine St | Houston | TX | 77001 |
5 | Company E | 111 Fir St | Miami | FL | 33101 |
JobPostID | Title | Description | Location | PostedDate | DeadlineDate | CompanyID |
---|---|---|---|---|---|---|
(→ Companies.CompanyID) | ||||||
1 | Real Estate Agent | Sell properties on commission | Anywhere | 2022-01-01 | 2022-02-01 | 1 |
2 | Real Estate Agent | Assist clients buying/selling homes | Anywhere | 2022-01-15 | 2022-02-15 | 2 |
3 | Property Manager | Manage rental properties | Anywhere | 2022-01-05 | 2022-02-05 | 3 |
4 | Property Manager | Oversee maintenance and leasing of commercial buildings | Anywhere | 2022-01-10 | 2022-02-10 | 4 |
5 | Real Estate Analyst | Analyze market trends and provide insights | Anywhere | 2022-01-02 | 2022-02-02 | 5 |
TypeID | TypeDescription |
---|---|
1 | Residential Sales |
2 | Commercial Leasing |
3 | Property Management |
4 | Real Estate Analysis |
5 | Appraisal Services |
RoleID | RoleTitle | CommissionRate |
---|---|---|
1 | Sales Agent | 5% |
2 | Associate Broker | 6% |
3 | Broker | 7% |
4 | Leasing Specialist | 5% |
5 | Asset Manager | N/A |
AssignmentID | JobPostID | RoleID | TypeID |
---|---|---|---|
(→ JobPosts.JobPostID) | (→ JobRoles.RoleID) | (→ RealEstateJobTypes.TypeID) | |
1 | 1 | 1 | 1 |
2 | 2 | 2 | 1 |
3 | 3 | 3 | 2 |
4 | 4 | 4 | 2 |
5 | 5 | 5 | 3 |