Changes between Version 9 and Version 10 of P1

Timestamp:

03/03/26 23:10:36 (3 weeks ago)

Author:

211099

Comment:

--

P1

@@ -260 +260 @@
 ----
 
-{{{is_liked (LIKE – STORY)}}}
-[[BR]]
-Represents likes given to stories.
-[[BR]]
-'''[[span(style=color: #9A0000, Cardinality:)]]'''
-1:N (One story can have many likes)
-[[BR]]
-'''[[span(style=color: #9A0000, Keys:)]]'''
-Foreign key: {{{story_id}}} in LIKE references STORY.
-[[BR]]
-----
-
-{{{is_commented (COMMENT – STORY)}}}
-[[BR]]
-Represents comments made on stories.
-[[BR]]
-'''[[span(style=color: #9A0000, Cardinality:)]]'''
-1:N (One story can have many comments)
-[[BR]]
-'''[[span(style=color: #9A0000, Keys:)]]'''
-Foreign key: {{{story_id}}} in COMMENT references STORY.
+{{{is_liked (USER – LIKE – STORY)}}}
+[[BR]]
+Represents likes given by users to stories.
+[[BR]]
+'''[[span(style=color: #9A0000, Cardinality:)]]'''
+User 1:N LIKE, Story 1:N LIKE (One user can like many stories, one story can have many likes)
+[[BR]]
+'''[[span(style=color: #9A0000, Keys:)]]'''
+Composite key: (user_id, story_id) in LIKE
+Foreign key: {{{user_id}}} in LIKE references USER.
+Foreign key: {{{story_id in}}} LIKE references STORY.
+[[BR]]
+----
+
+{{{is_commented (USER – COMMENT – STORY)}}}
+[[BR]]
+Represents comments made by users on stories.
+[[BR]]
+'''[[span(style=color: #9A0000, Cardinality:)]]'''
+User 1:N COMMENT, Story 1:N COMMENT (One user can make many comments, one story can have many comments)
+[[BR]]
+'''[[span(style=color: #9A0000, Keys:)]]'''
+Foreign key: {{{user_id}}} in COMMENT references USER.
+Foreign key: {{{story_id in}}} COMMENT references STORY.
 [[BR]]
 ----
@@ -313 +316 @@
 [[BR]]
 ----
+
+{{{suggested (STORY – AI_SUGGESTION)}}}
+[[BR]]
+Represents stories having AI-generated suggestions.
+[[BR]]
+'''[[span(style=color: #9A0000, Cardinality:)]]'''
+1:N (One story can have many AI suggestions)
+[[BR]]
+'''[[span(style=color: #9A0000, Keys:)]]'''
+Foreign key: {{{story_id}}} in AI_SUGGESTION references STORY.