Changes between Version 5 and Version 6 of P2
- Timestamp:
- 12/28/23 17:35:24 (6 months ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
P2
v5 v6 2 2 === Ознаки 3 3 4 4 * **PK** Примарните клучеви се означени со bold и underline 5 * **FK** Надворешните клучеви се означени со * 6 * Задожителните атрибути, односно not null, се означени со bold 5 7 6 8 === Табели 7 9 8 10 * Book ( **__Book_ID__, Price, Title, Stock_Quantity, Publisher_Date ) 11 9 12 * Publisher ( **__Publisher_ID__, Publisher_Name ) 13 10 14 * Genre ( **__Genre_ID__, Genre_Name ) 15 11 16 * Cart ( **__Cart_ID__, Quantity ) 17 12 18 * Author ( **__Author_ID__, Author_Name, Email ) 19 13 20 * Recommendation ( **__Recommendation_ID__, Date_Recommended ) 21 14 22 * Review ( **__Review_ID__, Rating, Comment, Date_Posted ) 23 15 24 * Order ( **__Order_ID__, Order_Date, Total_Amount ) 25 16 26 * Shipping ( **__Shipping_ID__, Ship_Date, Tracking_Number, Status ) 27 17 28 * Payment ( **__Payment_ID__, Payment_Date, Payment_Method, Amount ) 29 18 30 * Customer ( **__Customer_ID__, Username, Password, Address, First_Name, Last_Name, Email, Phone ) 31 19 32 * Feedback ( **__Feedback_ID__, Feedback_Text, Date_Submitted ) 33 20 34 * Wishlist ( **__Wishlist_ID__ ) 21 35