| | 2 | == Релациска шема (со мапирачка трансформација) |
| | 3 | * Bold и Italic-> Key attribute |
| | 4 | * Bold и * -> Foreign key |
| | 5 | * Bold -> required |
| | 6 | |
| | 7 | ---- |
| | 8 | * Users(**''user_id'',email,username,first_name,last_name,password,created_on**,modified_on) |
| | 9 | * Clients(**''user_id''***) |
| | 10 | * Business_Users(**''user_id''***) |
| | 11 | * Administrators(**''user_id''***) |
| | 12 | * Delivery_Man(**''user_id''*,business_user_id*,company_id* ,salary,date_of_employment**) |
| | 13 | * Companies(**''company_id'',company_name,company_email,created_on,created_by,user_id***,modified_on,modified_by,**administrator_id***) |
| | 14 | * Vehicles(**''vehicle_id'',chassis_number,vehicle_type,fuel_efficiency,company_id*,model_id* ,registration_id*,brand,price**) |
| | 15 | * Models(**''model_id'',model_name,year,color,number_of_seats,number_of_doors,fuel,transmission,vehicle_type**) |
| | 16 | * Registrations(**''registration_id'',plate_num,registred_on,valid_thru,is_available**) |
| | 17 | * Payment_Cards(**''card_id'',card_number,cvc,valid_thru,holder_name,user_id***) |
| | 18 | * Locations(**''location_id,company_id*'',city,street,street_number**) |
| | 19 | * Payments(**''payment_id,card_id*'', payment_date,time**) |
| | 20 | * Contracts(**''signed_date,user_id*,vehicle_id*,deliveryman_id*,payment_id*,card_id*'',address,from_date,to_date**) |
| | 21 | * Is_responsible_for(**''user_id*,vehicle_id*''**) |
| | 22 | |
| | 23 | |
