Comments
- Last UpdatedMar 10, 2025
- 1 minute read
Contains details of comments associated with a tag.
|
Column |
Data Type |
Description |
|---|---|---|
|
Comments |
int NOT NULL |
The unique numerical identifier for the comment. |
|
(FK) Comments |
tinyint NOT NULL |
The unique numerical identifier for the comment type. CommentsTypeKey is a foreign key from the CommentsType table. |
|
(FK) Comments |
int NOT NULL |
The unique numerical identifier for the owner of the comment. |
|
(FK) Comments |
tinyint NOT NULL |
Indicates whether or not the comment is shared. |
|
(FK) FQN |
nvarchar(256) NOT NULL |
Fully qualified name of the associated tag. A fully qualified tagname uses the format: DataSourceName.TagName. FQN is a foreign key from the ChartConfigurationTag table. |
|
DateTime |
datetime2(7) NOT NULL |
The timestamp for this comment. |
|
DateTimeUtc |
datetime2(7) NOT NULL |
The UTC timestamp for this comment. |
|
Content |
nvarchar(1024) NOT NULL |
The comment text. |
|
CreationDateTime |
datetime2(7) NOT NULL |
The date and time that the comment was created |
|
CreationDateTimeUtc |
datetime2(7) NOT NULL |
The UTC date and time that the comment was created |
|
ModifiedDateTime |
datetime2(7) NULL |
The date and time that the comment was modified. |
|
ModifiedDateTimeUtc |
datetime2(7) NULL |
The URC date and time that the comment was modified |
|
LastShared |
datetime2(7) NULL |
The date and time that the comment was last shared |
|
LastShared |
datetime2(7) NULL |
The UTC date and time that the comment was last shared |