Campaign-to-Book Merge: Comprehensive Architecture Plan

┌─────────────────┐     ┌─────────────────┐     ┌─────────────────┐
│    campaigns    │────▶│     books       │────▶│    stories      │
│                 │     │                 │     │                 │
│ storyteller_*   │     │ story_ids[]     │     │ campaign_id     │
│ template_id     │     │ template_id     │     │ (redundant)     │
│ family_group_id │     │ family_group_id │     │ family_group_id │
│ is_gift         │     │ (redundant?)    │     │ (redundant?)    │
│ status          │     │ status          │     │                 │
└─────────────────┘     └─────────────────┘     └─────────────────┘

/campaigns                           → List all campaigns
/campaigns/create                    → Multi-step wizard (7 steps)
/campaigns/[id]                      → Campaign dashboard
/campaigns/[id]/stories              → Stories list
/campaigns/[id]/stories/new          → Create story
/campaigns/[id]/stories/[id]         → Story view
/campaigns/[id]/stories/[id]/edit    → Edit story
/campaigns/[id]/ai/voice             → AI voice recording
/campaigns/[id]/ai/photo             → AI photo features
/campaigns/[id]/import/voice         → Voice import

/books                               → List all books
/books/new                           → Book creation wizard
/books/[id]                          → Book detail
/books/[id]/edit                     → Edit book
/books/[id]/design                   → Design customization
/books/[id]/chapters                 → Chapter management
/books/[id]/chapters/[id]/edit       → Edit chapter
/books/analytics                     → Analytics dashboard

┌─────────────────────────────────────────────────────────┐
│                         books                           │
│ (Book Project - The single top-level entity)            │
│                                                         │
│ Core Info:                                              │
│   title, subtitle, description                          │
│   author_name, contributor_names[]                      │
│                                                         │
│ Storyteller (NEW - from campaigns):                     │
│   storyteller_name                                      │
│   storyteller_relationship (replaces user_role)         │
│   storyteller_user_id                                   │
│   storyteller_email, storyteller_phone                  │
│                                                         │
│ Template & Content:                                     │
│   template_id (chosen UPFRONT)                          │
│   story_ids[] (chapters)                                │
│   goal_stories, completed_stories                       │
│                                                         │
│ Project Status:                                         │
│   project_status: 'setup'|'collecting'|'editing'|       │
│                   'designing'|'ready'|'published'       │
│   setup_step, setup_progress                            │
│                                                         │
│ Notifications (NEW):                                    │
│   prompt_frequency                                      │
│   notification_preferences (jsonb)                      │
│                                                         │
│ Gift (NEW - from campaigns):                            │
│   is_gift, gift_message                                 │
│   gift_recipient_name, gift_recipient_email             │
│   gift_status, gift_delivery_date                       │
│                                                         │
│ Family:                                                 │
│   family_group_id                                       │
│   (permissions via family_book_permissions)             │
│                                                         │
│ Publishing:                                             │
│   kdp_*, isbn_*, cover_*, design_settings               │
│                                                         │
└─────────────────────────────────────────────────────────┘
                            │
                            │ book_id
                            ▼
┌─────────────────────────────────────────────────────────┐
│                        stories                          │
│                                                         │
│   book_id (NEW - replaces campaign_id)                  │
│   title, content                                        │
│   chapter_number (derived from books.story_ids index)   │
│   prompt (which template prompt was used)               │
│   status, word_count, etc.                              │
│                                                         │
└─────────────────────────────────────────────────────────┘

# Books (primary entity - all content is book-scoped)
/books                               → Dashboard: All book projects
/books/new                           → Create book wizard (template-first)
/books/[id]                          → Book project dashboard
/books/[id]/stories                  → Stories/chapters in this book
/books/[id]/stories/new              → Create story IN this book (with template prompts)
/books/[id]/stories/[sid]            → View story in book context
/books/[id]/stories/[sid]/edit       → Edit story (uses EnhancedEditorShell)
/books/[id]/record                   → Voice recording hub for this book
/books/[id]/conversations            → AI conversation hub for this book
/books/[id]/design                   → Design customization
/books/[id]/preview                  → Preview book
/books/[id]/publish                  → Publishing flow
/books/[id]/settings                 → Book settings
/books/[id]/share                    → Sharing & permissions

