Changes between Version 7 and Version 8 of RelationalDesign

Timestamp:

12/02/22 11:43:10 (19 months ago)

Author:

192007

Comment:

--

RelationalDesign

@@ -1 +1 @@
 = Relational Design
 == Релациска шема (со мапирачка трансформација)
-* Bold и Italic-> Key attribute
+* Bold и Underline-> Key attribute
 * Bold и * -> Foreign key
 * Bold -> required
 
 ----
-* Users(**''user_id'',email,username,first_name,last_name,password,created_on**,modified_on)
+* Users(**__user_id__,email,username,first_name,last_name,password,created_on**,modified_on)
 * Clients(**''user_id''***)
  - user_id референцира кон Users(user_id)
-* Business_Users(**''user_id''***)
+* Business_Users(**__user_id__***)
  - user_id референцира кон Users(user_id)
-* Administrators(**''user_id''***)
+* Administrators(**__user_id__***)
  - user_id референцира кон Users(user_id)
-* Delivery_Man(**''user_id''*,business_user_id*,company_id* ,salary,date_of_employment**)
+* Delivery_Man(**__user_id__*,business_user_id*,company_id* ,salary,date_of_employment**)
  - user_id референцира кон Users(user_id)
  - business_user_id референцира кон Business_Users(user_id)
  - company_id референцира кон Companies(company_id)
-* Companies(**''company_id'',company_name,company_email,created_on,created_by,user_id***,modified_on,modified_by,**administrator_id***)
+* Companies(**__company_id__,company_name,company_email,created_on,created_by,user_id***,modified_on,modified_by,**administrator_id***)
  - user_id референцира кон Business_Users(user_id)
  - administrator_id референцира кон Administrators(user_id)
-* Vehicles(**''vehicle_id'',chassis_number,vehicle_type,fuel_efficiency,company_id*,model_id* ,registration_id*,brand,price**)
+* Vehicles(**__vehicle_id__,chassis_number,vehicle_type,fuel_efficiency,company_id*,model_id* ,registration_id*,brand,price**)
  - company_id референцира кон Companies(company_id)
  - model_id референцира кон Models(model_id)
  - registration_id референцира кон Registrations(registration_id)
-* Models(**''model_id'',model_name,year,color,number_of_seats,number_of_doors,fuel,transmission,vehicle_type**)
-* Registrations(**''registration_id'',plate_num,registred_on,valid_thru,is_available**)
-* Payment_Cards(**''card_id'',card_number,cvc,valid_thru,holder_name,user_id***)
+* Models(**__model_id__,model_name,year,color,number_of_seats,number_of_doors,fuel,transmission,vehicle_type**)
+* Registrations(**__registration_id__,plate_num,registred_on,valid_thru,is_available**)
+* Payment_Cards(**__card_id__,card_number,cvc,valid_thru,holder_name,user_id***)
  - user_id референцира кон Clients(user_id)
-* Locations(**''location_id,company_id*'',city,street,street_number**)
+* Locations(**__location_id,company_id*__,city,street,street_number**)
  - company_id референцира кон Companies(company_id)
-* Payments(**''payment_id,card_id*'', payment_date,time**)
+* Payments(**__payment_id,card_id*__, payment_date,time**)
  - card_id референцира кон Payment_Cards(card_id)
-* Contracts(**''signed_date,user_id*,vehicle_id*,deliveryman_id*,payment_id*,card_id*'',address,from_date,to_date**)
+* Contracts(**__signed_date,user_id*,vehicle_id*,deliveryman_id*,payment_id*,card_id*__,address,from_date,to_date**)
  - user_id референцира кон Clients(user_id)
  - vehicle_id референцира кон Vehicles(vehicle_id)
@@ -38 +38 @@
  - payment_id референцира кон Payments(payment_id)
  - card_id референцира кон Payments(card_id)
-* Is_responsible_for(**''user_id*,vehicle_id*''**)
+* Is_responsible_for(**__user_id*,vehicle_id*__**)
  - user_id референцира кон Delivery_Man(user_id)
  - vehicle_id референцира кон Vehicles(vehicle_id)