Changes between Initial Version and Version 1 of WriterPublishesStory

Timestamp:

03/04/26 15:40:29 (3 weeks ago)

Author:

211099

Comment:

--

WriterPublishesStory

@@ +1 @@
+==  Writer Publishes a Story
+
+=== Authors: **Writter**
+A writer changes the status of a story from draft to published, making it visible to all users on the platform.
+
+**1.** The writer navigates to their story management page and selects a story with draft status.
+
+**2.**  The system displays the current story details and status.
+{{{#!sql
+SELECT s.story_id, s.short_description, st.status
+FROM STORY s
+JOIN STATUS st ON s.story_id = st.story_id
+WHERE s.user_id = 2 AND st.status = 'draft';
+}}}
+
+**3.** The writer selects the option to publish the story.
+
+**4.** The system updates the story status from draft to published.
+{{{#!sql
+UPDATE STATUS
+SET status = 'published'
+WHERE story_id = 1 AND status = 'draft';
+}}}
+
+**5.**  The system sends a notification to all users who follow the writer.
+
+{{{#!sql
+INSERT INTO NOTIFICATION (content, is_read, created_at)
+VALUES ('Elena published a new story "The Chronicles of Eldoria"', FALSE, CURRENT_TIMESTAMP);
+}}}
+
+**6.** The system confirms the story is now publicly visible on the platform.