Changes between Version 1 and Version 2 of UserReadsAChapter


Ignore:
Timestamp:
08/24/26 16:17:14 (13 days ago)
Author:
211099
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • UserReadsAChapter

    v1 v2  
    33=== Actor: **Guest User / Regular User / Writer**
    44A user opens and reads a specific chapter of a story, and the system records the view count for that chapter.
     5
    56**1.** The user selects a chapter from the story page.
    67
    … …  
    89{{{#!sql
    910SELECT chapter_id, chapter_number, chapter_name, title,
    10        content, word_count, rating, published_at, view_count
     11       chapter_content, word_count, rating, published_at, view_count
    1112FROM CHAPTER
    1213WHERE chapter_id = 1 AND story_id = 1;
    … …  
    1718UPDATE CHAPTER
    1819SET view_count = view_count + 1,
    19     updated_at = CURRENT_TIMESTAMP
     20    chapter_updated_at = CURRENT_TIMESTAMP
    2021WHERE chapter_id = 1;
    2122}}}