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