Changes between Version 9 and Version 10 of RelationalDesign

Timestamp:

08/26/25 22:42:50 (42 hours ago)

Author:

222003

Comment:

--

RelationalDesign

@@ -31 +31 @@
 11. !MedicineInteraction (**__medicine_id_1*(Medicine)__**, **__medicine_id_2*(Medicine)__**, **type**, description, **severity**)
 
-12. Patient (**__user_id*(Users)__**, **is_verified**)
+12. Client(**__user_id*(Users)__**, **is_verified**)
 
-13. Payment (**__id__**, **__patient_id*(Patient)__**, **__payment_method_id*(!PaymentMethod)__**, **payment_date**, **amount**, **status**)
+13. Payment (**__id__**, **__client_id*(Client)__**, **__payment_method_id*(!PaymentMethod)__**, **payment_date**, **amount**, **status**)
 
 14. Pharmacist (**__user_id*(Users)__**)
@@ -39 +39 @@
 15. Pharmacy (**__company_id*(Company)__**)
 
-16. Prescription (**__id__**, patient_id*(Patient), **__medicine_id*(Medicine)__**, **issued_by**, **issued_at**, **valid_to**, **embg**)
+16. Prescription (**__id__**, __client_id*(Client), **__medicine_id*(Medicine)__**, **issued_by**, **issued_at**, **valid_to**, **embg**)
 
-17. !SensitivePatientData (**__id__**, **__patient_id*(Patient)__**, pharmacist_id*(Pharmacist), **embg**, **portrait_photo**)
+17. !SensitiveClientData (**__id__**, **__client_id*(Client)__**, pharmacist_id*(Pharmacist), **embg**, **portrait_photo**)
 
-18. !ShoppingCart (**__id__**, **__patient_id*(Patient)__**)
+18. !ShoppingCart (**__id__**, **__client_id*(Client)__**)
 
 19. !SupplyOrder (**__id__**, **__distributor_id*(Distributor)__**, **__pharmacy_id*(Pharmacy)__**, **order_date**, **expected_arrival_date**)
@@ -51 +51 @@
 21. !BrandedMedicineImage (**__id__**, **__branded_medicine_id*(!BrandedMedicine)__**, **image**)
 
-22. !ClubCard (**__id__**, **__user_id*(Patient)__**, **club_program**, **points**)
+22. !ClubCard (**__id__**, **__user_id*(Client)__**, **club_program**, **points**)
 
 23. !ContactInformation (**__id__**, phone, address, user_id*(User), facility_id*(Facility))
@@ -57 +57 @@
 24. Distributor_BrandedMedicine (**__id__**, **__distributor_id*(Distributor)__**, **__branded_medicine_id*(!BrandedMedicine)__**)
 
-25. !HealthProfile (**__id__**, **__patient_id*(Patient)__**, blood_type)
+25. !HealthProfile (**__id__**, **__client_id*(Client)__**, blood_type)
 
 26. Inventory_BrandedMedicine (**__inventory_id*(Inventory)__**, **__branded_medicine_id*(!BrandedMedicine)__**, **quantity**, **last_changed**)
 
-27. !PatientOrder (**__id__**, **__patient_id*(Patient)__**, **__delivery_company_id*(!DeliveryCompany)__**, **__payment_id*(Payment)__**, **order_date**, **expected_arrival_date**, **status**, **total_price**)
+27. !ClientOrder (**__id__**, **__client_id*(Client)__**, **__delivery_company_id*(!DeliveryCompany)__**, **__payment_id*(Payment)__**, **order_date**, **expected_arrival_date**, **status**, **total_price**)
 
-28. PatientOrder_BrandedMedicine (**__id__**, **order_id*(Order)**, **__branded_medicine_id*(!BrandedMedicine)__**, **quantity**)
+28. ClientOrder_BrandedMedicine (**__id__**, **order_id*(Order)**, **__branded_medicine_id*(!BrandedMedicine)__**, **quantity**)
 
 29. Pharmacy_Catalog (**__pharmacy_id*(Pharmacy)__**, **__branded_medicine_id*(!BrandedMedicine)__**)