ChatDiagram
database design · healthcare · referral management

Healthcare Provider Referral Management ERD with Prior Authorization

Type ERDNorme Chen 1976 / Everest 1976 (crow's foot)Moteur schematex-erdMis à jour 21/08/2026
Healthcare Provider Referral Management ERD with Prior Authorization
Drawing preview
Le scénario

A hospital referral coordinator needs to track outgoing referrals to specialists and prior authorization requests submitted to payers.

Ce que contient ce dessin

Comprenez les décisions qui le sous-tendent.

01

Modeled Provider, Patient, Insurance, and Specialty as independent entities

02

Linked Referral to Patient, referring Provider, and Specialty; PriorAuthorization links Referral and Insurance

03

Used many-to-one mandatory references for all foreign keys

Reusable for ambulatory referral workflows, specialty care coordination, or payer authorization tracking.

Voir tous les modèles de ERD →