Changes between Version 3 and Version 4 of P2

Timestamp:

02/13/26 14:18:43 (5 weeks ago)

Author:

211099

Comment:

--

P2

@@ -10 +10 @@
 == Tables ==
 
-1. STORY(story_ID, mature_content, short_description, image, content, user_ID*(WRITER))
+1. STORY(__story_ID__, mature_content, short_description, image, content, user_ID*(WRITER))
    * status (multi-valued attribute, see table STATUS)
 
-2. STATUS(story_ID*(STORY), status)
+2. STATUS(__story_ID*(STORY)__, __status__)
 
-3. USER(user_ID, username, email, name, surname, password)
+3. USER(__user_ID__, username, email, name, surname, password)
 
-4. ADMIN(user_ID*(USER))
+4. ADMIN(__user_ID*(USER)__)
 
-5. REGULAR_USER(user_ID*(USER))
+5. REGULAR_USER(__user_ID*(USER)__)
 
-6. WRITER(user_ID*(USER), created_story)
+6. WRITER(__user_ID*(USER)__, created_story)
 
-7. CHAPTER(chapter_ID, chapter_name, title, content, word_count, rating, published_at, view_count, story_ID*(STORY))
+7. CHAPTER(__chapter_ID__, chapter_name, title, content, word_count, rating, published_at, view_count, story_ID*(STORY))
 
-8. GENRE(genre_ID, name)
+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))
 
-10. NOTIFICATION(notification_ID, content, content_type, user_ID*(USER))
+10. NOTIFICATION(__notification_ID__, content, content_type, user_ID*(USER))
 
-11. AI_SUGGESTION(suggestion_ID, original_text, suggested_text, suggestion_type, accepted, story_ID*(STORY))
+11. AI_SUGGESTION(__suggestion_ID__, original_text, suggested_text, suggestion_type, accepted, story_ID*(STORY))
 
-12. LIKE(user_ID*(USER), story_ID*(STORY))
+12. LIKE(__user_ID*(USER)__, __story_ID*(STORY)__)
 
-13. COMMENT(comment_ID, content, user_ID*(USER), story_ID*(STORY))
+13. COMMENT(__comment_ID__, content, user_ID*(USER), story_ID*(STORY))
 
-14. COLLABORATION(user_ID*(USER), story_ID*(STORY), role, permission_level)
+14. COLLABORATION(__user_ID*(USER)__, __story_ID*(STORY)__, role, permission_level)
     * role (multi-valued attribute, see table ROLE)
     * permission_level (multi-valued attribute, see table PERMISSION_LEVEL)
 
-15. ROLE(user_ID*(COLLABORATION), story_ID*(COLLABORATION), role)
+15. ROLE(__user_ID*(COLLABORATION)__, __story_ID*(COLLABORATION)__, __role__)
 
-16. PERMISSION_LEVEL(user_ID*(COLLABORATION), story_ID*(COLLABORATION), permission_level)
+16. PERMISSION_LEVEL(__user_ID*(COLLABORATION)__, __story_ID*(COLLABORATION)__, __permission_level__)
 
-17. HAS_GENRE(story_ID*(STORY), genre_ID*(GENRE))
+17. HAS_GENRE(__story_ID*(STORY)__, __genre_ID*(GENRE)__)
 
 === DDL script for creation and deletion of tables ===