# Stories (for browsing/search across all books)
/stories                             → Browse all user's stories across books
/stories/[id]                        → Redirect to /books/[book_id]/stories/[id]

-- Add storyteller fields (from campaigns)
ALTER TABLE books ADD COLUMN storyteller_name VARCHAR(255);
ALTER TABLE books ADD COLUMN storyteller_relationship VARCHAR(100);
-- Values: 'self', 'parent', 'grandparent', 'spouse', 'child', 'sibling', 'friend', 'other'
ALTER TABLE books ADD COLUMN storyteller_user_id UUID REFERENCES auth.users(id);
ALTER TABLE books ADD COLUMN storyteller_email VARCHAR(255);
ALTER TABLE books ADD COLUMN storyteller_phone VARCHAR(50);
ALTER TABLE books ADD COLUMN storyteller_notes TEXT;
 
-- Add gift fields (from campaigns)
ALTER TABLE books ADD COLUMN is_gift BOOLEAN DEFAULT FALSE;
ALTER TABLE books ADD COLUMN gift_message TEXT;
ALTER TABLE books ADD COLUMN gift_recipient_name VARCHAR(255);
ALTER TABLE books ADD COLUMN gift_recipient_email VARCHAR(255);
ALTER TABLE books ADD COLUMN gift_status VARCHAR(50) DEFAULT 'pending';
-- Values: 'pending', 'sent', 'delivered', 'accepted', 'declined'
ALTER TABLE books ADD COLUMN gift_delivery_date TIMESTAMP;
 
-- Add project management fields
ALTER TABLE books ADD COLUMN project_status VARCHAR(50) DEFAULT 'setup';
-- Values: 'setup', 'collecting', 'editing', 'designing', 'ready', 'published'
ALTER TABLE books ADD COLUMN setup_step VARCHAR(50) DEFAULT 'template';
ALTER TABLE books ADD COLUMN setup_progress JSONB DEFAULT '{}';
ALTER TABLE books ADD COLUMN goal_stories INTEGER DEFAULT 10;
ALTER TABLE books ADD COLUMN completed_stories INTEGER DEFAULT 0;
 
-- Add notification settings
ALTER TABLE books ADD COLUMN prompt_frequency VARCHAR(50) DEFAULT 'weekly';
-- Values: 'daily', 'weekly', 'biweekly', 'monthly', 'manual'
ALTER TABLE books ADD COLUMN notification_settings JSONB DEFAULT '{
  "email_enabled": true,
  "sms_enabled": false,
  "push_enabled": false,
  "reminder_day": "sunday",
  "reminder_time": "10:00"
}';
 
-- Add creator relationship
ALTER TABLE books ADD COLUMN creator_relationship VARCHAR(100);
-- Values: 'self', 'family_member', 'gift_giver', 'collaborator'

-- Add book_id column (will replace campaign_id)
ALTER TABLE stories ADD COLUMN book_id UUID REFERENCES books(id);
 
-- Create index for performance
CREATE INDEX idx_stories_book_id ON stories(book_id);
 
-- Update check constraint to require one of book_id or campaign_id (transition)
-- Eventually remove campaign_id requirement

-- Books: Users can see their own books or family-shared books
CREATE POLICY "Users can view own and family books"
ON books FOR SELECT
USING (
  user_id = auth.uid()
  OR family_group_id IN (
    SELECT family_group_id FROM family_members WHERE user_id = auth.uid()
  )
);
 
-- Stories: Users can see stories in books they can access
CREATE POLICY "Users can view stories in accessible books"
ON stories FOR SELECT
USING (
  user_id = auth.uid()
  OR book_id IN (
    SELECT id FROM books WHERE
      user_id = auth.uid()
      OR family_group_id IN (
        SELECT family_group_id FROM family_members WHERE user_id = auth.uid()
      )
  )
);
 
