Properties

property_idStreet_AddressCityReal_Estate_OfficesPriceProperty_TypeSquare_Feet
1123 Main StAnytown2300000.0Single Family Home2000
2456 Elm StOthertown1400000.0Condo1200
3789 Oak StAnytown3500000.0Townhouse2500
4999 Pine StDowntown1600000.0Loft2000
5222 Maple AveSuburbia2450000.0Single Family Home3000

RealEstateOffices

real_estate_office_idNameAddressPhoneNumber
1ABC Realty123 Office Rd555-123-4567
2XYZ Real Estate456 Agency Blvd555-234-5678
3Mega Brokers789 Listing Ln555-345-6789
4Local Agents999 Open House Dr555-456-7890
5First Choice Homes222 Sell Now St555-567-8901

Clients

client_idNameEmailPhoneNumber
1John Doejohn@example.com555-111-2222
2Jane Smithjanemsmith@email.com555-333-4444
3Alice Johnsonalice.johnson@yahoo.com555-555-6666
4Bob Brownbobbrown@gmail.com555-777-8888
5Carol Whitecarolwhite@hotmail.com555-999-0000

ClientProperties

client_idproperty_idInterestedDate
(→ Clients.client_id)(→ Properties.property_id)
112023-01-01 10:00:00
222023-02-01 10:00:00
332023-03-01 10:00:00
442023-04-01 10:00:00
552023-05-01 10:00:00

Transactions

transaction_idTransactionDateclient_idproperty_idTypeOfTransaction
(→ Clients.client_id)(→ Properties.property_id)
12023-01-10 10:00:0011Purchase
22023-02-10 10:00:0022Rent
32023-03-10 10:00:0033Lease
42023-04-10 10:00:0044Purchase
52023-05-10 10:00:0055Rent