ER diagram for a clinic management system?
ER Diagram for a Clinic Management System:
[Patient]
- PatientID (Primary Key)
- Name
- Address
- PhoneNumber
- DateOfBirth
- Gender
- MedicalHistory
[Doctor]
- DoctorID (Primary Key)
- Name
- Speciality
- Degree
- Experience
- ContactNumber
[Appointment]
- AppointmentID (Primary Key)
- PatientID (Foreign Key)
- DoctorID (Foreign Key)
- AppointmentDate
- AppointmentTime
- Status (Scheduled, Completed, Cancelled)
[Prescription]
- PrescriptionID (Primary Key)
- DoctorID (Foreign Key)
- PatientID (Foreign Key)
- Date
- Details
[Treatment]
- TreatmentID (Primary Key)
- PatientID (Foreign Key)
- DoctorID (Foreign Key)
- TreatmentDate
- TreatmentDetails
- Cost
[Payment]
- PaymentID (Primary Key)
- PatientID (Foreign Key)
- DoctorID (Foreign Key)
- Date
- Amount
- PaymentMethod