How to Build Patient management system with V0

1// Paste this prompt into V0's AI chat:
2// Build a patient management system. Create a Supabase schema:
3// 1. patients: id (uuid PK), user_id (uuid FK to auth.users NULL), first_name (text), last_name (text), date_of_birth (date), gender (text), phone (text), email (text), address (text), insurance_provider (text), insurance_id (text), blood_type (text), allergies (text[]), emergency_contact (jsonb), created_at (timestamptz)
4// 2. providers: id (uuid PK), user_id (uuid FK to auth.users), first_name (text), last_name (text), specialty (text), license_number (text), schedule_config (jsonb)
5// 3. appointments: id (uuid PK), patient_id (uuid FK to patients), provider_id (uuid FK to providers), start_time (timestamptz), end_time (timestamptz), status (text DEFAULT 'scheduled' CHECK IN 'scheduled','checked_in','in_progress','completed','cancelled','no_show'), reason (text), notes (text)
6// 4. clinical_notes: id (uuid PK), appointment_id (uuid FK to appointments), provider_id (uuid FK to providers), subjective (text), objective (text), assessment (text), plan (text), created_at (timestamptz)
7// 5. prescriptions: id (uuid PK), patient_id (uuid FK to patients), provider_id (uuid FK to providers), appointment_id (uuid FK to appointments), medication (text), dosage (text), frequency (text), duration (text), refills (int DEFAULT 0), status (text DEFAULT 'active')
8// 6. invoices: id (uuid PK), patient_id (uuid FK to patients), appointment_id (uuid FK to appointments), amount_cents (int), insurance_covered_cents (int), patient_owes_cents (int), status (text DEFAULT 'pending'), stripe_payment_id (text), created_at (timestamptz)
9// 7. invoice_items: id (uuid PK), invoice_id (uuid FK to invoices), description (text), amount_cents (int), cpt_code (text)
10// Add RLS so providers see only their patients. Create an RPC function check_appointment_conflict(provider_uuid, start_ts, end_ts) that returns true if an overlapping appointment exists.
11// Generate SQL and types.

1// Paste this prompt into V0's AI chat:
2// Create patient management pages:
3// 1. app/patients/page.tsx — patient registry Table with columns: name, DOB, phone, insurance Badge, last visit date. Add search Input that filters by name or phone. 'Add Patient' Button opens Dialog with registration form.
4// 2. app/patients/[id]/page.tsx — patient chart with Tabs:
5//    - Demographics: personal info, insurance details, allergies (Badge list), emergency contact
6//    - Appointments: Table of past and upcoming appointments with status Badge, link to appointment detail
7//    - Notes: clinical notes list with date, provider, and accordion for SOAP content
8//    - Prescriptions: Table with medication, dosage, frequency, status Badge (active=green, expired=red), refills remaining
9//    - Billing: invoices Table with amount, insurance coverage, patient balance, payment status Badge
10// Use shadcn/ui Tabs, Table, Badge, Dialog, Form, Input, Select, Textarea, Avatar.

1// Paste this prompt into V0's AI chat:
2// Create appointment and clinical note features:
3// 1. app/appointments/page.tsx — daily/weekly calendar view for the logged-in provider. Show appointments as colored blocks based on status. 'New Appointment' Button opens Dialog with:
4//    - Patient Select (searchable), date Calendar picker, time Select, duration Select, reason Textarea
5//    - Server Action that calls check_appointment_conflict RPC before inserting. Show error Toast if conflict.
6// 2. app/appointments/[id]/page.tsx — appointment detail Card: patient info, time, status. Status action Buttons: 'Check In', 'Start', 'Complete', 'No Show', 'Cancel'.
7//    - SOAP Note section: Form with Subjective Textarea, Objective Textarea, Assessment Textarea, Plan Textarea. Validate with zod (each field required, min 10 chars). Save via Server Action.
8//    - Add Prescription Button: Dialog with medication Input, dosage Input, frequency Select, duration Input, refills number Input.
9// Use shadcn/ui Calendar, Form, Textarea, Select, Dialog, Button, Badge, Toast.

1import { NextResponse } from 'next/server'
2import { createClient } from '@supabase/supabase-js'
3import { Resend } from 'resend'
4
5const supabase = createClient(
6  process.env.SUPABASE_URL!,
7  process.env.SUPABASE_SERVICE_ROLE_KEY!
8)
9const resend = new Resend(process.env.RESEND_API_KEY)
10
11export async function GET() {
12  const tomorrow = new Date()
13  tomorrow.setDate(tomorrow.getDate() + 1)
14  const startOfDay = new Date(tomorrow.setHours(0, 0, 0, 0)).toISOString()
15  const endOfDay = new Date(tomorrow.setHours(23, 59, 59, 999)).toISOString()
16
17  const { data: appointments } = await supabase
18    .from('appointments')
19    .select(`
20      id, start_time, reason,
21      patients!inner(first_name, last_name, email),
22      providers!inner(first_name, last_name)
23    `)
24    .eq('status', 'scheduled')
25    .gte('start_time', startOfDay)
26    .lte('start_time', endOfDay)
27
28  if (!appointments?.length) {
29    return NextResponse.json({ sent: 0 })
30  }
31
32  const results = await Promise.allSettled(
33    appointments.map((appt: any) =>
34      resend.emails.send({
35        from: 'clinic@yourdomain.com',
36        to: appt.patients.email,
37        subject: 'Appointment Reminder — Tomorrow',
38        html: `<p>Hi ${appt.patients.first_name},</p>
39               <p>This is a reminder that you have an appointment tomorrow at ${new Date(appt.start_time).toLocaleTimeString()} with Dr. ${appt.providers.last_name}.</p>
40               <p>Reason: ${appt.reason || 'General visit'}</p>`,
41      })
42    )
43  )
44
45  const sent = results.filter((r) => r.status === 'fulfilled').length
46  return NextResponse.json({ sent, total: appointments.length })
47}

1// Paste this prompt into V0's AI chat:
2// Create billing features:
3// 1. app/billing/page.tsx — invoice management Table: patient name, appointment date, total amount, insurance covered, patient owes, status Badge (pending=yellow, paid=green, overdue=red). Filter by status Select and date range.
4// 2. 'Generate Invoice' Button on completed appointments: Dialog with invoice_items — add line items with description Input, CPT code Input, amount Input. Calculate insurance coverage (configurable percentage). Server Action creates invoice and invoice_items rows.
5// 3. 'Send Payment Link' Button: Server Action creates Stripe Payment Link for patient_owes_cents and sends via Resend email.
6// 4. app/api/webhooks/stripe/route.ts — handle payment_intent.succeeded: update invoice status to 'paid', store stripe_payment_id. Use request.text() for signature verification.
7// 5. Configure vercel.json with cron: {"crons": [{"path": "/api/appointments/reminders", "schedule": "0 8 * * *"}]}
8// Use shadcn/ui Table, Badge, Dialog, Input, Button, Separator.