ChatDiagram
database design · healthcare · referral management

Healthcare Provider Referral Management ERD with Prior Authorization

Tipo ERDNorma Chen 1976 / Everest 1976 (crow's foot)Mecanismo schematex-erdAtualizado 21/08/2026
Healthcare Provider Referral Management ERD with Prior Authorization
Drawing preview
O cenário

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

O que há neste desenho

Entenda as decisões por trás dele.

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.

Ver todos os modelos de ERD →