Changes between Version 24 and Version 25 of RelationalSchema

Timestamp:

09/22/25 21:30:03 (18 hours ago)

Author:

221507

Comment:

--

RelationalSchema

@@ -35 +35 @@
 `DRIVER_VEHICLE_OPERATION`(__***driver_id**__(`DRIVER`), __***vehicle_id**__(`VEHICLE`))
 
-`TRIP`(__**trid_id**__, __***transport_organizer_id**__(`TRANSPORT_ORGANIZER`), __***route_id**__(`ROUTE`), free_seats, date, status)
+`TRIP`(__**trid_id**__, __***transport_organizer_id**__(`TRANSPORT_ORGANIZER`), __***route_id**__(`ROUTE`), __***acoount_id**__(`DRIVER`), __***vehicle_id**__(`VEHICLE`)free_seats, date, status)
 
 `DRIVES_ON`(__***driver_id**__(`DRIVER`), __***trip_id**__(`TRIP`))
@@ -55 +55 @@
 `CHILD_TICKET`(__***ticket_id**__ (`TICKET`), discount, embg, parent_embg)
 
-`PAYMENT`(__**payment_id**__, __***account_id**__ (`ACCOUNT`), date, total_price, n_tickets)
+`PAYMENT`(__**payment_id**__, __***account_id**__ (`ACCOUNT`),__***ticket_id**__ (`TICKET`), date, total_price, n_tickets)
 
 `FAVORITE`(__***route_id**__(`ROUTE`), __***account_id**__ (`ACCOUNT`))
 
-`REVIEW`(__**review_id**__, __***account_id**__ (`ACCOUNT`), *ticket_id, description, rating)
+`REVIEW`(__**review_id**__, __***account_id**__ (`ACCOUNT`), __***ticket_id**__ (`TICKET`), description, rating)
 
 === DDL - Creation, Deletion and Insertion with dummy data of Tables