السيناريو
A telemedicine platform for dermatologists and aesthetic practitioners to manage consultations with patients, prescribe products, and record treatments.
ما الذي يتضمنه هذا الرسم
اقرأ القرارات الكامنة وراءه.
01
Separated Prescription and Treatment from Consultation to allow flexibility in encounter types.
02
Used mandatory foreign keys to ensure data integrity across core relationships.
03
Included UK constraints on email and license_number for uniqueness.
Suitable for any healthcare platform with consultation-based workflows, especially when integrating product prescriptions and procedural treatments.