| id | name | address | city | state | zipcode | num_units |
|---|---|---|---|---|---|---|
| 1 | Building A | 10 Main St | New York | NY | 10001 | 30 |
| 2 | Building B | 20 Elm St | Los Angeles | CA | 90001 | 40 |
| 3 | Building C | 30 Oak St | Chicago | IL | 60601 | 50 |
| 4 | Building D | 40 Pine St | Miami | FL | 33101 | 60 |
| 5 | Building E | 50 Maple Ave | Dallas | TX | 75201 | 70 |
| id | unit_type | description |
|---|---|---|
| 1 | Studio_Apartment | Spacious studio apartment with modern amenities |
| 2 | One-Bedroom | Comfortable one-bedroom apartment with a fully equipped kitchen |
| 3 | Two-Bedroom | Beautiful two-bedroom apartment perfect for families |
| 4 | Three-Bedroom | Luxurious three-bedroom apartment with stunning views |
| 5 | Four-Bedroom | Elegant four-bedroom apartment with private balcony |
| building_id | unit_id |
|---|---|
| (→ Apartment_Buildings.id) | (→ Units.id) |
| 1 | 1 |
| 2 | 1 |
| 3 | 1 |
| 4 | 1 |
| 5 | 1 |
| 5 | 4 |
| tenant_id | firstname | lastname | phone | |
|---|---|---|---|---|
| 1 | John | Smith | johnsmith@email.com | 555-123-4567 |
| 2 | Jane | Doe | janedoemail@email.com | 555-987-6543 |
| 3 | Alice | Wilson | alicewilson@email.com | 555-321-9876 |
| 4 | Bob | Jackson | bobjackson@email.com | 555-654-3210 |
| 5 | Emily | Martin | emilymartin@email.com | 555-135-7890 |
| payment_id | amount | paid_date | due_date | tenant_id |
|---|---|---|---|---|
| (→ Tenants.tenant_id) | ||||
| 1 | 1200 | 2021-10-01 | 2021-10-01 | 1 |
| 2 | 1200 | 2021-10-01 | 2021-10-01 | 2 |
| 3 | 1200 | 2021-10-01 | 2021-10-01 | 3 |
| 4 | 1200 | 2021-10-01 | 2021-10-01 | 4 |
| 5 | 1200 | 2021-10-01 | 2021-10-01 | 5 |