-- Family members can edit based on permissions
CREATE POLICY "Family members can edit with permission"
ON stories FOR UPDATE
USING (
  user_id = auth.uid()
  OR book_id IN (
    SELECT book_id FROM family_book_permissions
    WHERE family_group_id IN (
      SELECT family_group_id FROM family_members WHERE user_id = auth.uid()
    )
    AND auth.uid() = ANY(can_edit_members)
  )
);

/books/[id]/stories              → Stories list (chapters)
/books/[id]/stories/new          → Create story with template prompts
/books/[id]/stories/[sid]        → View story in book context
/books/[id]/stories/[sid]/edit   → Edit story (uses EnhancedEditorShell)
/books/[id]/record               → Voice recording hub (book-scoped for RAG)
/books/[id]/conversations        → AI conversation hub (book-scoped for RAG)
/books/[id]/import               → Import content
/books/[id]/settings             → Project settings
/books/[id]/share                → Sharing & family permissions

Step 1: Choose Your Path
  - "I'm writing my own story" (self)
  - "I'm capturing someone else's story" (family member)
  - "I'm giving this as a gift" (gift)

Step 2: About the Storyteller (if not self)
  - Name
  - Relationship to you
  - Contact info (optional)

Step 3: Choose a Template
  - Template gallery
  - Template preview
  - Chapter/prompt preview

Step 4: Book Details
  - Title
  - Description
  - Cover style preference

Step 5: Set Your Goals
  - Number of stories
  - Target completion date

Step 6: Reminders (optional)
  - Frequency
  - Method (email/SMS)

Step 7: Review & Start
  - Summary
  - Start collecting stories button

1. Owner creates book → Assigned to family_group_id (optional)

2. Owner shares with family:
   - Click "Share" button
   - Select family members
   - Choose permission level (viewer/contributor/editor)
   - Send invitation

3. Family member receives:
   - Email notification
   - In-app notification
   - Book appears in their "Shared with Me" section

4. Family member can:
   - View book and stories
   - Add their own stories (if contributor+)
   - Edit any story (if editor)
   - See real-time updates

-- Family book permissions already exist
-- family_book_permissions.can_edit_members[]
-- family_book_permissions.can_contribute_members[]
-- family_book_permissions.can_comment_members[]
 
-- Add visibility levels
ALTER TABLE family_book_permissions
ADD CONSTRAINT check_visibility
CHECK (visibility IN ('private', 'family', 'public'));

┌──────────────────────────────────────────────────────────────┐
│                     Welcome Screen                            │
│                                                               │
│  "Ready to preserve your story?"                              │
│                                                               │
│  [Start My First Book]                                        │
│                                                               │
└──────────────────────────────────────────────────────────────┘
                            │
                            ▼
┌──────────────────────────────────────────────────────────────┐
│                   Who is this book for?                       │
│                                                               │
│  ┌─────────────────┐  ┌─────────────────┐  ┌──────────────┐  │
│  │    Myself       │  │  A Family       │  │   A Gift     │  │
│  │                 │  │  Member         │  │              │  │
│  │  "I want to     │  │  "I want to     │  │  "I want to  │  │
│  │   write my      │  │   capture my    │  │   give the   │  │
│  │   own story"    │  │   parent's or   │  │   gift of    │  │
│  │                 │  │   grandparent's │  │   memories"  │  │
│  │                 │  │   memories"     │  │              │  │
│  └─────────────────┘  └─────────────────┘  └──────────────┘  │
│                                                               │
└──────────────────────────────────────────────────────────────┘
                            │
                            ▼
┌──────────────────────────────────────────────────────────────┐
│               Choose Your Template                            │
│                                                               │
│  Templates provide structure and prompts to guide your        │
│  storytelling. Choose one that fits your book's purpose.      │
│                                                               │
│  ┌─────────┐  ┌─────────┐  ┌─────────┐  ┌─────────┐          │
│  │ Life    │  │ Family  │  │ War &   │  │ Custom  │          │
│  │ Story   │  │ History │  │ Service │  │         │          │
│  └─────────┘  └─────────┘  └─────────┘  └─────────┘          │
│                                                               │
│  Selected: Life Story Memoir                                  │
│  - 12 chapters covering childhood to present                  │
│  - 50+ guided prompts                                         │
│  - Photo integration                                          │
│                                                               │
└──────────────────────────────────────────────────────────────┘
                            │
                            ▼
