second_opinions

Source: src/db/second-opinions/schema.ts

Columns

TypeScript key	SQL column	Notes
sopId	sop_id
caseId	case_id
userId	user_id
doctorId	doctor_id
requestedDocuments	requested_documents
createdDate	created_date
active	active
isCoordinator	is_coordinator
diagnosisImpression	diagnosis_impression
summary	summary
recommendations	recommendations
doctorOpinionDocuments	doctor_opinion_documents
opinionSubmittedDate	opinion_submitted_date
opinionStatus	opinion_status
delayNotificationSent	delay_notification_sent

Notes

• 1 = coordinator assignment, 0 = not (stored as INTEGER in D1).
• Coordinator-only final summary text.