Untitled

mail@pastecode.io avatar
unknown
plain_text
19 days ago
2.1 kB
6
Indexable
Never
 _________          ____________          _______________          _____________
| 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     |
|______________|       |_____________|       |_______________|      |______________|
Leave a Comment