┌──────────────────────────────────────────────────────────────┐
│                  Give Your Book a Title                       │
│                                                               │
│  ┌──────────────────────────────────────────┐                │
│  │ Mom's Life Story                          │                │
│  └──────────────────────────────────────────┘                │
│                                                               │
│  You can always change this later.                            │
│                                                               │
│  [Continue]                                                   │
│                                                               │
└──────────────────────────────────────────────────────────────┘
                            │
                            ▼
┌──────────────────────────────────────────────────────────────┐
│                    You're All Set!                            │
│                                                               │
│  Your book "Mom's Life Story" is ready.                       │
│                                                               │
│  What would you like to do first?                             │
│                                                               │
│  ┌─────────────────────────┐  ┌─────────────────────────┐    │
│  │  📝 Write a Story       │  │  🎙️ Record a Story      │    │
│  │                         │  │                         │    │
│  │  Use our guided         │  │  Speak your memories    │    │
│  │  prompts to write       │  │  and we'll transcribe   │    │
│  └─────────────────────────┘  └─────────────────────────┘    │
│                                                               │
│  ┌─────────────────────────┐  ┌─────────────────────────┐    │
│  │  📚 View Prompts        │  │  ⚙️ Book Settings       │    │
│  │                         │  │                         │    │
│  │  See all the            │  │  Customize your         │    │
│  │  template prompts       │  │  book settings          │    │
│  └─────────────────────────┘  └─────────────────────────┘    │
│                                                               │
└──────────────────────────────────────────────────────────────┘

Template: "Life Story Memoir"
Chapter: "Early Childhood"

Suggested Prompts:
1. "What is your earliest memory?"
2. "Where did you grow up? Describe your childhood home."
3. "Who were the most important people in your early life?"
4. "What games did you play as a child?"
5. "What was your neighborhood like?"

[Choose a prompt] or [Write freely]

1. Creates account
2. Starts first book: "I'm writing my own story"
3. Chooses "Life Story Memoir" template
4. Titles it "My Journey"
5. Sees template prompts organized by life stage
6. Writes first story: "My Childhood Home"
7. Story automatically becomes Chapter 1
8. Continues adding stories over weeks
9. When ready, designs cover and publishes

1. Creates account
2. Starts first book: "I'm capturing someone else's story"
3. Enters mom's info: "Helen", relationship: "parent"
4. Chooses "Family History" template
5. Invites mom to view/contribute (optional)
6. Records voice interviews with mom
7. Transcriptions become stories/chapters
8. Mike edits and organizes
9. Shares with siblings for contributions
10. Publishes as family keepsake

1. Creates account
2. Starts first book: "I'm giving this as a gift"
3. Enters dad's info as recipient
4. Chooses "Life Story" template
5. Optionally pre-seeds with a few prompts/stories
6. Adds gift message
7. Purchases at checkout
8. Dad receives gift, creates account
9. Ownership transfers to dad
10. Dad continues adding stories
11. Lisa becomes a "contributor" if dad allows

1. Grandma starts book: "Johnson Family History"
2. Shares with children and grandchildren
3. Each family member:
   - Adds their own stories
   - Comments on others' stories
   - Uploads photos
4. Grandma (owner) organizes chapters
5. Family votes on cover design
6. Published as family heirloom

1. John has 5 stories written
2. Goes to Book Settings
3. Clicks "Change Template"
4. Sees warning: "Your existing stories will be preserved"
5. Selects "Life Story Memoir"
6. System suggests: "These existing stories might fit these chapters..."
7. John confirms mapping
8. New prompts become available
9. Existing content preserved, just reorganized

// Book CRUD (enhanced)
POST   /api/books                    // Create book with all new fields
GET    /api/books                    // List user's books + family shared
GET    /api/books/:id                // Get book with storyteller info
PATCH  /api/books/:id                // Update book
DELETE /api/books/:id                // Delete book
 
