Changes between Version 6 and Version 7 of RelationalDesign
- Timestamp:
- 12/02/22 11:39:23 (2 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
TabularUnified RelationalDesign
v6 v7 8 8 * Users(**''user_id'',email,username,first_name,last_name,password,created_on**,modified_on) 9 9 * Clients(**''user_id''***) 10 - user_id референцира кон Users(user_id) 10 11 * Business_Users(**''user_id''***) 12 - user_id референцира кон Users(user_id) 11 13 * Administrators(**''user_id''***) 14 - user_id референцира кон Users(user_id) 12 15 * Delivery_Man(**''user_id''*,business_user_id*,company_id* ,salary,date_of_employment**) 16 - user_id референцира кон Users(user_id) 17 - business_user_id референцира кон Business_Users(user_id) 18 - company_id референцира кон Companies(company_id) 13 19 * Companies(**''company_id'',company_name,company_email,created_on,created_by,user_id***,modified_on,modified_by,**administrator_id***) 20 - user_id референцира кон Business_Users(user_id) 21 - administrator_id референцира кон Administrators(user_id) 14 22 * Vehicles(**''vehicle_id'',chassis_number,vehicle_type,fuel_efficiency,company_id*,model_id* ,registration_id*,brand,price**) 23 - company_id референцира кон Companies(company_id) 24 - model_id референцира кон Models(model_id) 25 - registration_id референцира кон Registrations(registration_id) 15 26 * Models(**''model_id'',model_name,year,color,number_of_seats,number_of_doors,fuel,transmission,vehicle_type**) 16 27 * Registrations(**''registration_id'',plate_num,registred_on,valid_thru,is_available**) 17 28 * Payment_Cards(**''card_id'',card_number,cvc,valid_thru,holder_name,user_id***) 29 - user_id референцира кон Clients(user_id) 18 30 * Locations(**''location_id,company_id*'',city,street,street_number**) 31 - company_id референцира кон Companies(company_id) 19 32 * Payments(**''payment_id,card_id*'', payment_date,time**) 33 - card_id референцира кон Payment_Cards(card_id) 20 34 * Contracts(**''signed_date,user_id*,vehicle_id*,deliveryman_id*,payment_id*,card_id*'',address,from_date,to_date**) 35 - user_id референцира кон Clients(user_id) 36 - vehicle_id референцира кон Vehicles(vehicle_id) 37 - delivery_man_id референцира кон Delivery_Man(user_id) 38 - payment_id референцира кон Payments(payment_id) 39 - card_id референцира кон Payments(card_id) 21 40 * Is_responsible_for(**''user_id*,vehicle_id*''**) 41 - user_id референцира кон Delivery_Man(user_id) 42 - vehicle_id референцира кон Vehicles(vehicle_id) 22 43 23 44 === ''DDL скрипта за бришење на табелите и креирање на табелите'' … … 30 51 === ''Релациски дијаграм изваден од DBeaver'' 31 52 32 53 [[Image(schema.png)]]