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