Real_Estate_Agents
agent_id | name | phone_number | email | commission |
1 | John Doe | +1234567890 | john@example.com | 5% |
2 | Jane Smith | +0987654321 | jane@example.com | 3% |
3 | Mike Johnson | +9876543210 | mike@example.com | 2% |
Property_Managers
manager_id | name | phone_number | email | commission |
1 | Alice Brown | +9876543211 | alice@example.com | 5% |
2 | Bob White | +1234567891 | bob@example.com | 3% |
3 | Charlie Black | +1122334455 | charlie@example.com | 2% |
Listed_Properties
property_id | address | price | listing_date | status |
1 | 123 Main St | $500000 | 2024-03-13 17:23:06 | Available |
2 | 456 Elm St | $300000 | 2024-03-13 17:23:06 | Under Contract |
3 | 789 Oak St | $400000 | 2024-03-13 17:23:06 | Active |
4 | 000 Pine St | $200000 | 2024-03-13 17:23:06 | Pending Sale |
5 | 999 Fir St | $100000 | 2024-03-13 17:23:06 | Rented |
Agent_Listings
agent_listing_id | real_estate_agent_id | property_id |
| (→ Real_Estate_Agents.agent_id) | (→ Listed_Properties.property_id) |
1 | 1 | 1 |
2 | 2 | 2 |
3 | 3 | 3 |
4 | 1 | 4 |
5 | 2 | 5 |
Manager_Listings
manager_listing_id | property_manager_id | property_id |
| (→ Property_Managers.manager_id) | (→ Listed_Properties.property_id) |
1 | 1 | 1 |
2 | 2 | 2 |
3 | 3 | 3 |
4 | 1 | 4 |
5 | 2 | 5 |
Clients
client_id | first_name | last_name | phone_number | email |
1 | Tom | Hanks | +1112223333 | tomhanks@email.com |
2 | Emma | Watson | +4445556666 | emmawatson@email.com |
3 | Leonardo | DiCaprio | +7778889999 | leodicaprio@email.com |
4 | Kevin | Costner | +9998887777 | kevincostner@email.com |
5 | Angelina | Jolie | +10001001000 | angelinajolie@email.com |