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

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

* Примарен клуч: __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** )

{{{
Departure Airport референцира кон Airport.
Arrival Airport референцира кон Airport.
}}}


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 )

{{{
UserID референцира кон User.
TargetID референцира кон Flight, Destination, Airport, Booking.
}}}


Airport ( **_AirportID_**, **Name**, **_City*_**, **Country**, **Code** )

{{{
City рефенцира кон Destination.
}}}


Payment ( **_PaymentID_**, **_BookingID*_**, **_UserID*_**, **Payment method**, **Amount**, **Transaction date**, **Payment Status** )

{{{
BookingID референцира кон Booking.
UserID референцира кон User.
}}}


Notification ( **_NotificationID_**, **_UserID*_**, Message, Type, Date Sent )

{{{
UserID референцира кон User.
}}}


Wishlist ( **_WishlistID_**, **_UserID*_**, **_TargetID*_**, Date added )

{{{
UserID референцира кон User.
TargetID референцира кон Flight, Destination.
}}}


Administrator ( **_AdminID_**, **Email** )

Support Ticket ( **_TicketID_**, **_UserID*_**, **Subject**, Description, **Status**, **Date created**, **Date resolved**, Assigned to )

{{{
UserID референцира кон User.
}}}

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

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

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