id | address | price |
---|---|---|
1 | 123 Main St | 300000.0 |
2 | 456 Elm St | 400000.0 |
3 | 789 Oak St | 500000.0 |
4 | 101 Maple Ave | 600000.0 |
5 | 222 Pine Blvd | 700000.0 |
feature_id | name |
---|---|
1 | Solar Panels |
2 | Energy Efficient Windows |
3 | Rainwater Harvesting System |
4 | Garden Roof |
5 | Geothermal Heating/Cooling |
green_building_id | feature_id |
---|---|
(→ Green_Buildings.id) | (→ Features.feature_id) |
1 | 1 |
1 | 2 |
2 | 3 |
2 | 4 |
3 | 5 |
3 | 1 |
4 | 2 |
4 | 3 |
5 | 4 |
5 | 5 |
2 | 1 |
4 | 1 |
5 | 1 |