RealEstateAgents

AgentIDNameEmailPhoneNumber
1John Doejohn@example.com123-456-7890
2Jane Smithjane@example.com098-765-4321
3Alice Johnsonalice@example.com555-555-5555
4Bob Brownbob@example.com555-555-5556
5Charlie Whitecharlie@example.com555-555-5557

PropertyManagers

ManagerIDNameEmailPhoneNumber
1Tom Leetom@example.com111-222-3333
2Emma Greenemma@example.com444-555-6666
3Michael Bluemichael@example.com777-888-9999
4David Blackdavid@example.com777-777-7777
5Steven Graysteven@example.com777-777-7778

Jobs

JobIDDescriptionLocationListingDateStatusCommissionAgentIDManagerID
(→ RealEstateAgents.AgentID)(→ PropertyManagers.ManagerID)
1Sell a houseNew York2024-03-13 19:42:58Active5%11
2Rent an apartmentLos Angeles2024-03-13 19:42:58Closed10%22
3Lease a commercial propertySan Francisco2024-03-13 19:42:58Pending7%33
4List a condoChicago2024-03-13 19:42:58Open6%44
5Sell a townhouseDallas2024-03-13 19:42:58In Progress8%55

Commissions

CommissionIDRateTextFeeAmount
15%0.05
210%0.1
37%0.07
46%0.06
58%0.08

ClientFeedbacks

FeedbackIDJobIDRatingComment
(→ Jobs.JobID)
115Great service!
224Good job but could have been better.
333Not bad, room for improvement.
445Excellent work, highly recommended!
552Did not meet expectations.