Changes between Version 4 and Version 5 of RelationalDesign

Timestamp:

08/26/25 01:41:39 (3 days ago)

Author:

222003

Comment:

--

RelationalDesign

@@ -10 +10 @@
 
 1. Company (**__id__**, **company_name**, description, **registration_number**)
+
 2. Medicine (**__id__**, **medicine_name**, **active_ingredient**)
+
 3. !PaymentMethod (**__id__**, **method_name**)
+
 4. Users (**__id__**, **first_name**, **last_name**, **username**, **hashed_password**, **e_mail**, gender, **date_created**)
+
 5. Admins (**__user_id*(Users)__**)
+
 6. !DeliveryCompany (**__company_id*(Company)__**)
+
 7. Distributor (**__company_id*(Company)__**)
+
 8. Facility (**__id__**, **__company_id*(Company)__**, **facility_name**, **code**)
+
 9. Inventory (**__facility_id*(Facility)__**)
+
 10. Manufacturer (**__company_id*(Company)__**)
+
 11. !MedicineInteraction (**__medicine_id_1*(Medicine)__**, **__medicine_id_2*(Medicine)__**, **type**, description, **severity**)
+
 12. Patient (**__user_id*(Users)__**, **is_verified**)
+
 13. Payment (**__id__**, **__patient_id*(Patient)__**, **__payment_method_id*(!PaymentMethod)__**, **payment_date**, **amount**, **status**)
+
 14. Pharmacist (**__user_id*(Users)__**)
+
 15. Pharmacy (**__company_id*(Company)__**)
+
 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**)
+
 22. !ClubCard (**__id__**, **__user_id*(Patient)__**, **club_program**, **points**)
+
 23. !ContactInformation (**__id__**, phone, address, user_id*(User), facility_id*(Facility))
+
 24. Distributor_BrandedMedicine (**__id__**, **__distributor_id*(Distributor)__**, **__branded_medicine_id*(!BrandedMedicine)__**)
+
 25. !HealthProfile (**__id__**, **__patient_id*(Patient)__**, 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**)
+
 28. PatientOrder_BrandedMedicine (**__id__**, **order_id*(Order)**, **__branded_medicine_id*(!BrandedMedicine)__**, **quantity**)
+
 29. Pharmacy_Catalog (**__pharmacy_id*(Pharmacy)__**, **__branded_medicine_id*(!BrandedMedicine)__**)
+
 30. ShoppingCart_BrandedMedicine (**__shopping_cart_id*(!ShoppingCart)__**, **__branded_medicine_id*(!BrandedMedicine)__**, **quantity**)
-31. SupplyOrder_BrandedMedicine (**__supply_order_id*(SupplyOrder)__**, **__branded_medicine_id*(!BrandedMedicine)__**, **quantity**)
-32. AllergicReaction_HealthProfile_Medicine (**__health_profile_id*(HealthProfile)__**, **__medicine_id*(Medicine)__**, date_diagnosed, description, severity)
+
+31. SupplyOrder_BrandedMedicine (**__supply_order_id*(!SupplyOrder)__**, **__branded_medicine_id*(!BrandedMedicine)__**, **quantity**)
+
+32. AllergicReaction_HealthProfile_Medicine (**__health_profile_id*(!HealthProfile)__**, **__medicine_id*(Medicine)__**, date_diagnosed, description, severity)
+
 33. Branded_Medicine_InstanceOf_Medicine (**__branded_medicine_id*(!BrandedMedicine)__**, **__medicine_id*(Medicine)__**)
 
@@ -50 +82 @@
 
 == Релациски Дијаграм ==
+
+[[Image(SynergyMed_relational_dbeaver.png​)]]