| 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 |