Changes between Version 2 and Version 3 of UserViewsPublicReadingLists


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

--

Legend:

Unmodified
Added
Removed
Modified

  • UserViewsPublicReadingLists

    v2 v3  
    22
    33=== Actor: **Regular User / Guest User**
     4
    45A user browses all public reading lists on the platform to discover new stories recommended by other readers.
    56
    … …  
    89**2.** The system retrieves all public reading lists along with their story counts.
    910{{{#!sql
    10 SELECT rl.list_id, rl.name, rl.content, u.username,
    11        COUNT(rli.story_id) AS total_stories, rl.created_at
     11SELECT rl.list_id, rl.list_name, rl.list_content, u.username,
     12       COUNT(rli.story_id) AS total_stories, rl.list_created_at
    1213FROM READING_LIST rl
    1314JOIN USERS u ON rl.user_id = u.user_id