Changes between Version 15 and Version 16 of RelationalDesign
- Timestamp:
- 09/04/25 00:54:54 (2 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
RelationalDesign
v15 v16 15 15 3. !PaymentMethod (**__id__**, **method_name**) 16 16 17 4. Users (**__id__**, **first_name**, **last_name**, **username**, **hashed_password**, **e_mail**, gender, **date_created**, **date_of_birth** )17 4. Users (**__id__**, **first_name**, **last_name**, **username**, **hashed_password**, **e_mail**, gender, **date_created**, **date_of_birth**, **is_account_non_expired**, **is_account_non_locked**, **is_credentials_non_expired**, **is_enabled**) 18 18 19 19 5. Admins (**__user_id*(Users)__**) … … 23 23 7. Distributor (**__company_id*(Company)__**) 24 24 25 8. Facility (**__id__**, ** __company_id*(Company)__**, **facility_name**, **code**)25 8. Facility (**__id__**, **company_id*(Company)**, **facility_name**, **code**) 26 26 27 27 9. Inventory (**__id__**, **facility_id*(Facility)**) … … 33 33 12. Client(**__user_id*(Users)__**, **is_verified**) 34 34 35 13. Payment (**__id__**, ** __client_id*(Client)__**, **__payment_method_id*(!PaymentMethod)__**, **payment_date**, **amount**, **status**)35 13. Payment (**__id__**, **client_id*(Client)**, **payment_method_id*(!PaymentMethod)**, **payment_date**, **amount**, **status**) 36 36 37 37 14. Pharmacist (**__user_id*(Users)__**) … … 39 39 15. Pharmacy (**__company_id*(Company)__**) 40 40 41 16. Prescription (**__id__**, __client_id*(Client), **__medicine_id*(Medicine)__**, **issued_by**, **issued_at**, **valid_to**, **embg**)41 16. Prescription (**__id__**, client_id*(Client), **__medicine_id*(Medicine)__**, **issued_by**, **issued_at**, **valid_to**, **embg**) 42 42 43 17. !SensitiveClientData (**__id__**, ** __client_id*(Client)__**, pharmacist_id*(Pharmacist), **embg**, **portrait_photo**, **verification_status**)43 17. !SensitiveClientData (**__id__**, **client_id*(Client)**, pharmacist_id*(Pharmacist), **embg**, **portrait_photo**, **verification_status**) 44 44 45 18. !ShoppingCart (**__id__**, ** __client_id*(Client)__**)45 18. !ShoppingCart (**__id__**, **client_id*(Client)**) 46 46 47 19. !SupplyOrder (**__id__**, ** __distributor_id*(Distributor)__**, **__pharmacy_id*(Pharmacy)__**, **order_date**, **expected_arrival_date**, **status**)47 19. !SupplyOrder (**__id__**, **distributor_id*(Distributor)**, **pharmacy_id*(Pharmacy)**, **order_date**, **expected_arrival_date**, **status**, **facility_id*(Facility)**) 48 48 49 20. !BrandedMedicine (**__id__**, ** __manufacturer_id*(Manufacturer)__**, **name**, **price**, description, **dosage_form**, **strength**, origin_country)49 20. !BrandedMedicine (**__id__**, **manufacturer_id*(Manufacturer)**, **name**, **price**, description, **dosage_form**, **strength**, origin_country) 50 50 51 21. !BrandedMedicineImage (**__id__**, ** __branded_medicine_id*(!BrandedMedicine)__**, **image**)51 21. !BrandedMedicineImage (**__id__**, **branded_medicine_id*(!BrandedMedicine)**, **image**, **is_main_image**) 52 52 53 22. !ClubCard (**__id__**, **__user_id*(Client) __**, **club_program**, **points**)53 22. !ClubCard (**__id__**, **__user_id*(Client)**, **club_program**, **points**) 54 54 55 23. !ContactInformation (**__id__**, phone, address, user_id*(User ), facility_id*(Facility))55 23. !ContactInformation (**__id__**, phone, address, user_id*(Users), facility_id*(Facility)) 56 56 57 24. Distributor_BrandedMedicine (**__ id__**, **__distributor_id*(Distributor)__**, **__branded_medicine_id*(!BrandedMedicine)__**)57 24. Distributor_BrandedMedicine (**__distributor_id*(Distributor)__**, **__branded_medicine_id*(!BrandedMedicine)__**) 58 58 59 25. !HealthProfile (**__id__**, ** __client_id*(Client)__**, blood_type)59 25. !HealthProfile (**__id__**, **client_id*(Client)**, blood_type) 60 60 61 61 26. Inventory_BrandedMedicine (**__inventory_id*(Inventory)__**, **__branded_medicine_id*(!BrandedMedicine)__**, **quantity**, **last_changed**) 62 62 63 27. !ClientOrder (**__id__**, ** __client_id*(Client)__**, **__delivery_company_id*(!DeliveryCompany)__**, **__payment_id*(Payment)__**, **order_date**, **expected_arrival_date**, **status**, **total_price**)63 27. !ClientOrder (**__id__**, **client_id*(Client)**, **delivery_company_id*(!DeliveryCompany)**, **payment_id*(Payment)**, **order_date**, **expected_arrival_date**, **status**, **total_price**) 64 64 65 28. ClientOrder_BrandedMedicine (** __id__**, **order_id*(Order)**, **__branded_medicine_id*(!BrandedMedicine)__**, **quantity**)65 28. ClientOrder_BrandedMedicine (**order_id*(ClientOrder)**, **__branded_medicine_id*(!BrandedMedicine)__**, **quantity**) 66 66 67 67 29. Pharmacy_Catalog (**__pharmacy_id*(Pharmacy)__**, **__branded_medicine_id*(!BrandedMedicine)__**)
