Changes between Version 2 and Version 3 of RelationalDesign


Ignore:
Timestamp:
11/24/21 01:44:14 (3 years ago)
Author:
193026
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • RelationalDesign

    v2 v3  
    77
    88==== Табели
    9  * category(__category_id__, **category_name**)
     9 * category(**__category_id__**, **category_name**)
    1010
    11  * reviewer(__reviewer_id__, **reviewer_name**, **reviewer_verified**, **reviewer_email**, **reviewer_password** )
     11 * reviewer(**__reviewer_id__**, **reviewer_name**, **reviewer_verified**, **reviewer_email**, **reviewer_password** )
    1212
    13  * business(__business_id__, **business_name**, **business_phone**, **business_descr**, **business_hours**, **business_avg_stars** , **category_id** *)
     13 * business(**__business_id__**, **business_name**, **business_phone**, **business_descr**, **business_hours**, **business_avg_stars** , **category_id** *)
    1414   * ''category_id е референца кон category(category_id)и има not null constraint поради тотално учество на Businesses во релацијата belongs_to''
    1515
    16  * address(__address_id__, **address_street**, **address_postal_code**, **address_city**, **business_id** *)
     16 * address(**__address_id__**, **address_street**, **address_postal_code**, **address_city**, **business_id** *)
    1717   * ''business_id е референца кон business(business_id) и има not null constraint поради тотално учество на Addresses во релацијата has_address''
    1818
    19  * service(__service_id__, **service_name**, **category_id** *)
     19 * service(**__service_id__**, **service_name**, **category_id** *)
    2020   * ''category_id е референца кон category(category_id)и има not null constraint поради тотално учество на Services во релацијата of''
    2121
    22  * review(__review_id__, **review_title**, **review_text**, **review_stars** , **business_id** *, **reviewer_id** *)
     22 * review(**__review_id__**, **review_title**, **review_text**, **review_stars** , **business_id** *, **reviewer_id** *)
    2323   * ''business_id е референца кон business(business_id) и има not null constraint поради тотално учество на Review во релацијата about''
    2424   * ''reviewer_id e референца кон reviewer(reviewer_id) и има not null constraint поради тотално учество на Review во релацијата left''