AgentID | Name | PhoneNumber | |
---|---|---|---|
1 | John Doe | john@example.com | 123-456-7890 |
2 | Jane Smith | jane@example.com | 098-765-4321 |
3 | Alice Johnson | alice@example.com | 555-555-5555 |
4 | Bob Brown | bob@example.com | 555-555-5556 |
5 | Charlie White | charlie@example.com | 555-555-5557 |
ManagerID | Name | PhoneNumber | |
---|---|---|---|
1 | Tom Lee | tom@example.com | 111-222-3333 |
2 | Emma Green | emma@example.com | 444-555-6666 |
3 | Michael Blue | michael@example.com | 777-888-9999 |
4 | David Black | david@example.com | 777-777-7777 |
5 | Steven Gray | steven@example.com | 777-777-7778 |
JobID | Description | Location | ListingDate | Status | Commission | AgentID | ManagerID |
---|---|---|---|---|---|---|---|
(→ RealEstateAgents.AgentID) | (→ PropertyManagers.ManagerID) | ||||||
1 | Sell a house | New York | 2024-03-13 19:42:58 | Active | 5% | 1 | 1 |
2 | Rent an apartment | Los Angeles | 2024-03-13 19:42:58 | Closed | 10% | 2 | 2 |
3 | Lease a commercial property | San Francisco | 2024-03-13 19:42:58 | Pending | 7% | 3 | 3 |
4 | List a condo | Chicago | 2024-03-13 19:42:58 | Open | 6% | 4 | 4 |
5 | Sell a townhouse | Dallas | 2024-03-13 19:42:58 | In Progress | 8% | 5 | 5 |
CommissionID | RateText | FeeAmount |
---|---|---|
1 | 5% | 0.05 |
2 | 10% | 0.1 |
3 | 7% | 0.07 |
4 | 6% | 0.06 |
5 | 8% | 0.08 |
FeedbackID | JobID | Rating | Comment |
---|---|---|---|
(→ Jobs.JobID) | |||
1 | 1 | 5 | Great service! |
2 | 2 | 4 | Good job but could have been better. |
3 | 3 | 3 | Not bad, room for improvement. |
4 | 4 | 5 | Excellent work, highly recommended! |
5 | 5 | 2 | Did not meet expectations. |