User Removes a Story from a Reading List

Actor: Regular User / Writer

A user removes a story from one of their reading lists.

1. The user navigates to their reading list page.

2. The system displays all stories in the selected reading list.

SELECT rli.story_id, s.short_description, rli.added_at
FROM READING_LIST_ITEMS rli
JOIN STORY s ON rli.story_id = s.story_id
WHERE rli.list_id = 1
ORDER BY rli.added_at DESC;

3. The user selects a story and clicks "Remove from List".

4. The system deletes the story from the reading list.

DELETE FROM READING_LIST_ITEMS
WHERE list_id = 1 AND story_id = 1;

5. The system confirms removal and refreshes the reading list view.