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

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

* Примарен клуч: __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 скрипта за бришење на табелите и креирање на табелите


[attachment:ddlscript-delete.sql]\\
[attachment:ddlscript-create.sql]\\

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

[attachment:dmlscript-populate.sql]

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

[[Image(RelationalDiagram.jpg​)]]