Changes between Version 16 and Version 17 of konceptualenDizajnLogickiFizicki

Timestamp:

05/05/25 12:57:29 (3 weeks ago)

Author:

213209

Comment:

--

konceptualenDizajnLogickiFizicki

@@ -6 +6 @@
 
 == Шема
-Customer('''__customerId__''', registrationDate, firstName, lastName, email, password, role, phone, address, membershipLevel)
+User('''id''', firstName, lastName, email, password, role, phone, address, membershipLevel, registrationDate)
 
-Reservation('''__reservationId__''', '''customerId'''*(Customer), '''paymentId'''*(Payment), '''menuId'''*(Menu), '''tableId'''*(Table), paymentStatus, partySize, reservationDateTime, specialRequests, status, checkInTime, checkOutTime)
+Restaurant('''restaurantId''', name, address, cuisineType, phone, operatingHours, website, socialMediaLinks, rating)
 
-Payment('''__paymentId__''', '''__customerId__'''*(Customer), totalPrice, date, reservationNumber)
+TableEntity('''tableId''', '''restaurantId'''*(Restaurant), capacity, location, isSmokingArea, description, reservationDurationHours)
 
-Menu('''__menuId__''', '''restaurantId'''*(Restaurant), category)
+Menu('''menuId''', '''restaurantId'''*(Restaurant), itemName, category, price, description)
 
-Item('''__itemId__''', '''menuIditemName'''*(Menu), price, description, dietaryInformation)
+MenuTag('''id''', '''menuId'''*(Menu), tagName, tagValue)
 
-Restaurant('''__restaurantId__''', name, address, cuisineType, phone, operatingHours, deposit, website, socialMediaLinks, rating)
+Reservation('''reservationId''', '''userId'''(User), '''tableId'''(TableEntity), '''restaurantId'''*(Restaurant), reservationDateTime, partySize, specialRequests, status, checkInTime, checkOutTime, paymentStatus)
 
-Table('''__tableId__''', '''restaurantId'''*(Restaurant), capacity, location, isSmokingArea, description)
+PreorderedItem('''id''', '''reservationId'''*(Reservation), name, quantity, price)
 
-item_reservtion_junction('''reservationId'''*(Reservation), '''itemId'''*(Item)
+ReservationHistory('''id''', '''customerId'''(User), '''tableId'''(TableEntity), '''restaurantId'''*(Restaurant), reservationDateTime, partySize, specialRequests, status, cancellationReason, checkInDate)
 
 == DDL скрипта за бришење на табелите и креирање на табелите
@@ -28 +28 @@
 
 == Релациски дијаграм изведен од DBeaver
-[[Image(dbeaverDijagram.jpg​)]]
+[[Image(final_er_norm.jpg​)]]