id | roomType |
---|---|
1 | Living Room |
2 | Bedroom |
3 | Dining Room |
4 | Kitchen |
5 | Bathroom |
id | featureName |
---|---|
1 | Garage |
2 | Pool |
3 | Balcony |
4 | Air Conditioning |
5 | Fireplace |
id | address | price | numOfFloors |
---|---|---|---|
(→ Houses_Rooms.houseId) | |||
1 | 123 Main St | 300000.0 | 2 |
2 | 456 Oak Ave | 400000.0 | 3 |
3 | 789 Pine St | 500000.0 | 4 |
4 | 101 Elm Blvd | 600000.0 | 3 |
5 | 202 Maple Dr | 700000.0 | 2 |
houseId | roomId |
---|---|
(→ Houses.id) | (→ Rooms.id) |
1 | 4 |
2 | 4 |
3 | 4 |
4 | 4 |
5 | 4 |
5 | 1 |