Changes between Version 2 and Version 3 of UserCreatesReadingList

Timestamp:

08/24/26 16:11:57 (13 days ago)

Author:

211099

Comment:

--

UserCreatesReadingList

@@ -2 +2 @@
 
 === Actor: **Regular User / Writer**
+
 A user creates a new personal reading list, choosing whether to make it public or private.
 
@@ -12 +13 @@
 **4.** The system inserts a new record into the READING_LIST table.
 {{{#!sql
-INSERT INTO READING_LIST (name, content, is_public, user_id, created_at, updated_at)
+INSERT INTO READING_LIST (list_name, list_content, is_public, user_id, list_created_at, list_updated_at)
 VALUES ('Sara''s Fantasy Favorites', 
         'My collection of the best fantasy stories with strong female leads', 
@@ -22 +23 @@
 **6.** The system displays the reading list with zero stories added yet.
 {{{#!sql
-SELECT rl.list_id, rl.name, rl.content, rl.is_public, COUNT(rli.story_id) AS total_stories
+SELECT rl.list_id, rl.list_name, rl.list_content, rl.is_public, COUNT(rli.story_id) AS total_stories
 FROM READING_LIST rl
 LEFT JOIN READING_LIST_ITEMS rli ON rl.list_id = rli.list_id