Changes between Version 32 and Version 33 of Логички и физички дизајн - Креирање база податоци (со SQL DDL)

Timestamp:

01/21/25 06:14:37 (30 hours ago)

Author:

201205

Comment:

--

Логички и физички дизајн - Креирање база податоци (со SQL DDL)

@@ -22 +22 @@
     • !BookId референцира кон Book(!BookId)
 
-!LibraryBook(**__LibraryBookId__**, **__InventoryId*__**, **__BookId*__**)
+!ContainsLibraryBook(**__LibraryBookId__**, **__InventoryId*__**, **__BookId*__**)
     • !InventoryId референцира кон Library(!InventoryId)
     • !BookId референцира кон Book(!BookId)
@@ -30 +30 @@
     • !BookId референцира кон Book(!BookId)
 
-!WishlistBook(**__WishlistBookId__**, **__WishId*__**, **__BookId*__**)
+!ContainsWishlistBook(**__WishlistBookId__**, **__WishId*__**, **__BookId*__**)
     • !WishId референцира кон Wishlist(!WishId)
     • !BookId референцира кон Book(!BookId)
@@ -46 +46 @@
     • !InventoryId референцира кон Library(!InventoryId)
 
-!SwapTransaction(**__SwapTransactionId__**, **__TransactionId1__**, **__TransactionId2__**)
+!Swap(**__SwapId__**, **__TransactionId1__**, **__TransactionId2__**)
     • TransactionId1 референцира кон Transaction(!TransactionId)
     • TransactionId2 референцира кон Transaction(!TransactionId)
 
-!TransactionBook( **__TransactionBookId__**, **__TransactionId*__**, **__!BookId*__**)
+!ExchangingBook( **__TransactionBookId__**, **__TransactionId*__**, **__!BookId*__**)
     • !BookId референцира кон Book(!BookId)
     • !TransactionId референцира кон Transaction(!TransactionId)
 
-Review(**__ReviewId__**, **__!TransactionId*__**, **__!ReceiverId*__**, **__!GiverId*__**, **Rating**, !ReviewerComment, **Date**)
+Review(**__ReviewId__**, **__!TransactionId*__**, **__!ReceiverId*__**, **__!GiverId*__**, **Rating**, !ReviewerComment, **!ReviewDate**)
     • !TransactionId референцира кон Transaction(!TransactionId)
     • !ReceiverId референцира кон User(!UserId)
     • !GiverId референцира кон User(!UserId)
 
-Message(**__MessageId__**, **__!SenderId*__**, **__!ReceiverId*__**, **Time**, **Date**, **!MessageContent**)
+Message(**__MessageId__**, **__!SenderId*__**, **__!ReceiverId*__**, **!MsgTime**, **!MsgDate**, **!MessageContent**)
     • !SenderId референцира кон User(!UserId)
     • !ReceiverId референцира кон User(!UserId)
 
-!FriendRequest(**__FriendshipId__**, **__!SenderId*__**, **__!ReceiverId*__**, **!DateCreated**, **Status**)
+!FriendRequest(**__FriendshipId__**, **__!SenderId*__**, **__!ReceiverId*__**, **!DateCreated**, **!FriendshipStatus**)
     • !SenderId референцира кон User(!UserId)
     • !ReceiverId референцира кон User(!UserId)
@@ -71 +71 @@
     • !ReportingUserId референцира кон User(!UserId)
 
-Notification(**__NotificationId__**, __!TransactionId*__, __!MessageId*__, __!FriendRequestId*__, __!BookRequestId*__, **Type**, **Time**, **Date**, **Description**, **Status**)
+Notification(**__NotificationId__**, __!TransactionId*__, __!MessageId*__, __!FriendRequestId*__, __!BookRequestId*__, **Type**, **!NotifTime**, **!NotifDate**, **Description**, **!NotificationStatus**)
     • !TransactionId референцира кон Transaction(!TransactionId)
     • !MessageId референцира кон Transaction(!MessageId)
@@ -77 +77 @@
     • !BookRequestId референцира кон Transaction(!RequestId)
 
-!UserNotification(**__UserNotificationId__**, **__UserId*__**, **__!NotificationId*__**)
+!ReceivesNotification(**__UserNotificationId__**, **__UserId*__**, **__!NotificationId*__**)
     • !ReportedUserId референцира кон User(!UserId)
     • !NotificationId референцира кон Notification(!NotificationId)