Changes between Version 16 and Version 17 of P2

Timestamp:

04/23/26 14:28:14 (9 days ago)

Author:

211099

Comment:

Renamed some attributes

P2

@@ -9 +9 @@
 
 == Tables ==
-1. **USER** (**__{{{user_ID}}}__**, {{{username}}}, {{{email}}}, {{{name}}}, {{{surname}}}, {{{password}}}, {{{created_at}}}, {{{updated_at}}})
+1. **USER** (**__{{{user_ID}}}__**, {{{username}}}, {{{email}}}, {{{user_name}}}, {{{surname}}}, {{{password}}}, {{{user_created_at}}}, {{{user_updated_at}}})
 
 2. **ADMIN** (**__{{{user_ID*}}}__** (USER))
@@ -17 +17 @@
 4. **WRITER** (**__{{{user_ID*}}}__** (USER))
 
-5. **STORY** (**__{{{story_ID}}}__**, {{{mature_content}}}, {{{short_description}}}, {{{image}}}, {{{content}}}, **__{{{user_ID*}}}__** (WRITER), {{{created_at}}}, {{{updated_at}}})
+5. **STORY** (**__{{{story_ID}}}__**, {{{mature_content}}}, {{{short_description}}}, {{{image}}}, {{{story_content}}}, **__{{{user_ID*}}}__** (WRITER), {{{story_created_at}}}, {{{story_updated_at}}})
    * status (multi-valued attribute, see table **STATUS**)
 
 6. **STATUS** (**__{{{story_ID*}}}__** (STORY), **__{{{status}}}__**)
 
-7. **CHAPTER** (**__{{{chapter_ID}}}__**, {{{chapter_number}}}, {{{chapter_name}}}, {{{title}}}, {{{content}}}, {{{word_count}}}, {{{rating}}}, {{{published_at}}}, {{{view_count}}}, **__{{{story_ID*}}}__** (STORY), {{{created_at}}}, {{{updated_at}}})
+7. **CHAPTER** (**__{{{chapter_ID}}}__**, {{{chapter_number}}}, {{{chapter_name}}}, {{{title}}}, {{{chapter_content}}}, {{{word_count}}}, {{{rating}}}, {{{published_at}}}, {{{view_count}}}, **__{{{story_ID*}}}__** (STORY), {{{chapter_created_at}}}, {{{chapter_updated_at}}})
 
 8. **GENRE** (**__{{{genre_ID}}}__**, {{{name}}})
 
-9. **READING_LIST** (**__{{{list_ID}}}__**, {{{name}}}, {{{content}}}, {{{is_public}}}, **__{{{user_ID*}}}__** (USER), {{{created_at}}}, {{{updated_at}}})
+9. **READING_LIST** (**__{{{list_ID}}}__**, {{{list_name}}}, {{{list_content}}}, {{{is_public}}}, **__{{{user_ID*}}}__** (USER), {{{list_created_at}}}, {{{list_updated_at}}})
 
-10. **NOTIFICATION** (**__{{{notification_ID}}}__**, {{{content}}}, {{{is_read}}}, {{{created_at}}})
+10. **NOTIFICATION** (**__{{{notification_ID}}}__**, {{{notification_content}}}, {{{is_read}}}, {{{notification_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}}}, {{{created_at}}}, {{{applied_at}}}, **__{{{story_ID*}}}__** (STORY))
+12. **AI_SUGGESTION** (**__{{{suggestion_ID}}}__**, {{{original_text}}}, {{{suggested_text}}}, {{{accepted}}}, {{{suggestion_created_at}}}, {{{applied_at}}}, **__{{{story_ID*}}}__** (STORY))
 
 13. **SUGGESTION_TYPE** (**__{{{suggestion_ID*}}}__** (AI_SUGGESTION), **__{{{suggestion_type}}}__**)
 
-14. **LIKE** (**__{{{user_ID*}}}__** (USER), **__{{{story_ID*}}}__** (STORY), {{{created_at}}})
+14. **LIKE** (**__{{{user_ID*}}}__** (USER), **__{{{story_ID*}}}__** (STORY), {{{like_created_at}}})
 
-15. **COMMENT** (**__{{{comment_ID}}}__**, {{{content}}}, **__{{{user_ID*}}}__** (USER), **__{{{story_ID*}}}__** (STORY), {{{created_at}}}, {{{updated_at}}})
+15. **COMMENT** (**__{{{comment_ID}}}__**, {{{comment_content}}}, **__{{{user_ID*}}}__** (USER), **__{{{story_ID*}}}__** (STORY), {{{comment_created_at}}}, {{{comment_updated_at}}})
 
-16. **COLLABORATION** (**__{{{user_ID*}}}__** (USER), **__{{{story_ID*}}}__** (STORY), {{{created_at}}})
+16. **COLLABORATION** (**__{{{user_ID*}}}__** (USER), **__{{{story_ID*}}}__** (STORY), {{{collab_created_at}}})
     * role (multi-valued attribute, see table **ROLE**)
     * permission_level (multi-valued attribute, see table **PERMISSION_LEVEL**)