Issue Comments

The ScmCreatedOn field of type datetime2 is a critical component of the IssueComment table. This field represents the specific date and time that an issue comment was created and added to the table. By utilizing the datetime2 data type, this field can accurately store the date and time up to nanosecond precision, allowing for precise tracking and sorting of comments. The values in this field can be used for various analyses, such as identifying patterns and trends in comment activity. Overall, the ScmCreatedOn field plays a crucial role in accurately recording and organizing the creation of issue comments in the corresponding table.

The ScmUpdateOn field in the IssueComment table is a datetime2 data type that records the date and time when the associated issue was last updated. This field serves as a timestamp for tracking the most recent changes made to the issue, providing valuable information for project management and issue resolution. The use of the datetime2 data type allows for precise and accurate recording of the update time, allowing for easy sorting and tracking of changes.

The SynchronisedOn field in the IssueComment table is a datetime2 data type that stores the date and time when the comment was last synchronised. This field is useful for tracking when the comment was last updated or modified, allowing for better organization and management of issues and their associated comments. Additionally, the datetime precision of the field ensures accuracy and consistency in recording the exact time of synchronization. It serves as a valuable tool for monitoring the progression and resolution of issues and maintaining a comprehensive record of changes made to comments within the table.