Back to Home
ERD Studio
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 →

Pharmacy Management

Pharmacy management system with medications, suppliers, inventory, prescriptions, and sales tracking.

PostgreSQL5 tables
healthcarepharmacymedications+3
Healthcare

Clinic Appointment System

Clinic management system with doctors, patients, appointments, services, and payment tracking.

PostgreSQL5 tables
healthcareclinicappointments+3
Healthcare

Telemedicine Platform

Telehealth platform with providers, patients, consultations, prescriptions, and video session management.

PostgreSQL5 tables
healthcaretelemedicinetelehealth+3
Healthcare

Lab Management System

Laboratory management system with patients, tests, test results, samples, and lab technician tracking.

PostgreSQL5 tables
healthcarelaboratorydiagnostics+3
Healthcare
Patient Records (EHR) Database Schema Template | ERD Studio