Home HealthcareTelehealth Platform

Telehealth Platform

Virtual healthcare platform with video appointments, remote prescriptions, chat messaging, and digital triage

SchemaVerse

HealthcarePostgreSQLHealthcareNormalizedREST API

telehealth.dbml

12 tables|17 relations

patients

idinteger

emailvarchar(255)

*UQ

password_hashvarchar(255)

first_namevarchar(100)

last_namevarchar(100)

date_of_birthdate

gendervarchar(20)

phonevarchar(20)

addresstext

created_attimestamp

updated_attimestamp

providers

idinteger

emailvarchar(255)

*UQ

password_hashvarchar(255)

first_namevarchar(100)

last_namevarchar(100)

titlevarchar(50)

specialtyvarchar(100)

license_numbervarchar(50)

*UQ

license_statevarchar(2)

biotext

profile_image_urlvarchar(500)

hourly_ratedecimal(10,2)

is_verifiedboolean

is_activeboolean

created_attimestamp

updated_attimestamp

insurance_info

idinteger

patient_idinteger

FK*

insurance_companyvarchar(255)

policy_numbervarchar(100)

group_numbervarchar(100)

policy_holder_namevarchar(200)

relationship_to_patientvarchar(50)

is_primaryboolean

created_attimestamp

updated_attimestamp

availability_slots

idinteger

provider_idinteger

FK*

day_of_weekinteger

start_timetime

end_timetime

is_activeboolean

created_attimestamp

appointments

idinteger

patient_idinteger

FK*

provider_idinteger

FK*

scheduled_attimestamp

duration_minutesinteger

statusvarchar(20)

appointment_typevarchar(50)

chief_complainttext

cancelled_byvarchar(20)

cancellation_reasontext

created_attimestamp

updated_attimestamp

video_sessions

idinteger

appointment_idinteger

FK*UQ

session_idvarchar(255)

FK*UQ

room_urlvarchar(500)

started_attimestamp

ended_attimestamp

duration_secondsinteger

recording_urlvarchar(500)

statusvarchar(20)

created_attimestamp

medical_notes

idinteger

appointment_idinteger

FK*

provider_idinteger

FK*

patient_idinteger

FK*

subjectivetext

objectivetext

assessmenttext

plantext

notestext

created_attimestamp

updated_attimestamp

prescriptions

idinteger

appointment_idinteger

FK*

patient_idinteger

FK*

provider_idinteger

FK*

medication_namevarchar(255)

dosagevarchar(100)

quantityinteger

frequencyvarchar(100)

refills_allowedinteger

pharmacy_namevarchar(255)

pharmacy_phonevarchar(20)

statusvarchar(20)

prescribed_datedate

created_attimestamp

payment_records

idinteger

appointment_idinteger

FK*

patient_idinteger

FK*

amountdecimal(10,2)

payment_methodvarchar(50)

transaction_idvarchar(100)

FKUQ

statusvarchar(20)

insurance_claim_numbervarchar(100)

paid_attimestamp

created_attimestamp

reviews

idinteger

provider_idinteger

FK*

patient_idinteger

FK*

appointment_idinteger

ratinginteger

commenttext

created_attimestamp

notifications

idinteger

user_idinteger

FK*

user_typevarchar(20)

notification_typevarchar(50)

titlevarchar(255)

messagetext

is_readboolean

read_attimestamp

created_attimestamp

chat_messages

idinteger

appointment_idinteger

FK*

sender_idinteger

FK*

sender_typevarchar(20)

messagetext

is_readboolean

created_attimestamp

React Flow

About this Schema

Overview

Telehealth platform schema enabling remote healthcare delivery. Supports video consultations, asynchronous messaging, digital prescriptions, and patient triage workflows.

Key Design Decisions

Virtual Appointments: Schedule and conduct video consultations
Secure Messaging: HIPAA-compliant patient-provider chat
Digital Prescriptions: E-prescribing integration
Triage System: Pre-appointment symptom screening

Tables

12 tables including appointments, video sessions, messages, prescriptions, triage forms, and consultation notes. Designed for remote care delivery with strong privacy controls.

Comments

Loading comments...