Location

idcitystatecountry
1New YorkNYUSA
2Los AngelesCAUSA
3ChicagoILUSA
4MiamiFLUSA
5BostonMAUSA

Neighborhood

idnamelocation_id
(→ Location.id)
1Downtown1
2Southside1
3Westside2
4Northside3
5Eastside4

PropertyType

idtype
1Single Family Home
2Condo
3Townhome
4Apartment
5Mobile Home

House

idproperty_type_idneighborhood_idaddresssquare_footagebedroomsbathroomsExtrasHouse_Price
(→ PropertyType.id)(→ Neighborhood.id)
111123 Main St200043150700000
222456 Elm St150032100600000
333789 Oak St10002180350000
444101 Pine St250043200950000
555202 Maple Ave120032120400000

SaleRecord

idhouse_idsale_datepurchase_price
(→ House.id)
112023-01-01 10:00:00700000
222023-01-02 10:00:00600000
332023-01-03 10:00:00350000
442023-01-04 10:00:00950000
552023-01-05 10:00:00400000

Mortgage

idsale_record_idloan_amountinterest_ratemortgage_termmonthly_paymentstart_dateend_date
(→ SaleRecord.id)
118000003.53025002023-01-012033-01-01
225000003.03021002023-01-022053-01-02
332500004.03010002023-01-032053-01-03
449000003.253029002023-01-042053-01-04
554000004.53015002023-01-052053-01-05