Changes between Version 16 and Version 17 of RelationalSchema

Timestamp:

01/09/25 12:36:54 (6 days ago)

Author:

221514

Comment:

--

RelationalSchema

@@ -13 +13 @@
 === Relations - Relational Schema ===
 
-`ACCOUNT`(__**email**__, name, surname, password)
+`ACCOUNT`(__**account_id**__, account_email, name, surname, password)
 
-`TRANSPORT_ORGANIZER`(__***account_email**__ (`ACCOUNT`), company_name, company_embg)
+`TRANSPORT_ORGANIZER`(__***account_id**__ (`ACCOUNT`), company_name, company_embg)
 
-`ADMIN`(__***account_email**__ (`ACCOUNT`))
+`ADMIN`(__***account_id**__ (`ACCOUNT`))
 
-`STUDENT`(__***account_email**__ (`ACCOUNT`), university, index)
+`STUDENT`(__***account_id**__ (`ACCOUNT`), university, index)
 
-`DRIVER`(__***account_email**__ (`ACCOUNT`), years_experience, *works_for_email(`TRANSPORT_ORGANIZER`))
+`DRIVER`(__***account_id**__ (`ACCOUNT`), years_experience, *works_for_id(`TRANSPORT_ORGANIZER`))
 
-`VEHICLE`(__**plate_num**__, model, brand, capacity, year_manuf)
+`VEHICLE`(__**vehicle_id**__, plate_num, model, brand, capacity, year_manuf)
 
-`AUTOMOBILE`(__***plate_num**__ (`VEHICLE`))
+`AUTOMOBILE`(__***vehicle_id**__ (`VEHICLE`))
 
-`TRAIN`(__***plate_num**__ (`VEHICLE`))
+`TRAIN`(__***vehicle_id**__ (`VEHICLE`))
 
-`BUS`(__***plate_num**__ (`VEHICLE`))
+`BUS`(__***vehicle_id**__ (`VEHICLE`))
 
-`VAN`(__***plate_num**__ (`VEHICLE`))
+`VAN`(__***vehicle_id**__ (`VEHICLE`))
 
-`DRIVER_VEHICLE_OPERATION`(__***driver_email**__(`DRIVER`), __***plate_num**__(`VEHICLE`))
+`DRIVER_VEHICLE_OPERATION`(__***driver_id**__(`DRIVER`), __***vehicle_id**__(`VEHICLE`))
 
-`TRIP`(__**trid_id**__, __***transport_organizer_email**__(`TRANSPORT_ORGANIZER`), __***route_id**__(`ROUTE`), free_seats, date, status)
+`TRIP`(__**trid_id**__, __***transport_organizer_id**__(`TRANSPORT_ORGANIZER`), __***route_id**__(`ROUTE`), free_seats, date, status)
 
-`DRIVES_ON`(__***driver_email**__(`DRIVER`), __***trip_id**__(`TRIP`))
+`DRIVES_ON`(__***driver_id**__(`DRIVER`), __***trip_id**__(`TRIP`))
 
-`ROUTE`(__**id**__, *transport_organizer_email(`TRANSPORT_ORGANIZER`), *from_loc (`LOCATION`), *to_loc (`LOCATION`))
+`ROUTE`(__**id**__, *transport_organizer_id(`TRANSPORT_ORGANIZER`), *from_loc (`LOCATION`), *to_loc (`LOCATION`))
 
 `DAY_ACTIVE`(__***route_id**(`ROUTE`) __**day**__)
 
-`LOCATION`(__**latitude**__, __**longitude**__, name)
+`LOCATION`(__**location_id**__, latitude, longitude, name)
 
 `TRIP_STOPS`(__***trip_id**__(`TRIP`), __***location**__, time)
 
-`TICKET`(__**id**__, *trip_id(`TRIP`), *gets_on_loc (`LOCATION`), *gets_off_loc (`LOCATION`), *account_email (`ACCOUNT`), date_purchased, time_purchased, price, seat)
+`TICKET`(__**id**__, *trip_id(`TRIP`), *gets_on_loc (`LOCATION`), *gets_off_loc (`LOCATION`), *account_id (`ACCOUNT`), date_purchased, time_purchased, price, seat)
 
 `TICKET_RELATIONS`(*parent_ticket_id(`TICKET`), *child_ticket_id(`TICKET`))
@@ -55 +55 @@
 `CHILD_TICKET`(__***ticket_id**__ (`TICKET`), discount, embg, parent_embg)
 
-`PAYMENT`(__**payment_id**__, __***account_email**__ (`ACCOUNT`), date, total_price, n_tickets)
+`PAYMENT`(__**payment_id**__, __***account_id**__ (`ACCOUNT`), date, total_price, n_tickets)
 
-`FAVORITE`(__***route_id**__(`ROUTE`), __***account_email**__ (`ACCOUNT`))
+`FAVORITE`(__***route_id**__(`ROUTE`), __***account_id**__ (`ACCOUNT`))
 
-`REVIEW`(__**review_id**__, __***account_email**__ (`ACCOUNT`), *ticket_id, description, rating)
+`REVIEW`(__**review_id**__, __***account_id**__ (`ACCOUNT`), *ticket_id, description, rating)
 
 == DDL - Creation and Deletion of Tables ==
 [attachment:routemk_create_and_delete.sql​ RouteMK_Create_and_Delete]
 == Relational Schema Diagram ==
-[[Image(Route_MK_RD_2.png​​)]]
+[[Image(RouteMK-Relational-Schema.jpg​​​)]]