Changes between Version 22 and Version 23 of konceptualenDizajnLogickiFizicki

Timestamp:

05/19/25 13:00:58 (8 weeks ago)

Author:

213209

Comment:

--

konceptualenDizajnLogickiFizicki

@@ -6 +6 @@
 
 == Шема
-User('''id''', firstName, lastName, email, password, role, phone, address, membershipLevel, registrationDate)
+User('''userId''', firstName, lastName, email, password, role, phone, address, membershipLevel, registrationDate)
 
 Restaurant('''restaurantId''', name, address, cuisineType, phone, operatingHours, website, socialMediaLinks, rating)
@@ -14 +14 @@
 Menu('''menuId''', '''restaurantId'''*(Restaurant), itemName, category, price, description)
 
-MenuTag('''id''', '''menuId'''*(Menu), tagName, tagValue)
+MenuTag('''menuTagId''', '''menuId'''*(Menu), tagName, tagValue)
 
 Reservation('''reservationId''', '''userId'''(User), '''tableId'''(TableEntity), '''restaurantId'''*(Restaurant), reservationDateTime, partySize, specialRequests, status, checkInTime, checkOutTime, paymentStatus)
 
-PreorderedItem('''id''', '''reservationId'''*(Reservation), name, quantity, price)
+PreorderedItem('''preOrderedItem''', '''reservationId'''*(Reservation), name, quantity, price)
 
-ReservationHistory('''id''', '''customerId'''(User), '''tableId'''(TableEntity), '''restaurantId'''*(Restaurant), reservationDateTime, partySize, specialRequests, status, cancellationReason, checkInDate)
+ReservationHistory('''reservationHistoryId''', '''customerId'''(User), '''tableId'''(TableEntity), '''restaurantId'''*(Restaurant), reservationDateTime, partySize, specialRequests, status, cancellationReason, checkInDate)
+
+PriceHistory('''priceHistoryId''', menuId*(Menu), oldPrice, changeDate)  
+
 
 == DDL скрипта за бришење на табелите и креирање на табелите