Changes between Version 6 and Version 7 of RelationalDesign

Timestamp:

11/24/21 12:05:56 (3 years ago)

Author:

193026

Comment:

--

RelationalDesign

@@ -11 +11 @@
  * reviewer(**__reviewer_id__**, **reviewer_name**, **reviewer_verified**, **reviewer_email**, **reviewer_password** )
 
- * business(**__business_id__**, **business_name**, **business_phone**, **business_descr**, **business_hours**, **business_avg_stars** , **category_id** *(category))
+ * business(**__business_id__**, **business_name**, **business_phone**, **business_descr**, **business_hours**, **category_id** *(category))
    * Секундарен клуч: ''category_id е референца кон category(category_id)и има not null constraint поради тотално учество на Businesses во релацијата belongs_to''
 
@@ -25 +25 @@
    * Секундарен клуч: ''address_id e рефернца кон address(address_id)''
 
- * business_service(**__business_service_id__**, **business_id** *(business), **service_id** *(service))
-   * Секундарен клуч: ''business_id е референца кон business(business_id) ''
-   * Секундарен клуч: ''service_id  е референца кон service(service_id) ''
+ * business_service( **business_id** *(business), **service_id** *(service))
+   * Композитен примарен клуч (business_id, service_id)
+   * ''business_id е референца кон business(business_id) ''
+   * ''service_id  е референца кон service(service_id) ''
 
 === Креирање на табели