Changes between Initial Version and Version 1 of RelationalDesign


Ignore:
Timestamp:
11/29/22 14:08:05 (2 years ago)
Author:
181085
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • RelationalDesign

    v1 v1  
     1= Релациска Шема
     2
     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__*) \\
     5* Rewards(__Rewards_Id__, Grade, Num_grades) \\
     6* Car(__Car_Id__, License_plate*, __Type_Id__*) \\
     7* Type(__Type_Id__, Make*, Model, Year*) \\
     8* Drive(__Drive_Id__, Destination Coordinates, Grade, Status, Km_travelled, __Pick_up_address_Id__*, __Payment_Id__) \\
     9* 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*__) \\
     14
     15= DDL скрипта за бришење на табелите и креирање на табелите
     16
     17
     18= DML скрипта за полнење на табелите со податоци
     19
     20= Релациски дијаграм изваден од DBeaver