Changes between Version 6 and Version 7 of P1


Ignore:
Timestamp:
02/20/26 14:22:01 (4 weeks ago)
Author:
211099
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • P1

    v6 v7  
    7272* {{{short_description}}} – text, required. Brief description of the story.
    7373* {{{content}}} – text, required. Full content of the story.
    74 * {{{status}}} – text, required. Publication status (draft, published, archived).
     74* {{{status}}} – multi-valued text, required. Publication status (draft, published, archived). A story can have multiple status values over time.
    7575* {{{image}}} – text, optional. URL or path to story cover image.
    7676[[BR]]
    … …  
    8686'''[[span(style=color: #9A0000, Attributes:)]]'''
    8787* {{{chapter_id}}} – numeric, required. Auto-generated primary key.
     88* {{{chapter_number}}} – numeric, required. Order number of the chapter within the story.
    8889* {{{chapter_name}}} – text, required. Name of the chapter.
    8990* {{{title}}} – text, required. Title of the chapter.
    … …  
    134135* {{{notification_id}}} – numeric, required. Auto-generated primary key.
    135136* {{{content}}} – text, required. Content of the notification.
    136 * {{{content_type}}} – text, required. Type of notification content.
     137* {{{content_type}}} – multi-valued text, required. Type of notification content. A notification can belong to multiple content types.
     138* {{{is_read}}} – boolean, required. Indicates whether the notification has been read. Default: false.
     139
    137140[[BR]]
    138141----
    … …  
    149152* {{{original_text}}} – text, required. Original text from the story.
    150153* {{{suggested_text}}} – text, required. AI-suggested improvement.
    151 * {{{suggestion_type}}} – text, required. Type of suggestion (grammar, style, etc.).
     154* {{{suggestion_type}}} – multi-valued text, required. Type of suggestion (grammar, style, etc.). A suggestion can belong to multiple types.
    152155* {{{accepted}}} – boolean, required. Whether the suggestion was accepted.
    153156[[BR]]
    … …  
    189192[[BR]]
    190193----
    191 
     194{{{reading_list_items (READING_LIST – STORY)}}}
     195[[BR]]
     196Represents stories added to reading lists.
     197[[BR]]
     198'''[[span(style=color: #9A0000, Cardinality:)]]'''
     199Cardinality: M:N (Many reading lists can contain many stories))
     200[[BR]]
     201'''[[span(style=color: #9A0000, Keys:)]]'''
     202Keys: Composite key: (list_id, story_id).
     203[[BR]]
     204'''[[span(style=color: #9A0000, Attributes:)]]'''
     205* {{{added_at}}} – timestamp, required. Date and time when the story was added to the reading list.
     206[[BR]]
     207---
    192208{{{collaboration (USER – STORY)}}}
    193209[[BR]]
    … …  
    201217[[BR]]
    202218'''[[span(style=color: #9A0000, Attributes:)]]'''
    203 * {{{role}}} – text, required. Role of the collaborator.
    204 * {{{permission_level}}} – numeric, optional. Level of permission for collaboration.
     219* {{{role}}} – multi-valued text, required. Role of the collaborator.
     220* {{{permission_level}}} – multi-valued numeric, optional. Level of permission for collaboration.
    205221[[BR]]
    206222----
    … …  
    242258----
    243259
    244 {{{is_liked (USER – LIKE – STORY)}}}
    245 [[BR]]
    246 Represents users liking stories.
    247 [[BR]]
    248 '''[[span(style=color: #9A0000, Cardinality:)]]'''
    249 M:N (Many users can like many stories)
    250 [[BR]]
    251 '''[[span(style=color: #9A0000, Keys:)]]'''
    252 Composite key: ({{{user_id}}}, {{{story_id}}}) in LIKE.
    253 [[BR]]
    254 ----
    255 
    256 {{{is_commented (USER – COMMENT – STORY)}}}
    257 [[BR]]
    258 Represents users commenting on stories.
    259 [[BR]]
    260 '''[[span(style=color: #9A0000, Cardinality:)]]'''
    261 M:N (Many users can comment on many stories)
    262 [[BR]]
    263 '''[[span(style=color: #9A0000, Keys:)]]'''
    264 Foreign key: {{{user_id}}} in COMMENT references USER.
     260{{{is_liked (LIKE – STORY)}}}
     261[[BR]]
     262Represents likes given to stories.
     263[[BR]]
     264'''[[span(style=color: #9A0000, Cardinality:)]]'''
     2651:N (One story can have many likes)
     266[[BR]]
     267'''[[span(style=color: #9A0000, Keys:)]]'''
     268Foreign key: {{{story_id}}} in LIKE references STORY.
     269[[BR]]
     270----
     271
     272{{{is_commented (COMMENT – STORY)}}}
     273[[BR]]
     274Represents comments made on stories.
     275[[BR]]
     276'''[[span(style=color: #9A0000, Cardinality:)]]'''
     2771:N (One story can have many comments)
     278[[BR]]
     279'''[[span(style=color: #9A0000, Keys:)]]'''
    265280Foreign key: {{{story_id}}} in COMMENT references STORY.
    266281[[BR]]
    267282----
    268283
    269 {{{notify (USER – NOTIFICATION)}}}
    270 [[BR]]
    271 Represents users receiving notifications.
    272 [[BR]]
    273 '''[[span(style=color: #9A0000, Cardinality:)]]'''
    274 N:1 (Many notifications can be sent to one user)
    275 [[BR]]
    276 '''[[span(style=color: #9A0000, Keys:)]]'''
    277 Foreign key: {{{user_id}}} in NOTIFICATION references USER.
    278 [[BR]]
    279 ----
    280 
    281 {{{need_approval (AI_SUGGESTION – STORY)}}}
    282 [[BR]]
    283 Represents AI suggestions needing approval for stories.
    284 [[BR]]
    285 '''[[span(style=color: #9A0000, Cardinality:)]]'''
    286 N:1 (Many AI suggestions can be made for one story)
    287 [[BR]]
    288 '''[[span(style=color: #9A0000, Keys:)]]'''
    289 Foreign key: {{{story_id}}} in AI_SUGGESTION references STORY.
    290 [[BR]]
    291 ----
     284{{{notify (USER – STORY – NOTIFICATION)}}}
     285[[BR]]
     286Represents notifications sent to users about stories.
     287[[BR]]
     288'''[[span(style=color: #9A0000, Cardinality:)]]'''
     289M:N:P (Many users can receive many notifications about many stories)
     290[[BR]]
     291'''[[span(style=color: #9A0000, Keys:)]]'''
     292Composite key: ({{{user_id}}},{{{story_id}}},{{{notification_id}}})
     293Foreign key: {{{user_id}}} references USER
     294Foreign key: {{{story_id}}} references STORY.
     295Foreign key: {{{notification_id}}} references NOTIFICATION.
     296[[BR]]
     297----
     298
     299{{{need_approval (AI_SUGGESTION – STORY – CHAPTER)}}}
     300[[BR]]
     301Represents AI suggestions needing approval for specific chapters within stories.
     302[[BR]]
     303'''[[span(style=color: #9A0000, Cardinality:)]]'''
     304M:N:P (Many AI suggestions can be made for many stories across many chapters)
     305[[BR]]
     306'''[[span(style=color: #9A0000, Keys:)]]'''
     307Composite key: ({{{suggestion_id}}},{{{story_id}}},{{{chapter_id}}})
     308Foreign key: {{{suggestion_id}}} references AI_SUGGESTION.
     309Foreign key: {{{story_id}}} references STORY.
     310Foreign key: {{{chapter_id}}} references CHAPTER.
     311[[BR]]
     312----