Changes between Version 1 and Version 2 of RelationalDesign

Timestamp:

08/26/25 01:33:59 (3 days ago)

Author:

222003

Comment:

--

RelationalDesign

@@ -15 +15 @@
 5. Admins (**__user_id*(Users)__**)
 6. DeliveryCompany (**__company_id*(Company)__**)
-7.Distributor (**__company_id*(Company)__**)
+7. Distributor (**__company_id*(Company)__**)
 8. Facility (**__id__**, **__company_id*(Company)__**, **facility_name**, **code**)
 9. Inventory (**__facility_id*(Facility)__**)
@@ -26 +26 @@
 16. Prescription (**__id__**, patient_id*(Patient), **__medicine_id*(Medicine)__**, **issued_by**, **issued_at**, **valid_to**, **embg**)
 17. SensitivePatientData (**__id__**, **__patient_id*(Patient)__**, pharmacist_id*(Pharmacist), **embg**, **portrait_photo**)
-18.ShoppingCart (**__id__**, **__patient_id*(Patient)__**)
-19.SupplyOrder (**__id__**, **__distributor_id*(Distributor)__**, **__pharmacy_id*(Pharmacy)__**, **order_date**, **expected_arrival_date**)
-20.BrandedMedicine (**__id__**, **__manufacturer_id*(Manufacturer)__**, **price**, description, **dosage_form**, **strength**, origin_country)
-21.BrandedMedicineImage (**__id__**, **__branded_medicine_id*(BrandedMedicine)__**, **image**)
+18. ShoppingCart (**__id__**, **__patient_id*(Patient)__**)
+19. SupplyOrder (**__id__**, **__distributor_id*(Distributor)__**, **__pharmacy_id*(Pharmacy)__**, **order_date**, **expected_arrival_date**)
+20. BrandedMedicine (**__id__**, **__manufacturer_id*(Manufacturer)__**, **price**, description, **dosage_form**, **strength**, origin_country)
+21. BrandedMedicineImage (**__id__**, **__branded_medicine_id*(BrandedMedicine)__**, **image**)
 22. ClubCard (**__id__**, **__user_id*(Patient)__**, **club_program**, **points**)
 23. ContactInformation (**__id__**, phone, address, user_id*(User), facility_id*(Facility))