// Stories now under books
POST   /api/books/:id/stories        // Create story for book
GET    /api/books/:id/stories        // List book's stories
GET    /api/books/:id/stories/:sid   // Get story
PATCH  /api/books/:id/stories/:sid   // Update story
DELETE /api/books/:id/stories/:sid   // Delete story
 
// Template prompts
GET    /api/books/:id/prompts        // Get template prompts for book
GET    /api/books/:id/prompts/:pid   // Get specific prompt
 
// Family sharing
POST   /api/books/:id/share          // Share book with family
GET    /api/books/:id/permissions    // Get sharing permissions
PATCH  /api/books/:id/permissions    // Update permissions
 
// Gift flow
POST   /api/books/:id/gift/send      // Send gift
POST   /api/books/:id/gift/accept    // Accept gift
GET    /api/gifts/received           // List received gifts
 
// Voice recording (moved)
POST   /api/books/:id/recordings     // Upload recording
GET    /api/books/:id/recordings     // List recordings
 
// Story duplication (NEW)
POST   /api/stories/:id/duplicate    // Duplicate story to another book
  // Body: { target_book_id: string }
  // Creates a copy with new ID, linked to target book

// Enhanced Book type
interface Book {
  id: string;
  user_id: string;
 
  // Basic info
  title: string;
  subtitle?: string;
  description?: string;
 
  // Storyteller info (NEW)
  storyteller_name?: string;
  storyteller_relationship?: 'self' | 'parent' | 'grandparent' |
                             'spouse' | 'child' | 'sibling' |
                             'friend' | 'other';
  storyteller_user_id?: string;
  storyteller_email?: string;
  storyteller_phone?: string;
  storyteller_notes?: string;
 
  // Creator info (NEW)
  creator_relationship: 'self' | 'family_member' | 'gift_giver' | 'collaborator';
 
  // Template & Content
  template_id?: string;
  story_ids: string[];
  goal_stories: number;
  completed_stories: number;
 
  // Project status (NEW)
  project_status: 'setup' | 'collecting' | 'editing' |
                  'designing' | 'ready' | 'published';
  setup_step?: string;
  setup_progress?: Record<string, any>;
 
  // Notifications (NEW)
  prompt_frequency: 'daily' | 'weekly' | 'biweekly' | 'monthly' | 'manual';
  notification_settings?: {
    email_enabled: boolean;
    sms_enabled: boolean;
    push_enabled: boolean;
    reminder_day?: string;
    reminder_time?: string;
  };
 
  // Gift (NEW)
  is_gift: boolean;
  gift_message?: string;
  gift_recipient_name?: string;
  gift_recipient_email?: string;
  gift_status?: 'pending' | 'sent' | 'delivered' | 'accepted' | 'declined';
  gift_delivery_date?: string;
 
  // Family
  family_group_id?: string;
 
  // Publishing
  author_name: string;
  contributor_names: string[];
  // ... existing publishing fields
 
  created_at: string;
  updated_at: string;
}
 
// Updated Story type
interface Story {
  id: string;
  book_id: string;  // NEW - replaces campaign_id
  user_id: string;
 
  title: string;
  content: string;
  prompt?: string;  // Which template prompt was used
 
  // Derived from books.story_ids index
  chapter_number?: number;
 
  word_count: number;
  status: 'draft' | 'reviewed' | 'approved' | 'published';
 
  // ... existing fields
}

User selects "Life Story Memoir" template
                    ↓
System creates book with:
  - title: "[Storyteller's Name]'s Life Story"
  - template_id: "life-story-memoir"
  - story_ids: [] (initially empty)
                    ↓
System creates placeholder stories:
  - "Early Childhood" (placeholder, status: 'placeholder')
  - "Growing Up" (placeholder)
  - "School Years" (placeholder)
  - "First Job" (placeholder)
  - ... (based on template chapters)
                    ↓
User sees book with placeholder chapters
Can click any to start writing/recording

interface Story {
  // ... existing fields
 
  // NEW: Placeholder support
  is_placeholder: boolean;        // True for auto-created placeholders
  placeholder_prompt?: string;    // The template prompt for this placeholder
  template_chapter_index?: number; // Position in template
}

