Browse Templates/Patient Records (EHR)

Patient Records (EHR)

A comprehensive electronic health records (EHR) database schema for hospitals and healthcare facilities. Includes patient demographics, doctor profiles with specializations, appointment scheduling, detailed medical records, prescription tracking, and diagnosis management with ICD codes. Ideal for building HIPAA-compliant healthcare applications, hospital management systems, or patient portal platforms.

PostgreSQL10 tablesHealthcare
healthcareehrpatientsmedical-recordshospitalhipaa
Created with ERD Studio

Tables in this template

patientsPatients
9 cols
departmentsDepartments
5 cols
doctorsDoctors
9 cols
appointmentsAppointments
7 cols
medical_recordsMedical Records
8 cols
prescriptionsPrescriptions
5 cols
prescription_itemsPrescription Items
6 cols
diagnosesDiagnoses
6 cols
lab_resultsLab Results
8 cols
insurance_claimsInsurance Claims
9 cols

Related Templates

View all templates
Patient Records (EHR) Database Schema Template | ERD Studio