Changes between Initial Version and Version 1 of RelationalDesign

Timestamp:

08/26/25 01:32:53 (3 days ago)

Author:

222003

Comment:

--

RelationalDesign

@@ +1 @@
+== Релациско Мапирање ==
+
+=== Ознаки ===
+
+* Примарните кличеви се болдирани и подвлечени.
+* Надворешните кличеви се означени со * до името на надворешниот клуч и во заградата () е името на ентитетот кој го референцираат
+* Задолжителните атрибути се болдирани
+
+=== Табели ===
+
+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)
+33. Branded_Medicine_InstanceOf_Medicine (**__branded_medicine_id*(BrandedMedicine)__**, **__medicine_id*(Medicine)__**)
+
+=== DDL скрипта за бришење и креирање на табелите ===
+
+
+=== DDL скрипта за полнење на табелите со податоци ===
+
+
+== Релациски Дијаграм ==