User Adds a Story to a Reading List

Actor: Regular User / Writer

A user adds a published story to one of their existing reading lists for later reading.

1. The user opens a published story they want to save.

2. The user clicks "Add to Reading List".

3. The system retrieves all reading lists belonging to the user.

SELECT list_id, name, is_public
FROM READING_LIST
WHERE user_id = 4;

4. The system displays the user's reading lists as options.

5. The user selects which reading list to add the story to.

6. The system checks if the story is already in the selected reading list.

SELECT * FROM READING_LIST_ITEMS
WHERE list_id = 1 AND story_id = 1;

7. The system inserts the story into the selected reading list.

INSERT INTO READING_LIST_ITEMS (list_id, story_id, added_at)
VALUES (1, 1, CURRENT_TIMESTAMP);

8. The system confirms the story was added and updates the reading list count.