| 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. |