Properties
property_id | Street_Address | City | Real_Estate_Offices | Price | Property_Type | Square_Feet |
1 | 123 Main St | Anytown | 2 | 300000.0 | Single Family Home | 2000 |
2 | 456 Elm St | Othertown | 1 | 400000.0 | Condo | 1200 |
3 | 789 Oak St | Anytown | 3 | 500000.0 | Townhouse | 2500 |
4 | 999 Pine St | Downtown | 1 | 600000.0 | Loft | 2000 |
5 | 222 Maple Ave | Suburbia | 2 | 450000.0 | Single Family Home | 3000 |
RealEstateOffices
real_estate_office_id | Name | Address | PhoneNumber |
1 | ABC Realty | 123 Office Rd | 555-123-4567 |
2 | XYZ Real Estate | 456 Agency Blvd | 555-234-5678 |
3 | Mega Brokers | 789 Listing Ln | 555-345-6789 |
4 | Local Agents | 999 Open House Dr | 555-456-7890 |
5 | First Choice Homes | 222 Sell Now St | 555-567-8901 |
Clients
client_id | Name | Email | PhoneNumber |
1 | John Doe | john@example.com | 555-111-2222 |
2 | Jane Smith | janemsmith@email.com | 555-333-4444 |
3 | Alice Johnson | alice.johnson@yahoo.com | 555-555-6666 |
4 | Bob Brown | bobbrown@gmail.com | 555-777-8888 |
5 | Carol White | carolwhite@hotmail.com | 555-999-0000 |
ClientProperties
client_id | property_id | InterestedDate |
(→ Clients.client_id) | (→ Properties.property_id) | |
1 | 1 | 2023-01-01 10:00:00 |
2 | 2 | 2023-02-01 10:00:00 |
3 | 3 | 2023-03-01 10:00:00 |
4 | 4 | 2023-04-01 10:00:00 |
5 | 5 | 2023-05-01 10:00:00 |
Transactions
transaction_id | TransactionDate | client_id | property_id | TypeOfTransaction |
| | (→ Clients.client_id) | (→ Properties.property_id) | |
1 | 2023-01-10 10:00:00 | 1 | 1 | Purchase |
2 | 2023-02-10 10:00:00 | 2 | 2 | Rent |
3 | 2023-03-10 10:00:00 | 3 | 3 | Lease |
4 | 2023-04-10 10:00:00 | 4 | 4 | Purchase |
5 | 2023-05-10 10:00:00 | 5 | 5 | Rent |