Changes between Version 2 and Version 3 of BuildBoardF6

Timestamp:

07/08/25 00:08:39 (6 days ago)

Author:

221071

Comment:

--

BuildBoardF6

@@ -161 +161 @@
 начин:
 1. property_image_id → property_image, property_id
+
 2. payment_id → amount, payment_status, payment_date, lease_id, payment_method_id
-3. maintenance_log_id → maintenance_description, maintenance_date,
-service_request_id
+
+3. maintenance_log_id → maintenance_description, maintenance_date,service_request_id
+
 4. inspection_id → inspection_date, notes, lease_id, landlord_profile_id
+
 5. document_id → file_type, file_url, uploaded_at, user_id, lease_id
+
 6. message_id → sent_at, content, user_id, lease_id
+
 7. unit_image_id → unit_image, unit_id
+
 8. tenant_profile_id → user_id
 == Декомпозиција во релации
@@ -232 +238 @@
 **R12.1.3 {user_id, first_name, last_name, email, password_hash, date_of_birth, rating,
 bio} - во BCNF
+
 **R12.1.4 {property_id, user_id, property_type_id, address_id, property_title,
 property_description, created_at} - во BCNF