Untitled
unknown
plain_text
2 years ago
2.1 kB
14
Indexable
_________ ____________ _______________ _____________
| Patient | | Doctor | | Appointment | | Payment |
|---------| |------------| |----------------| |-------------|
| PatientID|<----- | DoctorID |<------ | AppointmentID | | PaymentID |
| Name | | Name | | AppointmentDate| | PaymentDate |
| Address | | Specializtn| | AppointmentTime| | Amount |
| Phone | | QualifyID | | PatientID |------->| PatientID |
| MedHist | | | | DoctorID | | |
|_________| |____________| |________________| |_____________|
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
| | | |
______v_________ __v___________ __v____________ ____v________
| Medical | | Feedback | | Qualification | | Feedback |
| History | |-------------| | and | |--------------|
|--------------| | FeedbackID | | Certification| | FeedbackID |
| MedicalHistID|<----->| FeedbackDate| | Qualification|<---- | FeedbackDate |
| PatientID | | Comments | | Degree | | Comments |
| MedicalCond | | PatientID | | CertDetails | | PatientID |
| TreatmentHist| | DoctorID | | DoctorID | | DoctorID |
|______________| |_____________| |_______________| |______________|
Editor is loading...
Leave a Comment