Changes between Version 9 and Version 10 of Логички
- Timestamp:
- 01/31/25 21:07:05 (3 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Логички
v9 v10 8 8 ---- 9 9 10 User ( **__UserID__**, **Name**, **Surname**, **Email**, **Password**, **Phone number**, **Date joined** ) 10 ApplicationUser ( **__UserID__**, **Name**, **Surname**, **Email**, **Password**, **Phone number**, **Date joined** ) 11 12 13 Destination ( **__DestinationID__**, **Name**, **Country**, Description, Popular Attraction, Best time to visit ) 14 15 16 Airport ( **__AirportID__**, **Name**, **__City*__**, **Country**, **Code** ) 17 18 - City рефенцира кон Destination. 19 11 20 12 21 Flight ( **__FlightID__**, **Flight number**, **__Departure Airport*__**, **__Arrival Airport*__**, **Departure time**, **Arrival time**, **Duration**, **Price**, **Available seats** ) … … 19 28 Booking ( **__BookindID__**, **__UserID*__**, **__FlightID*__**, **Booking date**, **Payment status**, **Total cost**, Seat number ) 20 29 21 - UserID референцира кон User.30 - UserID референцира кон ApplicationUser. 22 31 - FlightID референцира кон Flight. 23 32 24 33 25 34 26 Destination ( **__DestinationID__**, **Name**, **Country**, Description, Popular Attraction, Best time to visit )27 28 35 Review ( **__ReviewID__**, **__UserID*__**, **__TargetID*__**, Review comment, **Rating**, Date ) 29 36 30 - UserID референцира кон User.31 - TargetID референцира кон Flight, Destination, Airport,Booking.37 - UserID референцира кон ApplicationUser. 38 - TargetID референцира кон Flight, Destination, Booking. 32 39 33 34 Airport ( **__AirportID__**, **Name**, **__City*__**, **Country**, **Code** )35 36 - City рефенцира кон Destination.37 40 38 41 … … 40 43 41 44 - BookingID референцира кон Booking. 42 - UserID референцира кон User.45 - UserID референцира кон ApplicationUser. 43 46 44 47 45 48 Notification ( **__NotificationID__**, **__UserID*__**, Message, Type, Date Sent ) 46 49 47 - UserID референцира кон User.50 - UserID референцира кон ApplicationUser. 48 51 49 52 50 53 Wishlist ( **__WishlistID__**, **__UserID*__**, **__TargetID*__**, Date added ) 51 54 52 - UserID референцира кон User.55 - UserID референцира кон ApplicationUser. 53 56 - TargetID референцира кон Flight, Destination. 54 57 … … 56 59 Administrator ( **__AdminID__**, **Email** ) 57 60 58 Support Ticket ( **__TicketID__**, **__UserID*__**, **Subject**, Description, **Status**, **Date created**, **Date resolved**, Assigned to)61 Support Ticket ( **__TicketID__**, **__UserID*__**, **Subject**, Description, **Status**, **Date created**, **Date resolved**, **_Assigned to*_** ) 59 62 60 63 - UserID референцира кон User. 64 - AssignedTo референцира кон Administrator. 61 65 62 66