Changes between Version 28 and Version 29 of RelationalSchema

Timestamp:

09/24/25 19:29:06 (3 weeks ago)

Author:

221514

Comment:

--

RelationalSchema

@@ -15 +15 @@
 `ACCOUNT`(__**account_id**__, account_email, name, surname, password)
 
-`TRANSPORT_ORGANIZER`(__***account_id**__ (`ACCOUNT`), company_name, company_embg)
+`TRANSPORT_ORGANIZER`(__**transport_organizer_id**__, *accound_id(`ACCOUNT`), company_name, company_embg)
 
-`ADMIN`(__***account_id**__ (`ACCOUNT`))
+`ADMIN`(__**admin_id**__, *account_id(`ACCOUNT`))
 
-`STUDENT`(__***account_id**__ (`ACCOUNT`), university, index)
+`STUDENT`(__**student_id**__, *account_id(`ACCOUNT`), university, index)
 
-`DRIVER`(__***account_id**__ (`ACCOUNT`), years_experience, *works_for_id(`TRANSPORT_ORGANIZER`))
+`DRIVER`(__**driver_id**__, *account_id (`ACCOUNT`), years_experience, *works_for_id(`TRANSPORT_ORGANIZER`))
 
 `VEHICLE`(__**vehicle_id**__, plate_num, model, brand, capacity, year_manuf)
 
-`AUTOMOBILE`(__***vehicle_id**__ (`VEHICLE`))
+`AUTOMOBILE`(__**automobile_id**__, *vehicle_id(`VEHICLE`))
 
-`TRAIN`(__***vehicle_id**__ (`VEHICLE`))
+`TRAIN`(__**train_id**__, *vehicle_id(`VEHICLE`))
 
-`BUS`(__***vehicle_id**__ (`VEHICLE`))
+`BUS`(__**bus_id**__ ,*vehicle_id(`VEHICLE`))
 
-`VAN`(__***vehicle_id**__ (`VEHICLE`))
+`VAN`(__**van_id**__, *vehicle_id(`VEHICLE`))
 
-`DRIVER_VEHICLE_OPERATION`(__***driver_id**__(`DRIVER`), __***vehicle_id**__(`VEHICLE`))
+`DRIVER_VEHICLE_OPERATION`(__***driver_id**__(`DRIVER`), *vehicle_id(`VEHICLE`))
 
-`TRIP`(__**trid_id**__, __***transport_organizer_id**__(`TRANSPORT_ORGANIZER`), __***route_id**__(`ROUTE`), __***account_id**__(`DRIVER`), __***vehicle_id**__(`VEHICLE`), free_seats, date, status)
+`TRIP`(__**trip_id**__, *transport_organizer_id(`TRANSPORT_ORGANIZER`), *route_id(`ROUTE`), *account_id(`DRIVER`), *vehicle_id(`VEHICLE`), free_seats, date, status)
 
-`DRIVES_ON`(__***driver_id**__(`DRIVER`), __***trip_id**__(`TRIP`))
+`DRIVES_ON`(__**drives_on_id**__, *driver_id(`DRIVER`), *trip_id(`TRIP`))
 
-`ROUTE`(__**id**__, *transport_organizer_id(`TRANSPORT_ORGANIZER`), *from_loc (`LOCATION`), *to_loc (`LOCATION`))
-
-`DAY_ACTIVE`(__***route_id**(`ROUTE`) __**day**__)
+`ROUTE`(__**route_id**__, *transport_organizer_id(`TRANSPORT_ORGANIZER`), *from_loc_id (`LOCATION`), *to_loc_id (`LOCATION`))
 
 `LOCATION`(__**location_id**__, latitude, longitude, name)
 
-`TRIP_STOPS`(__***trip_id**__(`TRIP`), __***location**__, time)
+`TRIP_STOPS`(__***trip_id**__(`TRIP`), *location_id, time)
 
-`TICKET`(__**id**__, *trip_id(`TRIP`), *gets_on_loc (`LOCATION`), *gets_off_loc (`LOCATION`), *account_id (`ACCOUNT`), date_purchased, time_purchased, price, seat)
+`TICKET`(__**ticket_id**__, *trip_id(`TRIP`), *ticket_related_to_id(`TICKET`), *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`))
+`STUDENT_TICKET`(__**student_ticket_id**__, *ticket_id(`TICKET`), discount)
 
-`STUDENT_TICKET`(__***ticket_id**__ (`TICKET`), discount)
+`CHILD_TICKET`(__**child_ticket_id**__, *ticket_id(`TICKET`), discount, embg, parent_embg)
 
-`CHILD_TICKET`(__***ticket_id**__ (`TICKET`), discount, embg, parent_embg)
+`PAYMENT`(__**payment_id**__, *account_id(`ACCOUNT`),*ticket_id(`TICKET`), date, total_price, n_tickets)
 
-`PAYMENT`(__**payment_id**__, __***account_id**__ (`ACCOUNT`),__***ticket_id**__ (`TICKET`), date, total_price, n_tickets)
+`FAVORITE`(__**favorite_id**__, *route_id(`ROUTE`), *account_id(`ACCOUNT`))
 
-`FAVORITE`(__***route_id**__(`ROUTE`), __***account_id**__ (`ACCOUNT`))
-
-`REVIEW`(__**review_id**__, __***account_id**__ (`ACCOUNT`), __***ticket_id**__ (`TICKET`), description, rating)
+`REVIEW`(__**review_id**__, *account_id(`ACCOUNT`), *ticket_id(`TICKET`), description, rating)
 
 === DDL - Creation, Deletion and Insertion with dummy data of Tables