Changes between Version 7 and Version 8 of RelationalSchema

Timestamp:

12/17/24 14:53:30 (4 weeks ago)

Author:

222077

Comment:

--

RelationalSchema

@@ -33 +33 @@
 `VAN`(__***plate_num**__ (`VEHICLE`))
 
-`VEHICLE_OPERATION`(__***account_email**__(`ACCOUNT`), __***plate_num**__(`VEHICLE`))
+`DRIVER_VEHICLE_OPERATION`(__***driver_email**__(`DRIVER`), __***plate_num**__(`VEHICLE`))
 
-`TRIP`(__**trid_id**__, __***transport_organizer_email**__(`ACCOUNT`), __***route_id**__(`ROUTE`), free_seats, date, status)
+`TRIP`(__**trid_id**__, __***transport_organizer_email**__(`TRANSPORT_ORGANIZER`), __***route_id**__(`ROUTE`), free_seats, date, status)
 
 `DRIVES_ON`(__***driver_email**__(`DRIVER`), __***trip_id**__(`TRIP`))
 
-`ROUTE`(__**id**__, *transport_organizer_email(`ACCOUNT`), *from_loc (`LOCATION`), *to_loc (`LOCATION`))
+`ROUTE`(__**id**__, *transport_organizer_email(`TRANSPORT_ORGANIZER`), *from_loc (`LOCATION`), *to_loc (`LOCATION`))
 
 `DAY_ACTIVE`(__***route_id**(`ROUTE`) __**day**__)
@@ -47 +47 @@
 `TRIP_STOPS`(__***trip_id**__(`TRIP`), __***location**__, time)
 
-`TICKET`(__**id**__, *trip_id(`TRIP`), *ticket_id(`TICKET`), *gets_on_loc (`LOCATION`), *gets_off_loc (`LOCATION`), *payment_id, *account_email, *review_id, date_purchased, time_purchased, price, seat, two_way)
+`TICKET`(__**id**__, *trip_id(`TRIP`), *ticket_id(`TICKET`), *gets_on_loc (`LOCATION`), *gets_off_loc (`LOCATION`), *payment_id, *account_email (`ACCOUNT`), *review_id, date_purchased, time_purchased, price, seat, two_way)
 
 `STUDENT_TICKET`(__***ticket_id**__ (`TICKET`), discount)