Логички и физички дизајн

Релациска шема

• Примарен клуч: underline
• Надворешен клуч: underline и *
• Not null: bold

---

ApplicationUser ( UserID, Name, Surname, Email, Password, Phone number, Date joined )

Destination ( DestinationID, Name, Country, Description, Popular Attraction, Best time to visit )

Airport ( AirportID, Name, DestinationID*, Country, Code)

• DestinationID рефенцира кон Destination.

Flight ( FlightID, Flight number, DepartureAirportID*, ArrivalAirportID*, Departure time, Arrival time, Duration, Price, Available seats )

• DepartureAirportID референцира кон Airport.
• ArrivalAirportID референцира кон Airport.

Booking ( BookindID, UserID*, Booking date, Payment status, Total cost)

• UserID референцира кон ApplicationUser.

BookingFlight(_BookindID*_, FlightID*_, SeatNumber)

• BookingID референцира Booking.
• FlightID референцира Flight.

Review ( ReviewID, UserID*, BookingID*, TargetID, TargetType, Review comment, Rating, Date )

• UserID референцира кон ApplicationUser.
• BookingID референцира кон Flight, Destination, Booking.

Payment ( PaymentID, BookingID*, UserID*, Payment method, Amount, Transaction date, Payment Status )

• BookingID референцира кон Booking.
• UserID референцира кон ApplicationUser.

Notification ( NotificationID, UserID*, Message, Type, Date Sent )

• UserID референцира кон ApplicationUser.

Wishlist ( WishlistID, UserID*, TargetID*, Date added )

• UserID референцира кон ApplicationUser.
• TargetID референцира кон Flight, Destination.

Administrator ( AdminID, Email )

Support Ticket ( TicketID, UserID*, BookingID*, Subject, Description, Status, Date created, Date resolved, _Assigned to*_ )

• UserID референцира кон User.
• AssignedTo референцира кон Administrator.
• BookingID референцира кон Booking.

DDL скрипта за бришење на табелите и креирање на табелите

ddlscript-delete.sql​
ddlscript-create.sql​

DML скрипта за полнење на табелите со податоци

dmlscript-populate.sql​

Релациски дијаграм изведен од Data Grip