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
- Company Panel Doctor Appointment Letter Template
- Disputing Medical Bills: A Step-by-Step Guide
- Certified Medical Assistant Salary (2023): National Average, Range & Top States
- Understanding Discrepancies Between Deposits and Credits on Patient Ledgers
- Medical Coding Explained: How Insurance Processes Healthcare Claims
- Understanding Token Payments for Medical Bills: A Guide
- Medical Bill in Collections Despite Payments: Step-by-Step Resolution Guide
