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 |