==  User Reads a Chapter

=== Actor: **Guest User / Regular User / Writer**
A user opens and reads a specific chapter of a story, and the system records the view count for that chapter.
**1.** The user selects a chapter from the story page.

**2.** The system retrieves the full chapter content.
{{{#!sql
SELECT chapter_id, chapter_number, chapter_name, title, 
       content, word_count, rating, published_at, view_count
FROM CHAPTER
WHERE chapter_id = 1 AND story_id = 1;
}}}

**3.** The system increments the view count for that chapter.
{{{#!sql
UPDATE CHAPTER
SET view_count = view_count + 1,
    updated_at = CURRENT_TIMESTAMP
WHERE chapter_id = 1;
}}}

**4.** The system displays navigation buttons to the previous and next chapters.
{{{#!sql
SELECT chapter_id, chapter_number, title
FROM CHAPTER
WHERE story_id = 1
AND chapter_number IN (
    (SELECT chapter_number - 1 FROM CHAPTER WHERE chapter_id = 1),
    (SELECT chapter_number + 1 FROM CHAPTER WHERE chapter_id = 1)
)
ORDER BY chapter_number ASC;
}}}

**5.**The user finishes reading and navigates to the next chapter.