-- Add placeholder fields to stories
ALTER TABLE stories ADD COLUMN is_placeholder BOOLEAN DEFAULT FALSE;
ALTER TABLE stories ADD COLUMN placeholder_prompt TEXT;
ALTER TABLE stories ADD COLUMN template_chapter_index INTEGER;

User viewing Story A in Book X
         ↓
Clicks "Duplicate to another book"
         ↓
Modal shows list of user's other books
         ↓
User selects Book Y
         ↓
System creates Story A' in Book Y:
  - New UUID
  - Same title (with " (Copy)" suffix, optional)
  - Same content
  - Links to Book Y
  - user_id = current user
  - is_duplicate = true
  - source_story_id = Story A's ID
         ↓
User can now edit Story A' independently

// POST /api/stories/:id/duplicate
interface DuplicateStoryRequest {
  target_book_id: string;
  include_copy_suffix?: boolean;  // Default: true
  copy_images?: boolean;          // Default: true
}
 
interface DuplicateStoryResponse {
  success: boolean;
  new_story: Story;
  message: string;
}

-- Track story duplications
ALTER TABLE stories ADD COLUMN is_duplicate BOOLEAN DEFAULT FALSE;
ALTER TABLE stories ADD COLUMN source_story_id UUID REFERENCES stories(id);
 
-- Index for finding duplicates
CREATE INDEX idx_stories_source ON stories(source_story_id) WHERE source_story_id IS NOT NULL;

-- Step 1: Add new columns to books
-- (SQL from section 3.1)
 
-- Step 2: Copy data from campaigns to books
INSERT INTO books (
  id, user_id, title, description,
  storyteller_name, storyteller_relationship, storyteller_user_id,
  storyteller_email, storyteller_phone, storyteller_notes,
  template_id, goal_stories,
  is_gift, gift_message, gift_recipient_name, gift_recipient_email,
  gift_status, gift_delivery_date,
  project_status, setup_step, setup_progress,
  prompt_frequency, notification_settings,
  family_group_id
)
SELECT
  gen_random_uuid(), creator_id, title, description,
  storyteller_name, user_role, storyteller_user_id,
  storyteller_email, storyteller_phone, storyteller_notes,
  template_id, goal_stories,
  is_gift, gift_message, gift_recipient_name, gift_recipient_email,
  gift_status, gift_delivery_date,
  status, setup_step, setup_progress,
  prompt_frequency, '{"email_enabled": true}'::jsonb,
  family_group_id
FROM campaigns;
 
-- Step 3: Update stories to reference new books
UPDATE stories s
SET book_id = (
  SELECT b.id FROM books b
  JOIN campaigns c ON b.title = c.title AND b.user_id = c.creator_id
  WHERE c.id = s.campaign_id
)
WHERE s.campaign_id IS NOT NULL;
 
-- Step 4: Drop campaign_id from stories
ALTER TABLE stories DROP COLUMN campaign_id;
 
-- Step 5: Drop campaigns table
DROP TABLE campaigns CASCADE;

┌─────────────────────────────────────────────────────────────┐
│                    Book: "Mom's Life Story"                  │
│                                                             │
│  ┌─────────────────┐  ┌─────────────────┐                  │
│  │ Stories         │  │ Recordings      │                  │
│  │ - Childhood     │  │ - Interview 1   │                  │
│  │ - School Years  │  │ - Interview 2   │                  │
│  │ - First Job     │  │ - Photo Review  │                  │
│  └────────┬────────┘  └────────┬────────┘                  │
│           │                    │                            │
│           └────────┬───────────┘                            │
│                    ▼                                        │
│           ┌─────────────────┐                               │
│           │ RAG Vector DB   │ ← Context for AI              │
│           │ (Book-scoped)   │                               │
│           └────────┬────────┘                               │
│                    │                                        │
│                    ▼                                        │
│           ┌─────────────────┐                               │
│           │ AI Conversation │                               │
│           │                 │                               │
│           │ "What else do   │                               │
│           │  you remember   │ ← AI knows this is about      │
│           │  about your     │   Mom, childhood, her school  │
│           │  school days?"  │                               │
│           └─────────────────┘                               │
└─────────────────────────────────────────────────────────────┘