Hospital Emergency Department ER Diagram: Data Model for Patient Encounters

Entity-Relationship (ER) diagram for a hospital emergency department tracking patients, providers, tests, and encounters:

Entities and Attributes

Patient

  • PatientID (PK)
  • FirstName, LastName
  • Age (or DOB)
  • Address
  • PhoneNumber
  • InsuranceProvider

MedicalDoctor

  • DoctorID (PK)
  • FirstName, LastName
  • Specialty

Associate (Clinical Staff: RN, Tech, PA, etc.)

  • AssociateID (PK)
  • FirstName, LastName
  • Department

Test

  • TestID (PK)
  • TestName
  • Description

Examination (Clinical Encounter)

  • ExaminationID (PK)
  • PatientID (FK → Patient)
  • DoctorID (FK → MedicalDoctor)
  • AssociateID (FK → Associate)
  • TestID (FK → Test)
  • Date (DateTime)
  • Result

Log (Audit Trail)

  • LogID (PK)
  • PatientID (FK → Patient)
  • DoctorID (FK → MedicalDoctor)
  • AssociateID (FK → Associate)
  • ExaminationID (FK → Examination)
  • Date (DateTime)
  • Notes

Relationships

  • Patient 1:M Examination
  • MedicalDoctor 1:M Examination
  • Associate 1:M Examination
  • Test 1:M Examination
  • Examination 1:M Log
  • Patient/Doctor/Associate 1:M Log (direct audit links)

This model supports clinical documentation, billing, quality reporting, and audit compliance. Extend with Triage, Medication, Disposition, and Diagnosis entities for production use.

Medical Billing - Related Articles