Changes between Version 5 and Version 6 of P2


Ignore:
Timestamp:
12/28/23 17:35:24 (6 months ago)
Author:
161007
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • P2

    v5 v6  
    22=== Ознаки
    33
    4 
     4* **PK** Примарните клучеви се означени со bold и underline
     5* **FK** Надворешните клучеви се означени со *
     6* Задожителните атрибути, односно not null, се означени со bold
    57
    68=== Табели
    79
    810* Book ( **__Book_ID__, Price, Title, Stock_Quantity, Publisher_Date )
     11
    912* Publisher ( **__Publisher_ID__, Publisher_Name )
     13
    1014* Genre ( **__Genre_ID__, Genre_Name )
     15
    1116* Cart ( **__Cart_ID__, Quantity )
     17
    1218* Author ( **__Author_ID__, Author_Name, Email )
     19
    1320* Recommendation ( **__Recommendation_ID__, Date_Recommended )
     21
    1422* Review ( **__Review_ID__, Rating, Comment, Date_Posted )
     23
    1524* Order ( **__Order_ID__, Order_Date, Total_Amount )
     25
    1626* Shipping ( **__Shipping_ID__, Ship_Date, Tracking_Number, Status )
     27
    1728* Payment ( **__Payment_ID__, Payment_Date, Payment_Method, Amount )
     29
    1830* Customer ( **__Customer_ID__, Username, Password, Address, First_Name, Last_Name, Email, Phone )
     31
    1932* Feedback ( **__Feedback_ID__, Feedback_Text, Date_Submitted )
     33
    2034* Wishlist ( **__Wishlist_ID__ )
    2135