CondoBuildings
id | address | city | state | zipcode |
1 | 123 Main St | New York | NY | 10001 |
2 | 456 Elm St | Chicago | IL | 60601 |
3 | 789 Oak St | Los Angeles | CA | 90001 |
4 | 246 Maple Ave | Houston | TX | 77001 |
5 | 135 Pine Blvd | Miami | FL | 33101 |
FacilitiesAndServices
id | facilities | services | condos_id |
| | | (→ CondoBuildings.id) |
1 | Pool | Gym | 1 |
2 | Sauna | Parking Lot | 2 |
3 | Laundry Room | Pet Friendly | 3 |
4 | Rooftop Deck | Security System | 4 |
5 | Playground | Storage Units | 5 |
Residents
id | name | age | building_id |
| | | (→ CondoBuildings.id) |
1 | John Doe | 35 | 1 |
2 | Jane Smith | 28 | 2 |
3 | Emma Jones | 42 | 3 |
4 | Tom Brown | 55 | 4 |
5 | Alice Johnson | 30 | 5 |
Transactions
id | resident_id | purchase_price | transaction_date |
| (→ Residents.id) | | |
1 | 1 | 250000.0 | 2024-02-19 11:46:54 |
2 | 2 | 300000.0 | 2024-02-19 11:46:54 |
3 | 3 | 450000.0 | 2024-02-19 11:46:54 |
4 | 4 | 550000.0 | 2024-02-19 11:46:54 |
5 | 5 | 650000.0 | 2024-02-19 11:46:54 |