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.

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.

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.

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.