Changes between Version 17 and Version 18 of P2

Timestamp:

07/02/26 18:31:30 (3 days ago)

Author:

211099

Comment:

--

P2

@@ -17 +17 @@
 4. **WRITER** (**__{{{user_ID*}}}__** (USER))
 
-5. **STORY** (**__{{{story_ID}}}__**, {{{mature_content}}}, {{{short_description}}}, {{{image}}}, {{{story_content}}}, **__{{{user_ID*}}}__** (WRITER), {{{story_created_at}}}, {{{story_updated_at}}})
+5. **STORY** (**__{{{story_ID}}}__**,{{{title}}}, {{{mature_content}}}, {{{short_description}}}, {{{image}}}, {{{story_content}}}, **__{{{user_ID*}}}__** (WRITER), {{{story_created_at}}}, {{{story_updated_at}}})
    * status (multi-valued attribute, see table **STATUS**)
 
@@ -24 +24 @@
 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}}})
+8. **GENRE** (**__{{{genre_ID}}}__**, {{{genre_name}}})
 
 9. **READING_LIST** (**__{{{list_ID}}}__**, {{{list_name}}}, {{{list_content}}}, {{{is_public}}}, **__{{{user_ID*}}}__** (USER), {{{list_created_at}}}, {{{list_updated_at}}})
 
-10. **NOTIFICATION** (**__{{{notification_ID}}}__**, {{{notification_content}}}, {{{is_read}}}, {{{notification_created_at}}})
+10. **NOTIFICATION** (**__{{{notification_ID}}}__**, {{{notification_content}}}, {{{is_read}}},**__{{{recipient_user_ID*}}}__** (USER), {{{link}}},{{{notification_created_at}}})
     * content_type (multi-valued attribute, see table **CONTENT_TYPE**)
 
@@ -63 +63 @@
 === DML script for inserting data in the tables ===
 
+
 [wiki:dmlScript.sql DML script]