== Application Design – Use Cases and Database Access Scenarios – SQL Views

== Actors

**Admin**
   
  * Can moderate content for appropriateness
  * Has a read-write permisions to the whole system
  * Can add or remove existing users
  * Can view platform analytics and user activity
  * Can manage and resolve reported content

**Writer**

   * Has a read-write permissions to own content
   * Can add new stories and chapters, edit own stories and chapters
   * Has own reading list
   * Can collaborate with other writers through a permission-based system
   * Can view analytics on their stories 
   * Can receive and accept/reject AI-generated writing suggestions
   * Can set stories as draft, published, or archived
   * Can manage mature content settings on their stories


**Regular User**

   * Has a read-only permision of all stories and chapters
   * Can leave comments and likes to the stories
   * Can add stories to their reading list
   * Can report inappropriate stories or comments

**Guest User (Unauthenticated User)**

   * Has a read-only permision of all public stories and chapters
   * Browse by categories or other filters
   * Cannot manage data in the system before registration or login 

== Scenarios

[wiki:RegularUserRegistration Regular User Registration]
[[BR]]
[wiki:ExistingAdmin Existing Admin]
[[BR]]
[wiki:WrittersCollaboration Writters Collaboration]
[[BR]]
[wiki:RegularUserLikesStory Regular User Likes Story]
[[BR]]
[wiki:RegularUserCommentsOnStory Regular User Comments On Story]
[[BR]]
[wiki:UserCreatesReadingList User Creates Reading List]
[[BR]]
[wiki:UserRemovesStoryFromReadingList User Removes Story From Reading List]
[[BR]]
[wiki:WriterViewsStoryCollaborationDetails Writer Views Story Collaboration Details]
[[BR]]
[wiki:UserViewsPublicReadingLists User Views Public Reading Lists]
[[BR]]
[wiki:UserBrowsesStoriesByGenre User Browses Stories By Genre]
[[BR]]
[wiki:UserViewsStoryDetailsAndChapters User Views Story Details And Chapters]
[[BR]]
[wiki:UserReadsAChapter User Reads a Chapter]
[[BR]]
[wiki:WriterEditsAnExistingChapter Writer Edits an Existing Chapter]
[[BR]]
[wiki:WriterArchivesAStory Writer Archives a Story]
[[BR]]
[wiki:AdminRemovesAStory Admin Removes a Story]

== Most Important Scenarios
[wiki:WriterRegistration Writer Registration]
[[BR]]
[wiki:WriterCreatesStory Writer Creates Story]
[[BR]]
[wiki:WriterPublishesStory Writer Publishes Story]
[[BR]]
[wiki:WriterAddsChapterToStory Writer Adds Chapter To Story]
[[BR]]
[wiki:WriterReceivesAISuggestions Writer Receives AI Suggestions]
[[BR]]
[wiki:UserAddsStoryToReadingList User Adds Story To ReadingList]
[[BR]]
[wiki:AdminManagesGenres Admin Manages Genres]