Changes between Version 2 and Version 3 of RelationalDesign


Ignore:
Timestamp:
12/01/22 15:09:14 (2 years ago)
Author:
181085
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • RelationalDesign

    v2 v3  
    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__*) \\
     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) \\
    66* Car(__Car_Id__, License_plate*, __Type_Id__*) \\
    77* Car_Type(__Type_Id__, Make*, Model, Year*) \\
    8 * Drive(__Drive_Id__, Destination Coordinates, Grade, Status, Km_travelled, __Pick_up_address_Id__*, __Payment_Id__) \\
     8* Drive(__Drive_Id__, Status*, Allow_Others*, __Driver_Id__, __Head_Passenger_Id__*, __Car_Id__) \\
     9* Payment(__Payment_Id__, Total_Sum_Payed*, Share_sum_payed, __Drive_Id*__, __Passenger_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__*) \\
    912* Pick_Up_Address(__Pick_up_address_Id__, City, Street, Number, Location Coordinates) \\
    10 * Payment(__Payment_Id__, Sum_Payed*, __Drive_Id*__) \\
    11 * Passenger(__Passenger_Id__, Name*, Surname*, Email*, Password*) \\
    12 * Driver_Confirm_Drive(__Driver_Id*__, __Drive_Id*__) \\
    13 * Passenger_Request_Drive(__Passenger_Id*__, __Drive_Id*__) \\
     13
    1414
    1515= DDL скрипта за бришење на табелите и креирање на табелите