Changes between Version 8 and Version 9 of P2

Timestamp:

02/13/26 15:41:23 (5 weeks ago)

Author:

211099

Comment:

--

P2

@@ -10 +10 @@
 == Tables ==
 
-1. **USER** (**__{{{user_ID}}}__**, {{{username}}}, {{{email}}}, {{{name}}}, {{{surname}}}, {{{password}}})
+1. **USER** (**__{{{user_ID}}}__**, {{{username}}}, {{{email}}}, {{{name}}}, {{{surname}}}, {{{password}}}, {{{created_at}}}, {{{updated_at}}})
 
 2. **ADMIN** (**__{{{user_ID*}}}__** (USER))
@@ -18 +18 @@
 4. **WRITER** (**__{{{user_ID*}}}__** (USER), {{{created_story}}})
 
-5. **STORY** (**__{{{story_ID}}}__**, {{{mature_content}}}, {{{short_description}}}, {{{image}}}, {{{content}}}, **__{{{user_ID*}}}__** (WRITER))
+5. **STORY** (**__{{{story_ID}}}__**, {{{mature_content}}}, {{{short_description}}}, {{{image}}}, {{{content}}}, **__{{{user_ID*}}}__** (WRITER), {{{created_at}}}, {{{updated_at}}})
    * status (multi-valued attribute, see table **STATUS**)
 
 6. **STATUS** (**__{{{story_ID*}}}__** (STORY), **__{{{status}}}__**)
 
-7. **CHAPTER** (**__{{{chapter_ID}}}__**, {{{chapter_name}}}, {{{title}}}, {{{content}}}, {{{word_count}}}, {{{rating}}}, {{{published_at}}}, {{{view_count}}}, **__{{{story_ID*}}}__** (STORY))
+7. **CHAPTER** (**__{{{chapter_ID}}}__**, {{{chapter_number}}}, {{{chapter_name}}}, {{{title}}}, {{{content}}}, {{{word_count}}}, {{{rating}}}, {{{published_at}}}, {{{view_count}}}, **__{{{story_ID*}}}__** (STORY), {{{created_at}}}, {{{updated_at}}})
 
 8. **GENRE** (**__{{{genre_ID}}}__**, {{{name}}})
 
-9. **READING_LIST** (**__{{{list_ID}}}__**, {{{name}}}, {{{content}}}, {{{is_public}}}, **__{{{user_ID*}}}__** (USER))
+9. **READING_LIST** (**__{{{list_ID}}}__**, {{{name}}}, {{{content}}}, {{{is_public}}}, **__{{{user_ID*}}}__** (USER), {{{created_at}}}, {{{updated_at}}})
 
-10. **NOTIFICATION** (**__{{{notification_ID}}}__**, {{{content}}}, **__{{{user_ID*}}}__** (USER))
+10. **NOTIFICATION** (**__{{{notification_ID}}}__**, {{{content}}}, {{{is_read}}}, **__{{{user_ID*}}}__** (USER), {{{created_at}}})
     * content_type (multi-valued attribute, see table **CONTENT_TYPE**)
 
 11. **CONTENT_TYPE** (**__{{{notification_ID*}}}__** (NOTIFICATION), **__{{{content_type}}}__**)
 
-12. **AI_SUGGESTION** (**__{{{suggestion_ID}}}__**, {{{original_text}}}, {{{suggested_text}}}, {{{accepted}}}, **__{{{story_ID*}}}__** (STORY))
+12. **AI_SUGGESTION** (**__{{{suggestion_ID}}}__**, {{{original_text}}}, {{{suggested_text}}}, {{{accepted}}}, **__{{{story_ID*}}}__** (STORY), {{{created_at}}}, {{{applied_at}}})
     * suggestion_type (multi-valued attribute, see table **SUGGESTION_TYPE**)
 
 13. **SUGGESTION_TYPE** (**__{{{suggestion_ID*}}}__** (AI_SUGGESTION), **__{{{suggestion_type}}}__**)
 
-14. **LIKE** (**__{{{user_ID*}}}__** (USER), **__{{{story_ID*}}}__** (STORY))
+14. **LIKE** (**__{{{user_ID*}}}__** (USER), **__{{{story_ID*}}}__** (STORY), {{{created_at}}})
 
-15. **COMMENT** (**__{{{comment_ID}}}__**, {{{content}}}, **__{{{user_ID*}}}__** (USER), **__{{{story_ID*}}}__** (STORY))
+15. **COMMENT** (**__{{{comment_ID}}}__**, {{{content}}}, **__{{{user_ID*}}}__** (USER), **__{{{story_ID*}}}__** (STORY), {{{created_at}}}, {{{updated_at}}})
 
-16. **COLLABORATION** (**__{{{user_ID*}}}__** (USER), **__{{{story_ID*}}}__** (STORY), {{{role}}}, {{{permission_level}}})
+16. **COLLABORATION** (**__{{{user_ID*}}}__** (USER), **__{{{story_ID*}}}__** (STORY), {{{created_at}}})
     * role (multi-valued attribute, see table **ROLE**)
     * permission_level (multi-valued attribute, see table **PERMISSION_LEVEL**)
@@ -52 +52 @@
 
 19. **HAS_GENRE** (**__{{{story_ID*}}}__** (STORY), **__{{{genre_ID*}}}__** (GENRE))
+
+20. **READING_LIST_ITEMS** (**__{{{list_ID*}}}__** (READING_LIST), **__{{{story_ID*}}}__** (STORY), {{{added_at}}})
 
 === DDL script for creation and deletion of tables ===