Database Schema — IllustrateTheWord & SermonWise
All tables owned by sermon-illustrations/ and SermonWise — illustration content, scripture analysis, theological lenses, lectionary, word studies, and user subscriptions
All tables owned by sermon-illustrations/ and SermonWise — illustration content, scripture analysis, theological lenses, lectionary, word studies, and user subscriptions
Decision
Three-tier deletion procedure for SermonWise user data — soft-delete (user-initiated), 30-day cron sweep (automated hard-delete), and full account-wipe (compliance request handler)
Source of truth for what goes on sermonwise.ai/help. Any change here must be reflected in src/app/sermons/help/page.tsx and vice versa.
Product overview for SermonWise AI ($19.95/mo) — AI-powered sermon preparation tools served at sermonwise.ai via hostname rewrite from churchwiseai-web's /sermons route
The 6 signup→upgrade PostHog events that make the SermonWise conversion funnel measurable. Documents where each event fires, identity stitching pattern, and known failure modes.
What a SermonWise Pro customer sees at every touchpoint — discovery through working product