Changes between Version 13 and Version 14 of P2

Timestamp:

02/20/26 14:53:02 (4 weeks ago)

Author:

211099

Comment:

--

P2

@@ -9 +9 @@
 
 == Tables ==
-
 1. **USER** (**__{{{user_ID}}}__**, {{{username}}}, {{{email}}}, {{{name}}}, {{{surname}}}, {{{password}}}, {{{created_at}}}, {{{updated_at}}})
 
@@ -16 +15 @@
 3. **REGULAR_USER** (**__{{{user_ID*}}}__** (USER))
 
-4. **WRITER** (**__{{{user_ID*}}}__** (USER), {{{created_story}}})
+4. **WRITER** (**__{{{user_ID*}}}__** (USER))
 
 5. **STORY** (**__{{{story_ID}}}__**, {{{mature_content}}}, {{{short_description}}}, {{{image}}}, {{{content}}}, **__{{{user_ID*}}}__** (WRITER), {{{created_at}}}, {{{updated_at}}})
@@ -29 +28 @@
 9. **READING_LIST** (**__{{{list_ID}}}__**, {{{name}}}, {{{content}}}, {{{is_public}}}, **__{{{user_ID*}}}__** (USER), {{{created_at}}}, {{{updated_at}}})
 
-10. **NOTIFICATION** (**__{{{notification_ID}}}__**, {{{content}}}, {{{is_read}}}, **__{{{user_ID*}}}__** (USER), {{{created_at}}})
+10. **NOTIFICATION** (**__{{{notification_ID}}}__**, {{{content}}}, {{{is_read}}}, {{{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), {{{created_at}}}, {{{applied_at}}})
+12. **AI_SUGGESTION** (**__{{{suggestion_ID}}}__**, {{{original_text}}}, {{{suggested_text}}}, {{{accepted}}}, {{{created_at}}}, {{{applied_at}}})
     * suggestion_type (multi-valued attribute, see table **SUGGESTION_TYPE**)
 
@@ -41 +40 @@
 14. **LIKE** (**__{{{user_ID*}}}__** (USER), **__{{{story_ID*}}}__** (STORY), {{{created_at}}})
 
-15. **COMMENT** (**__{{{comment_ID}}}__**, {{{content}}}, **__{{{user_ID*}}}__** (USER), **__{{{story_ID*}}}__** (STORY), {{{created_at}}}, {{{updated_at}}})
+15. **COMMENT** (**__{{{comment_ID}}}__**, {{{content}}}, **__{{{story_ID*}}}__** (STORY), {{{created_at}}}, {{{updated_at}}})
 
 16. **COLLABORATION** (**__{{{user_ID*}}}__** (USER), **__{{{story_ID*}}}__** (STORY), {{{created_at}}})
@@ -54 +53 @@
 
 20. **READING_LIST_ITEMS** (**__{{{list_ID*}}}__** (READING_LIST), **__{{{story_ID*}}}__** (STORY), {{{added_at}}})
+
+21. **NOTIFY** (**__{{{user_ID*}}}__** (USER), **__{{{story_ID*}}}__** (STORY), **__{{{notification_ID*}}}__** (NOTIFICATION))
+
+22. **NEED_APPROVAL** (**__{{{suggestion_ID*}}}__** (AI_SUGGESTION), **__{{{story_ID*}}}__** (STORY), **__{{{chapter_ID*}}}__** (CHAPTER))
 
 === DDL script for creation and deletion of tables ===