|  | Public Health & Safety | Ergonomics

Clinic Management System ER Diagram: Entity‑Relationship Overview

Entity‑Relationship Model for Clinic Management

Core entities and relationships for a clinic information system:

Entities & Attributes

  • Patient: PatientID (PK), Name, Address, Phone, Email, DOB, Gender, MedicalHistory
  • Doctor: DoctorID (PK), Name, Specialty, Degree, Experience, ContactNumber
  • Appointment: AppointmentID (PK), PatientID (FK), DoctorID (FK), Date, Time, Status
  • Prescription: PrescriptionID (PK), DoctorID (FK), PatientID (FK), Date, Details
  • Treatment: TreatmentID (PK), PatientID (FK), DoctorID (FK), Date, Details, Cost
  • Payment: PaymentID (PK), PatientID (FK), DoctorID (FK), Date, Amount, Method

Key Relationships

  • Patient 1:M Appointment
  • Doctor 1:M Appointment
  • Doctor 1:M Prescription
  • Patient 1:M Prescription
  • Patient 1:M Treatment
  • Doctor 1:M Treatment
  • Patient 1:M Payment
  • Doctor 1:M Payment

This model supports scheduling, clinical documentation, billing, and reporting workflows.

Ergonomics - Related Articles