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.

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.

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.

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.