## Companies

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

## JobPosts

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

## RealEstateJobTypes

TypeID | TypeDescription
--- | ---
1 | Residential Sales
2 | Commercial Leasing
3 | Property Management
4 | Real Estate Analysis
5 | Appraisal Services

## JobRoles

RoleID | RoleTitle | CommissionRate
--- | --- | ---
1 | Sales Agent | 5%
2 | Associate Broker | 6%
3 | Broker | 7%
4 | Leasing Specialist | 5%
5 | Asset Manager | N/A

## AssignedJobs

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