Writer Edits an Existing Chapter

Actor: Writer

A writer edits the content of an already published chapter, for example to apply corrections or improvements.

1. The writer navigates to their story and selects a chapter to edit.

2. The system retrieves the current chapter content.

SELECT chapter_id, chapter_number, chapter_name, title, 
       content, word_count, updated_at
FROM CHAPTER
WHERE chapter_id = 1 AND story_id = 1;

3. The writer modifies the chapter content and submits the changes.

4. The system updates the chapter record with the new content and recalculates the word count.

UPDATE CHAPTER
SET content = 'The ground trembled beneath the Crystal Mountains. Updated content here...',
    word_count = 3500,
    updated_at = CURRENT_TIMESTAMP
WHERE chapter_id = 1 AND story_id = 1;

5. The system checks if there are any pending AI suggestions for this chapter that may now be outdated.

SELECT ai.suggestion_id, ai.original_text, ai.suggested_text
FROM AI_SUGGESTION ai
JOIN NEED_APPROVAL na ON ai.suggestion_id = na.suggestion_id
WHERE na.chapter_id = 1 AND ai.accepted = FALSE;

6. The system notifies the writer of any pending unreviewed suggestions that may be affected by the edit.

7. The system confirms the chapter was updated successfully and displays the updated version.