Changes between Version 19 and Version 20 of RelationalDesign
- Timestamp:
- 09/12/25 20:34:39 (7 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
RelationalDesign
v19 v20 39 39 15. Pharmacy (**__company_id*(Company)__**) 40 40 41 16. Prescription (**__id__**, client_id*(Client), ** __medicine_id*(Medicine)__**, **issued_by**, **issued_at**, **valid_to**, **embg**)41 16. Prescription (**__id__**, client_id*(Client), **medicine_id*(Medicine)**, **issued_by**, **issued_at**, **valid_to**, **embg**) 42 42 43 43 17. !SensitiveClientData (**__id__**, **client_id*(Client)**, pharmacist_id*(Pharmacist), **embg**, **portrait_photo**, **verification_status**) … … 51 51 21. !BrandedMedicineImage (**__id__**, **branded_medicine_id*(!BrandedMedicine)**, **image**, **is_main_image**) 52 52 53 22. !ClubCard (**__id__**, ** __user_id*(Client)**, **club_program**, **points**)53 22. !ClubCard (**__id__**, **user_id*(Client)**, **club_program**, **points**) 54 54 55 55 23. !ContactInformation (**__id__**, phone, address, user_id*(Users), facility_id*(Facility)) … … 63 63 27. !ClientOrder (**__id__**, **client_id*(Client)**, **delivery_company_id*(!DeliveryCompany)**, **payment_id*(Payment)**, **order_date**, **expected_arrival_date**, **status**, **total_price**) 64 64 65 28. ClientOrder_BrandedMedicine (** order_id*(!ClientOrder)**, **__branded_medicine_id*(!BrandedMedicine)__**, **quantity**)65 28. ClientOrder_BrandedMedicine (**__order_id*(!ClientOrder)__**, **__branded_medicine_id*(!BrandedMedicine)__**, **quantity**) 66 66 67 67 29. Pharmacy_Catalog (**__pharmacy_id*(Pharmacy)__**, **__branded_medicine_id*(!BrandedMedicine)__**)