Changes between Version 9 and Version 10 of RelationalDesign


Ignore:
Timestamp:
12/07/22 16:16:04 (19 months ago)
Author:
181085
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • RelationalDesign

    v9 v10  
    11= Релациска Шема
    22
    3 * 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__*) \\
     3* 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***) \\
    55* 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*__) \\
    10 * 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) \\
     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***) \\
     10* 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**) \\
    1313
    1414