Changes between Initial Version and Version 1 of Логички

Timestamp:

01/26/25 20:37:25 (4 weeks ago)

Author:

173067

Comment:

--

Логички

@@ +1 @@
+= Логички и физички дизајн
+
+== Релациска шема
+
+* Примарен клуч: __underline__
+* Надворешен клуч: __underline__ и *
+* Not null: **bold**
+----
+
+User ( **_UserID_**, **Name**, **Surname**, **Email**, **Password**, **Phone number**, **Date joined** )
+
+Flight ( **_FlightID_**, **Flight number**, **Departure Airport**, **Arrival Airport**, **Departure time**, **Arrival time**, **Duration**, **Price**, **Available seats** )
+
+Booking ( **_BookindID_**, **_UserID*_**, **_FlightID*_**, **Booking date**, **Payment status**, **Total cost**, Seat number )
+    
+{{{
+    UserID референцира кон User.
+    FlightID референцира кон Flight.
+}}}
+
+
+Destination ( **_DestinationID_**, **Name**, **Country**, Description, Popular Attraction, Best time to visit )
+
+Review ( **_ReviewID_**, **_UserID*_**, **_TargetID*_**, Review comment, **Rating**, Date )
+
+Airport ( **_AirportID_**, **Name**, **City**, **Country**, **Code** )
+
+Payment ( **_PaymentID_**, **_BookingID*_**, **_UserID*__**, **Payment method**, **Amount**, **Transaction date**, **Payment Status** )
+
+Notification ( **_NotificationID_**, **_UserID*_**, Message, Type, Date Sent )
+
+Wishlist ( **_WishlistID_**, **_UserID*_**, **_TargetID*_**, Date added )
+
+Administrator ( **_AdminID_**, **Email** )
+
+Support Ticket ( **_TicketID_**, **_UserID*_**, **Subject**, Description, **Status**, **Date created**, **Date resolved**, Assigned to )
+