IdeasIdeaComment
Tracks comments associated with ideas to facilitate discussion and feedback.
Columns
Name | Type | Description |
IdeasIdeaId [KEY] | Long | The unique identifier of the idea associated with this comment. This identifier establishes the relationship between an idea and its comments for discussion tracking. |
CreatedBy | String | The username or identifier of the user who posted the comment. This identifier helps in tracking the contributor of the discussion. |
CreationDate | Datetime | The timestamp when the comment was initially created. This timestamp is used for chronological ordering and tracking discussion activity. |
IdeaComment | String | The text content of the comment. This content provides feedback, suggestions, or discussions related to the idea. |
IdeaCommentId [KEY] | Long | The unique identifier assigned to the comment. This identifier is used for tracking and managing comments within the system. |
IdeaId | Long | The unique identifier of the idea that this comment is associated with. This identifier ensures comments are correctly linked to the relevant idea. |
IdeaName | String | The name of the idea to which the comment belongs. This name provides a human-readable reference for easier identification. |
LastUpdateDate | Datetime | The timestamp of the most recent update to the comment. The timestamp helps in auditing modifications and tracking revisions. |
LastUpdatedBy | String | The username or identifier of the last user who modified the comment. This identifier is useful for monitoring changes and ensuring accountability. |
ObjectVersionNumber | Int | A system-generated version number that tracks changes to the comment record in the database. This number is used for concurrency control and record updates. |
UserName | String | The username of the person who posted the comment. This username is used for displaying the author of the comment in discussions. |
PersonId | Long | The unique identifier of the person associated with the comment. This identifier is used for linking comments to user profiles in the system. |
DisplayName | String | The display name of the user who posted the comment. The display name provides a readable user reference for UI elements and reports. |
Finder | String | The name of the predefined finder query used to retrieve comments dynamically. Finders improve search and filtering of idea discussions. |