Changes between Version 1 and Version 2 of UserViewsStoryDetailsAndChapters

Timestamp:

08/24/26 16:16:17 (13 days ago)

Author:

211099

Comment:

--

UserViewsStoryDetailsAndChapters

@@ -2 +2 @@
 
 === Actor: **Guest User / Regular User / Writer**
- A user opens a published story to view its full details, genres, and list of available chapters before starting to read.
 
+A user opens a published story to view its full details, genres, and list of available chapters before starting to read.
 **1.** The user clicks on a story from the browse page or reading list.
 
 **2.** The system retrieves the full story details.
 {{{#!sql
-SELECT s.story_id, s.short_description, s.content, s.mature_content, 
-       s.image, s.created_at, u.username AS author,
-       st.status
+SELECT s.story_id, s.short_description, s.story_content, s.mature_content, 
+       s.image, s.story_created_at, u.username AS author,
+       s.status
 FROM STORY s
 JOIN USERS u ON s.user_id = u.user_id
-JOIN STATUS st ON s.story_id = st.story_id
-WHERE s.story_id = 1 AND st.status = 'published';
+WHERE s.story_id = 1 AND s.status = 'published';
 }}}
 
 **3.** The system retrieves all genres assigned to the story.
 {{{#!sql
-SELECT g.name
+SELECT g.genre_name
 FROM GENRE g
 JOIN HAS_GENRE hg ON g.genre_id = hg.genre_id