Changes between Version 4 and Version 5 of P1


Ignore:
Timestamp:
02/10/26 18:23:39 (6 weeks ago)
Author:
211099
Comment:

Removed BaseEntity

Legend:

Unmodified
Added
Removed
Modified

  • P1

    v4 v5  
    66=== ENTITIES ===
    77
    8 {{{BASE_ENTITY}}}
    9 [[BR]]
    10 Abstract superclass that provides audit fields for all entities in the system.
    11 [[BR]]
    12 '''[[span(style=color: #9A0000, Note:)]]'''
    13 This is a mapped superclass and does not create a separate table. All attributes are inherited by child entities.
    14 [[BR]]
    15 '''[[span(style=color: #9A0000, Attributes:)]]'''
    16 * {{{created_at}}} – timestamp, required. Automatically set when entity is created.
    17 * {{{updated_at}}} – timestamp, optional. Automatically updated when entity is modified.
    18 [[BR]]
    19 '''[[span(style=color: #9A0000, Child entities:)]]'''
    20 All entities in the system inherit from BASE_ENTITY: USER, STORY, CHAPTER, GENRE, READING_LIST, NOTIFICATION, AI_SUGGESTION, LIKE, COMMENT.
    21 [[BR]]
    22 ----
    238
    249{{{USER}}}
    … …  
    2813'''[[span(style=color: #9A0000, Candidate keys:)]]'''
    2914* {{{user_id}}} – numeric identifier (primary key).
    30 [[BR]]
    31 '''[[span(style=color: #9A0000, Inherited attributes from BASE_ENTITY:)]]'''
    32 * {{{created_at}}} – timestamp, required.
    33 * {{{updated_at}}} – timestamp, optional.
    3415[[BR]]
    3516'''[[span(style=color: #9A0000, Attributes:)]]'''
    … …  
    5132[[BR]]
    5233'''[[span(style=color: #9A0000, Inheritance:)]]'''
    53 Inherits all attributes from USER (including BASE_ENTITY attributes).
     34Inherits all attributes from USER.
    5435[[BR]]
    5536----
    … …  
    6344[[BR]]
    6445'''[[span(style=color: #9A0000, Inheritance:)]]'''
    65 Inherits all attributes from USER (including BASE_ENTITY attributes).
     46Inherits all attributes from USER
    6647[[BR]]
    6748----
    … …  
    7556[[BR]]
    7657'''[[span(style=color: #9A0000, Inheritance:)]]'''
    77 Inherits all attributes from USER (including BASE_ENTITY attributes).
     58Inherits all attributes from USER
    7859[[BR]]
    7960----
    … …  
    8162{{{STORY}}}
    8263[[BR]]
    83 Represents every story that is written in the platform. '''Inherits from BASE_ENTITY.'''
     64Represents every story that is written in the platform.
    8465[[BR]]
    8566'''[[span(style=color: #9A0000, Candidate keys:)]]'''
    8667* {{{story_id}}} – surrogate numeric identifier (primary key).
    87 [[BR]]
    88 '''[[span(style=color: #9A0000, Inherited attributes from BASE_ENTITY:)]]'''
    89 * {{{created_at}}} – timestamp, required.
    90 * {{{updated_at}}} – timestamp, optional.
    9168[[BR]]
    9269'''[[span(style=color: #9A0000, Attributes:)]]'''
    … …  
    10279{{{CHAPTER}}}
    10380[[BR]]
    104 Represents a chapter, which is part of a story. '''Inherits from BASE_ENTITY.'''
     81Represents a chapter, which is part of a story.
    10582[[BR]]
    10683'''[[span(style=color: #9A0000, Candidate keys:)]]'''
    10784* {{{chapter_id}}} – surrogate numeric identifier (primary key).
    108 [[BR]]
    109 '''[[span(style=color: #9A0000, Inherited attributes from BASE_ENTITY:)]]'''
    110 * {{{created_at}}} – timestamp, required.
    111 * {{{updated_at}}} – timestamp, optional.
    11285[[BR]]
    11386'''[[span(style=color: #9A0000, Attributes:)]]'''
    … …  
    12598{{{GENRE}}}
    12699[[BR]]
    127 Represents a genre category for stories. '''Inherits from BASE_ENTITY.'''
     100Represents a genre category for stories.
    128101[[BR]]
    129102'''[[span(style=color: #9A0000, Candidate keys:)]]'''
    130103* {{{genre_id}}} – surrogate numeric identifier (primary key).
    131 [[BR]]
    132 '''[[span(style=color: #9A0000, Inherited attributes from BASE_ENTITY:)]]'''
    133 * {{{created_at}}} – timestamp, required.
    134 * {{{updated_at}}} – timestamp, optional.
    135104[[BR]]
    136105'''[[span(style=color: #9A0000, Attributes:)]]'''
    … …  
    142111{{{READING_LIST}}}
    143112[[BR]]
    144 Represents a reading list created by users. '''Inherits from BASE_ENTITY.'''
     113Represents a reading list created by users.
    145114[[BR]]
    146115'''[[span(style=color: #9A0000, Candidate keys:)]]'''
    147116* {{{list_id}}} – surrogate numeric identifier (primary key).
    148 [[BR]]
    149 '''[[span(style=color: #9A0000, Inherited attributes from BASE_ENTITY:)]]'''
    150 * {{{created_at}}} – timestamp, required.
    151 * {{{updated_at}}} – timestamp, optional.
    152117[[BR]]
    153118'''[[span(style=color: #9A0000, Attributes:)]]'''
    … …  
    161126{{{NOTIFICATION}}}
    162127[[BR]]
    163 Represents notifications sent to users. '''Inherits from BASE_ENTITY.'''
     128Represents notifications sent to users.
    164129[[BR]]
    165130'''[[span(style=color: #9A0000, Candidate keys:)]]'''
    166131* {{{notification_id}}} – surrogate numeric identifier (primary key).
    167 [[BR]]
    168 '''[[span(style=color: #9A0000, Inherited attributes from BASE_ENTITY:)]]'''
    169 * {{{created_at}}} – timestamp, required.
    170 * {{{updated_at}}} – timestamp, optional.
    171132[[BR]]
    172133'''[[span(style=color: #9A0000, Attributes:)]]'''
    … …  
    179140{{{AI_SUGGESTION}}}
    180141[[BR]]
    181 Represents AI-generated suggestions for story improvements. '''Inherits from BASE_ENTITY.'''
     142Represents AI-generated suggestions for story improvements.
    182143[[BR]]
    183144'''[[span(style=color: #9A0000, Candidate keys:)]]'''
    184145* {{{suggestion_id}}} – surrogate numeric identifier (primary key).
    185 [[BR]]
    186 '''[[span(style=color: #9A0000, Inherited attributes from BASE_ENTITY:)]]'''
    187 * {{{created_at}}} – timestamp, required.
    188 * {{{updated_at}}} – timestamp, optional.
    189146[[BR]]
    190147'''[[span(style=color: #9A0000, Attributes:)]]'''
    … …  
    199156{{{LIKE}}}
    200157[[BR]]
    201 Represents likes given by users to stories. '''Inherits from BASE_ENTITY.'''
     158Represents likes given by users to stories.
    202159[[BR]]
    203160'''[[span(style=color: #9A0000, Candidate keys:)]]'''
    204161* Composite key: ({{{user_id}}}, {{{story_id}}}).
    205162[[BR]]
    206 '''[[span(style=color: #9A0000, Inherited attributes from BASE_ENTITY:)]]'''
    207 * {{{created_at}}} – timestamp, required.
    208 * {{{updated_at}}} – timestamp, optional.
    209 [[BR]]
    210163----
    211164
    212165{{{COMMENT}}}
    213166[[BR]]
    214 Represents comments made by users on stories. '''Inherits from BASE_ENTITY.'''
     167Represents comments made by users on stories.
    215168[[BR]]
    216169'''[[span(style=color: #9A0000, Candidate keys:)]]'''
    217170* {{{comment_id}}} – surrogate numeric identifier (primary key).
    218 [[BR]]
    219 '''[[span(style=color: #9A0000, Inherited attributes from BASE_ENTITY:)]]'''
    220 * {{{created_at}}} – timestamp, required.
    221 * {{{updated_at}}} – timestamp, optional.
    222171[[BR]]
    223172'''[[span(style=color: #9A0000, Attributes:)]]'''