Релациско Мапирање

Ознаки

• Примарните кличеви се болдирани и подвлечени.
• Надворешните кличеви се означени со * до името на надворешниот клуч и во заградата () е името на ентитетот кој го референцираат
• Задолжителните атрибути се болдирани

Табели

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 скрипта за бришење и креирање на табелите

synergymed_ddl.sql

DDL скрипта за полнење на табелите со податоци

Релациски Дијаграм