Apartment_Buildings

idnameaddresscitystatezipcodenum_units
1Building A10 Main StNew YorkNY1000130
2Building B20 Elm StLos AngelesCA9000140
3Building C30 Oak StChicagoIL6060150
4Building D40 Pine StMiamiFL3310160
5Building E50 Maple AveDallasTX7520170

Units

idunit_typedescription
1Studio_ApartmentSpacious studio apartment with modern amenities
2One-BedroomComfortable one-bedroom apartment with a fully equipped kitchen
3Two-BedroomBeautiful two-bedroom apartment perfect for families
4Three-BedroomLuxurious three-bedroom apartment with stunning views
5Four-BedroomElegant four-bedroom apartment with private balcony

Apartment_Buildings_Units

building_idunit_id
(→ Apartment_Buildings.id)(→ Units.id)
11
21
31
41
51
54

Tenants

tenant_idfirstnamelastnameemailphone
1JohnSmithjohnsmith@email.com555-123-4567
2JaneDoejanedoemail@email.com555-987-6543
3AliceWilsonalicewilson@email.com555-321-9876
4BobJacksonbobjackson@email.com555-654-3210
5EmilyMartinemilymartin@email.com555-135-7890

RentPayments

payment_idamountpaid_datedue_datetenant_id
(→ Tenants.tenant_id)
112002021-10-012021-10-011
212002021-10-012021-10-012
312002021-10-012021-10-013
412002021-10-012021-10-014
512002021-10-012021-10-015