Property_Management_Companies
id | name | address |
1 | Company1 | Address1 |
2 | Company2 | Address2 |
3 | Company3 | Address3 |
4 | Company4 | Address4 |
5 | Company5 | Address5 |
Services
id | service_name |
1 | Lease Agreement |
2 | Rent Collection |
3 | Maintenance |
4 | Eviction Service |
5 | Tenant Screening |
Properties
id | property_address | price |
1 | Property1 Address | 1000000.0 |
2 | Property2 Address | 800000.0 |
3 | Property3 Address | 900000.0 |
4 | Property4 Address | 700000.0 |
5 | Property5 Address | 600000.0 |
Clients
id | client_name | contact |
1 | Client1 Name | Contact1 |
2 | Client2 Name | Contact2 |
3 | Client3 Name | Contact3 |
4 | Client4 Name | Contact4 |
5 | Client5 Name | Contact5 |
Transactions
transaction_id | property_id | client_id | management_company_id | service_id |
| (→ Properties.id) | (→ Clients.id) | (→ Property_Management_Companies.id) | (→ Services.id) |
1 | 1 | 1 | 1 | 1 |
2 | 2 | 2 | 2 | 2 |
3 | 3 | 3 | 3 | 3 |
4 | 4 | 4 | 4 | 4 |
5 | 5 | 5 | 5 | 5 |
Property_Management_Companies_Services
company_id | service_id |
(→ Property_Management_Companies.id) | (→ Services.id) |
1 | 1 |
2 | 1 |
3 | 1 |
4 | 1 |
5 | 1 |
1 | 2 |
2 | 2 |
3 | 2 |
4 | 2 |
5 | 2 |