Changes between Version 1 and Version 2 of RelationalSchema

Timestamp:

12/17/24 13:02:52 (4 weeks ago)

Author:

222077

Comment:

--

RelationalSchema

@@ -21 +21 @@
 `STUDENT`(__***account_email**__ (`ACCOUNT`), university, index)
 
-`DRIVER`(__***account_email**__ (`ACCOUNT`), years_experience, *company (`TRANSPORT_ORGANIZER`))
+`DRIVER`(__***account_email**__ (`ACCOUNT`), years_experience)
 
 `VEHICLE`(__**plate_num**__, model, brand, capacity, year_manuf)
@@ -47 +47 @@
 `TRIP_STOPS`(__***trip**__, __***location**__, at_time)
 
-`TICKET`(__**id**__, *for_trip (`TRIP`), *linked_with (`TICKET`), *gets_on_loc (`LOCATION`), *gets_off_loc (`LOCATION`), *payment, *account, *review, 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, *review_id, date_purchased, time_purchased, price, seat, two_way)
 
 `STUDENT_TICKET`(__***ticket_id**__ (`TICKET`), discount)
@@ -53 +53 @@
 `CHILD_TICKET`(__***ticket_id**__ (`TICKET`), discount, embg, parent_embg)
 
-`PAYMENT`(__**payment_id**__, __***by_account**__ (`ACCOUNT`), date, total_price, n_tickets)
+`PAYMENT`(__**payment_id**__, __***account_email**__ (`ACCOUNT`), date, total_price, n_tickets)
 
-`FAVORITE`(__***route**__, __***account**__)
+`FAVORITE`(__***route**__, __***account_email**__ (`ACCOUNT`))
 
-`REVIEW`(__**review_id**__, __***account**__, *ticket, description, rating)
+`REVIEW`(__**review_id**__, __***account_email**__ (`ACCOUNT`), *ticket_id, description, rating)
 
 == DDL - Creation and Deletion of Tables ==