Changes between Version 9 and Version 10 of RelationlDesign

Timestamp:

06/25/25 02:32:41 (12 days ago)

Author:

221012

Comment:

--

RelationlDesign

@@ -20 +20 @@
 5. Unit ('''__id__, unit_number, floor, bedrooms, bathrooms, area_sq_m, rent_amount, property_id* (Property)''')
 
-6. Listing ('''__id__, available_from, available_to, status, '''description''', unit_id* (Unit)''')
+6. Listing ('''__id__, title, available_from, available_to, status, '''description''', unit_id* (Unit)''')
 
 7. Lease ('''__id__, start_date, end_date, rent_amount, deposit_amount, listing_id* (Listing), tenant_id* (Tenant_Profile), landlord_id* (Landlord_Profile)''')
@@ -28 +28 @@
 9. Payment_Method ('''__id__, name''')
 
-10. Tenant_Profile ('''__id*__(Profile)''')
+10. Tenant_Profile ('''__id*__(User)''')
 
-11. Landlord_Profile ('''__id*__(Profile), managed_properties_count, is_agent''')
+11. Landlord_Profile ('''__id*__(User), managed_properties_count, is_agent''')
 
 12. Service_Request ('''__id__, decription, request_date, status, lease_id*(Lease), service_category_id * (Service_Category)''')
@@ -42 +42 @@
 16. Document ('''__id__, file_type, file_url, uploaded_at, user_id * (User), lease_id* (Lease)''')
 
-17. Address ('''__id__, street, city, number, country''')
+17. Address ('''__id__, street, municipality, city, number, country''')
 
 18. Message ('''__id__, sent_at, content, from_user_id*(User), to_user_id*(User), lease_id*(Lease)''')
 
 19. Unit_Image ('''__id__, image, unit_id*(Unit)''')
+
+20. Interested ('''__listing_id*, tenant_profile_id__*''')