Real_Estate_Agents

agent_idnamephone_numberemailcommission
1John Doe+1234567890john@example.com5%
2Jane Smith+0987654321jane@example.com3%
3Mike Johnson+9876543210mike@example.com2%

Property_Managers

manager_idnamephone_numberemailcommission
1Alice Brown+9876543211alice@example.com5%
2Bob White+1234567891bob@example.com3%
3Charlie Black+1122334455charlie@example.com2%

Listed_Properties

property_idaddresspricelisting_datestatus
1123 Main St$5000002024-03-13 17:23:06Available
2456 Elm St$3000002024-03-13 17:23:06Under Contract
3789 Oak St$4000002024-03-13 17:23:06Active
4000 Pine St$2000002024-03-13 17:23:06Pending Sale
5999 Fir St$1000002024-03-13 17:23:06Rented

Agent_Listings

agent_listing_idreal_estate_agent_idproperty_id
(→ Real_Estate_Agents.agent_id)(→ Listed_Properties.property_id)
111
222
333
414
525

Manager_Listings

manager_listing_idproperty_manager_idproperty_id
(→ Property_Managers.manager_id)(→ Listed_Properties.property_id)
111
222
333
414
525

Clients

client_idfirst_namelast_namephone_numberemail
1TomHanks+1112223333tomhanks@email.com
2EmmaWatson+4445556666emmawatson@email.com
3LeonardoDiCaprio+7778889999leodicaprio@email.com
4KevinCostner+9998887777kevincostner@email.com
5AngelinaJolie+10001001000angelinajolie@email.com