Comments
Stores blog comment records, including author, content, status, and moderation details.
Columns
| Name | Type | ReadOnly | References | Description |
| Id [KEY] | Long | True |
A unique numeric identifier for the comment. | |
| BlogId | Long | False |
Blogs.Id |
The unique numeric identifier of the blog containing the article that the comment belongs to. |
| ArticleId | Long | False |
Articles.Id |
The unique numeric identifier of the article associated with the comment. |
| Author | String | False |
The name of the person who authored the comment. | |
| Body | String | False |
The content of the comment in basic Textile markup format. | |
| BodyHtml | String | False |
The content of the comment rendered with HTML formatting. | |
| CreatedAt | Datetime | True |
The date and time when the comment was created, in ISO 8601 format. | |
| String | False |
The email address provided by the author of the comment. | ||
| Ip | String | False |
The IP address from which the comment was submitted. | |
| PublishedAt | String | False |
The date and time when the comment was published, in ISO 8601 format. | |
| Status | String | True |
The current moderation or publication status of the comment. The allowed values are pending, approved, unapproved, spam, published, removed. | |
| UpdatedAt | Datetime | True |
The date and time when the comment was last updated, in ISO 8601 format. | |
| UserAgent | String | False |
The user agent string from the browser or software used to post the comment. | |
| PublishedStatus | String | False |
Specifies how comments are filtered by publication state. The default value is 'any'. The allowed values are published, unpublished, any. |