## Apartment_Buildings

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

## Units

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

## Apartment_Buildings_Units

building_id | unit_id
--- | ---
(→ Apartment_Buildings.id) | (→ Units.id)
1 | 1
2 | 1
3 | 1
4 | 1
5 | 1
5 | 4

## Tenants

tenant_id | firstname | lastname | email | 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

## RentPayments

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