Changes between Version 19 and Version 20 of RelationalDesign


Ignore:
Timestamp:
09/12/25 20:34:39 (7 days ago)
Author:
222003
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • RelationalDesign

    v19 v20  
    393915. Pharmacy (**__company_id*(Company)__**)
    4040
    41 16. Prescription (**__id__**, client_id*(Client), **__medicine_id*(Medicine)__**, **issued_by**, **issued_at**, **valid_to**, **embg**)
     4116. Prescription (**__id__**, client_id*(Client), **medicine_id*(Medicine)**, **issued_by**, **issued_at**, **valid_to**, **embg**)
    4242
    434317. !SensitiveClientData (**__id__**, **client_id*(Client)**, pharmacist_id*(Pharmacist), **embg**, **portrait_photo**, **verification_status**)
     
    515121. !BrandedMedicineImage (**__id__**, **branded_medicine_id*(!BrandedMedicine)**, **image**, **is_main_image**)
    5252
    53 22. !ClubCard (**__id__**, **__user_id*(Client)**, **club_program**, **points**)
     5322. !ClubCard (**__id__**, **user_id*(Client)**, **club_program**, **points**)
    5454
    555523. !ContactInformation (**__id__**, phone, address, user_id*(Users), facility_id*(Facility))
     
    636327. !ClientOrder (**__id__**, **client_id*(Client)**, **delivery_company_id*(!DeliveryCompany)**, **payment_id*(Payment)**, **order_date**, **expected_arrival_date**, **status**, **total_price**)
    6464
    65 28. ClientOrder_BrandedMedicine (**order_id*(!ClientOrder)**, **__branded_medicine_id*(!BrandedMedicine)__**, **quantity**)
     6528. ClientOrder_BrandedMedicine (**__order_id*(!ClientOrder)__**, **__branded_medicine_id*(!BrandedMedicine)__**, **quantity**)
    6666
    676729. Pharmacy_Catalog (**__pharmacy_id*(Pharmacy)__**, **__branded_medicine_id*(!BrandedMedicine)__**)