== Writer Publishes a Story === Actor: **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 story_id, short_description, status FROM STORY WHERE user_id = 2 AND 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 STORY 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 (notification_content, content_type, is_read, user_id, story_id, notification_created_at) VALUES ('Elena published a new story "The Chronicles of Eldoria"', 'new_story', FALSE, 5, 1, CURRENT_TIMESTAMP); }}} **6.** The system confirms the story is now publicly visible on the platform.