Changes between Version 3 and Version 4 of RelationalSchema

Timestamp:

12/17/24 13:15:51 (4 months ago)

Author:

222077

Comment:

--

RelationalSchema

@@ -35 +35 @@
 `VEHICLE_OPERATION`(__***account_email**__(`ACCOUNT`), __***plate_num**__(`VEHICLE`))
 
-`TRIP`(__**trid_id**__, __***transport_organizer_email**__(`ACCOUNT`), __***route**__, free_seats, date, status)
+`TRIP`(__**trid_id**__, __***transport_organizer_email**__(`ACCOUNT`), __***route_id**__(`ROUTE`), free_seats, date, status)
 
-`DRIVES_ON`(__***driver**__, __***trip**__)
+`DRIVES_ON`(__***driver_email**__(`DRIVER`), __***trip_id**__(`TRIP`))
 
 `ROUTE`(__**id**__, *transport_organizer_email(`ACCOUNT`), *from_loc (`LOCATION`), *to_loc (`LOCATION`))
 
-`DAY_ACTIVE`(__***route**, __**day**__)
+`DAY_ACTIVE`(__***route_id**(`ROUTE`) __**day**__)
 
 `LOCATION`(__**latitude**__, __**longitude**__, __**time**__, name)
@@ -55 +55 @@
 `PAYMENT`(__**payment_id**__, __***account_email**__ (`ACCOUNT`), date, total_price, n_tickets)
 
-`FAVORITE`(__***route**__, __***account_email**__ (`ACCOUNT`))
+`FAVORITE`(__***route_id**__(`ROUTE`), __***account_email**__ (`ACCOUNT`))
 
 `REVIEW`(__**review_id**__, __***account_email**__ (`ACCOUNT`), *ticket_id, description, rating)