Changes between Version 10 and Version 11 of RelationalDesign


Ignore:
Timestamp:
12/13/22 15:07:41 (19 months ago)
Author:
181085
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • RelationalDesign

    v10 v11  
    22
    33* Admin(__Admin_Id__, **Name**, **Surname**, **Email**, **Password**) \\
    4 * Driver(__Driver_Id__, **Name**, **Surname**, **Email**, **Password**, Profile_Picture, Price_per_km, Status, is_Approved, Level,**Rewards_Id***, Admin_Id*, **Car_Id***) \\
    5 * Rewards(__Rewards_Id__, Grade, Num_grades) \\
    6 * Car(__Car_Id__, **License_plate**, **Type_Id***) \\
    7 * Car_Type(__Type_Id__, **Make**, Model, **Year**) \\
    8 * Drive(__Drive_Id__, **Status**, **Allow_Others**, Driver_Id*, Head_Passenger_Id*, Car_Id*) \\
    9 * Payment(__Payment_Id__, **Total_Sum_Payed**, **Drive_Id***) \\
     4* Coordinates(__Coordinates_Id__, **Latitude**, **Longitude**) \\
     5* Car(__Car_Id__, **License_plate**, **Make**, **Model**, **Year**) \\
     6* Driver(__Driver_Id__, **Name**, **Surname**, **Email**, **Password**, Profile_Picture, Price_per_km, Status, is_Approved, Level, Num_grades, Grade, Coordinates_Id*, Admin_Id*, **Car_Id***) \\
    107* Passenger(__Passenger_Id__, **Name**, **Surname**, **Email**, **Password**) \\
    11 * Passenger_Request_Drive(**Passenger_Id***, **Drive_Id***, Destination_coordinates, Grade, Km_travelled, Start_time, End_time, **Pick_up_address_Id***) \\
    12 * Pick_Up_Address(__Pick_up_address_Id__, City, Street, Number, **Location Coordinates**) \\
     8* Request(__Request_Id__, **Passenger_Id***, Drive_Id*, Pick_Up_Coordinates*, Chosen_Driver_Id*, Confirmed_By_Driver*, Number_address, City_address, Street_address, **Status**) \\
     9* Drive(__Drive_Id__, Driver_Id*, Request_Id*, Car_Id*, Grade, Km_travelled, Start_time, End_time, **Status**) \\
     10* Payment(__Payment_Id__, **Total_Sum_Payed**, **Drive_Id***, **Passenger_Id***) \\
    1311
    1412