Changes between Version 7 and Version 8 of Логички
- Timestamp:
- 01/31/25 21:01:18 (3 weeks ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Логички
v7 v8 12 12 Flight ( **__FlightID__**, **Flight number**, **__Departure Airport*__**, **__Arrival Airport*__**, **Departure time**, **Arrival time**, **Duration**, **Price**, **Available seats** ) 13 13 14 {{{ 15 Departure Airport референцира кон Airport. 16 Arrival Airport референцира кон Airport. 17 }}} 14 - Departure Airport референцира кон Airport. 15 - Arrival Airport референцира кон Airport. 16 18 17 19 18 20 19 Booking ( **__BookindID__**, **__UserID*__**, **__FlightID*__**, **Booking date**, **Payment status**, **Total cost**, Seat number ) 21 20 22 {{{ 23 UserID референцира кон User. 24 FlightID референцира кон Flight. 25 }}} 21 - UserID референцира кон User. 22 - FlightID референцира кон Flight. 23 26 24 27 25 … … 30 28 Review ( **__ReviewID__**, **__UserID*__**, **__TargetID*__**, Review comment, **Rating**, Date ) 31 29 32 {{{ 33 UserID референцира кон User. 34 TargetID референцира кон Flight, Destination, Airport, Booking. 35 }}} 30 - UserID референцира кон User. 31 - TargetID референцира кон Flight, Destination, Airport, Booking. 36 32 37 33 38 34 Airport ( **__AirportID__**, **Name**, **__City*__**, **Country**, **Code** ) 39 35 40 {{{ 41 City рефенцира кон Destination. 42 }}} 36 - City рефенцира кон Destination. 43 37 44 38 45 39 Payment ( **__PaymentID__**, **__BookingID*__**, **__UserID*__**, **Payment method**, **Amount**, **Transaction date**, **Payment Status** ) 46 40 47 {{{ 48 BookingID референцира кон Booking. 49 UserID референцира кон User. 50 }}} 41 - BookingID референцира кон Booking. 42 - UserID референцира кон User. 51 43 52 44 53 45 Notification ( **__NotificationID__**, **__UserID*__**, Message, Type, Date Sent ) 54 46 55 {{{ 56 UserID референцира кон User. 57 }}} 47 - UserID референцира кон User. 58 48 59 49 60 50 Wishlist ( **__WishlistID__**, **__UserID*__**, **__TargetID*__**, Date added ) 61 51 62 {{{ 63 UserID референцира кон User. 64 TargetID референцира кон Flight, Destination. 65 }}} 52 - UserID референцира кон User. 53 - TargetID референцира кон Flight, Destination. 66 54 67 55 … … 70 58 Support Ticket ( **__TicketID__**, **__UserID*__**, **Subject**, Description, **Status**, **Date created**, **Date resolved**, Assigned to ) 71 59 72 {{{ 73 UserID референцира кон User. 74 }}} 60 - UserID референцира кон User. 61 75 62 76 63 == DDL скрипта за бришење на табелите и креирање на табелите 77 64 65 [attachment:ddlscript-create.sql] 66 [attachment:ddlscript-delete.sql] 67 78 68 == DML скрипта за полнење на табелите со податоци 79 69 70 [attachment:dmlscript-populate.sql] 71 80 72 == Релациски дијаграм изведен
