Changes between Version 1 and Version 2 of Логички и физички дизајн - Креирање база податоци

Timestamp:

08/15/25 23:31:24 (5 days ago)

Author:

173067

Comment:

--

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

@@ -14 +14 @@
 
 
-Airport ( **__AirportID__**, **Name**, **__City*__**, **Country**, **Code** )
+Airport ( **__AirportID__**, **Name**, **__DestinationID*__**, **Country**, **Code**)
 
-- City рефенцира кон Destination.
+- DestinationID рефенцира кон Destination.
 
 
-Flight ( **__FlightID__**, **Flight number**, **__Departure Airport*__**, **__Arrival Airport*__**, **Departure time**, **Arrival time**, **Duration**, **Price**, **Available seats** )
+Flight ( **__FlightID__**, **Flight number**, **__DepartureAirportID*__**, **__ArrivalAirportID*__**, **Departure time**, **Arrival time**, **Duration**, **Price**, **Available seats** )
 
-- Departure Airport референцира кон Airport.
-- Arrival Airport референцира кон Airport.
+- DepartureAirportID референцира кон Airport.
+- ArrivalAirportID референцира кон Airport.
 
 
-
-Booking ( **__BookindID__**, **__UserID*__**, **__FlightID*__**, **Booking date**, **Payment status**, **Total cost**, Seat number )
+Booking ( **__BookindID__**, **__UserID*__**, **Booking date**, **Payment status**, **Total cost**)
     
 - UserID референцира кон ApplicationUser.
-- FlightID референцира кон Flight.
 
 
+BookingFlight(**_BookindID*_**, **FlightID*_**, SeatNumber)
 
-Review ( **__ReviewID__**, **__UserID*__**, **__TargetID*__**, Review comment, **Rating**, Date )
+- BookingID референцира Booking.
+- FlightID референцира Flight.
+
+
+Review ( **__ReviewID__**, **__UserID*__**, **__BookingID*__**, **TargetID**, TargetType, Review comment, **Rating**, Date )
 
 - UserID референцира кон ApplicationUser.
-- TargetID референцира кон Flight, Destination, Booking.
+- BookingID референцира кон Flight, Destination, Booking.
 
 
@@ -59 +62 @@
 Administrator ( **__AdminID__**, **Email** )
 
-Support Ticket ( **__TicketID__**, **__UserID*__**, **Subject**, Description, **Status**, **Date created**, **Date resolved**, **_Assigned to*_** )
+Support Ticket ( **__TicketID__**, **__UserID*__**, **__BookingID*__**, **Subject**, Description, **Status**, **Date created**, **Date resolved**, **_Assigned to*_** )
 
 - UserID референцира кон User.
 - AssignedTo референцира кон Administrator.
+- BookingID референцира кон Booking.