Changes between Initial Version and Version 1 of WriterArchivesAStory

Timestamp:

03/05/26 15:44:13 (2 weeks ago)

Author:

211099

Comment:

--

WriterArchivesAStory

@@ +1 @@
+==  Writer Archives a Story
+
+=== Actor: **Writer**
+A writer decides to archive a published story, making it no longer visible to regular users and guests but keeping it in the system.
+
+**1.** The writer navigates to their story management dashboard.
+
+**2.** The system displays all stories with their current statuses.
+{{{#!sql
+SELECT s.story_id, s.short_description, st.status,
+       COUNT(DISTINCT c.chapter_id) AS total_chapters,
+       COUNT(DISTINCT l.user_id) AS total_likes
+FROM STORY s
+JOIN STATUS st ON s.story_id = st.story_id
+LEFT JOIN CHAPTER c ON s.story_id = c.story_id
+LEFT JOIN LIKES l ON s.story_id = l.story_id
+WHERE s.user_id = 2
+GROUP BY s.story_id, st.status;
+}}}
+
+**3.** The writer selects a published story and chooses the "Archive" option.
+
+**4.**The system updates the story status from published to archived.
+{{{#!sql
+UPDATE STATUS
+SET status = 'archived'
+WHERE story_id = 1 AND status = 'published';
+}}}
+
+**5.** The system verifies the story no longer appears in public browsing queries.
+{{{#!sql
+SELECT s.story_id, s.short_description, st.status
+FROM STORY s
+JOIN STATUS st ON s.story_id = st.story_id
+WHERE st.status = 'published' AND s.story_id = 1;
+}}}
+
+**6.** The system sends a notification to users who had the story in their reading lists informing them it is no longer available.
+{{{#!sql
+INSERT INTO NOTIFICATION (content, is_read, created_at)
+VALUES ('"The Chronicles of Eldoria" has been archived by the author and is no longer available.', FALSE, CURRENT_TIMESTAMP);
+}}}
+
+**7.** The system confirms the story is archived and updates the writer's dashboard.