logo
ExamplesEditorPricingDocs
37.1kSign in

Hospital / EHR database schema

The core of an electronic health record: patients and providers, appointments versus encounters, coded conditions and observations, prescriptions against a drug catalogue, allergies and insurance coverage over time.

Hospital EHR ER diagram

Hospital / EHR database schema n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 patients idBIGINT medical_record_nu…VARCHAR given_nameVARCHAR family_nameVARCHAR date_of_birthDATE sex_at_birthVARCHAR gender_identityVARCHAR phoneVARCHAR emailVARCHAR deceased_onDATE created_atTIMESTAMP departments idBIGINT nameVARCHAR codeVARCHAR locationVARCHAR providers idBIGINT department_idBIGINT npi_numberVARCHAR full_nameVARCHAR roleVARCHAR specialtyVARCHAR is_activeBOOLEAN appointments idBIGINT patient_idBIGINT provider_idBIGINT department_idBIGINT scheduled_startTIMESTAMP duration_minutesINTEGER appointment_typeVARCHAR statusVARCHAR reasonVARCHAR created_atTIMESTAMP encounters idBIGINT patient_idBIGINT appointment_idBIGINT attending_provide…BIGINT department_idBIGINT encounter_classVARCHAR admitted_atTIMESTAMP discharged_atTIMESTAMP dispositionVARCHAR conditions idBIGINT patient_idBIGINT encounter_idBIGINT code_systemVARCHAR codeVARCHAR display_nameVARCHAR clinical_statusVARCHAR onset_dateDATE recorded_atTIMESTAMP medications idBIGINT codeVARCHAR nameVARCHAR formVARCHAR strengthVARCHAR is_controlledBOOLEAN prescriptions idBIGINT patient_idBIGINT encounter_idBIGINT medication_idBIGINT prescriber_idBIGINT doseVARCHAR frequencyVARCHAR routeVARCHAR quantityINTEGER refills_allowedINTEGER start_dateDATE end_dateDATE statusVARCHAR observations idBIGINT patient_idBIGINT encounter_idBIGINT code_systemVARCHAR codeVARCHAR display_nameVARCHAR value_numericNUMERIC value_textVARCHAR unitVARCHAR reference_rangeVARCHAR abnormal_flagVARCHAR observed_atTIMESTAMP allergies idBIGINT patient_idBIGINT substance_codeVARCHAR substance_nameVARCHAR reactionVARCHAR severityVARCHAR recorded_by_idBIGINT recorded_atTIMESTAMP insurance_policies idBIGINT patient_idBIGINT payer_nameVARCHAR member_numberVARCHAR group_numberVARCHAR coverage_priorityINTEGER effective_fromDATE effective_toDATE

Related database schemas

MySQL
Education

School & learning management system database schema

Courses versus sections, terms, enrolments that carry the final grade, prerequisites as a self-join, assignments with weights, per-attempt submissions and idempotent attendance registers.

MySQL
Travel

Hotel booking & reservation database schema

A reservation system that actually handles availability: room types versus rooms, rate plans, a per-night rate and inventory calendar, reservations broken down by night, payments and verified reviews.

PostgreSQL
Internal tools

Project management & issue tracker database schema

A Jira-shaped tracker: projects with human-readable issue keys, subtasks through a self-reference, fractional board positions for drag-and-drop, labels, milestones, comments, attachments and a worklog.

MySQL
Healthcare

Clinic appointment scheduling database schema

Outpatient scheduling in MySQL: recurring availability templates that generate slots, appointments that consume exactly one slot, waitlists that backfill cancellations, two-way reminders, referrals, and a dated no-show policy.