Clinic Management System ER Diagram: A Comprehensive Overview
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
Ergonomics - Related Articles
- DIY Small Ramp: Easy Build for Pets & Hand Trucks
- Safe Wheelchair Transfer Techniques: A Comprehensive Guide
- Back Safety: A Guide to Proper Lifting Techniques
- Ergonomic Workstation Design: Tools & Best Practices
- Understanding Erection: Causes, Mechanisms, and Health
- Hand Taping Guide: Injury Prevention & Support
- ESR Test: Understanding Abnormal Results & Possible Causes