jiveComment Table

Comments.

Column Name Type Length Nullable Unicode Description
body text N/A false true The body of the comment.
commentID bigint N/A false   The ID of the comment. Primary key.
creationDate bigint N/A false   The date the comment was created.
email varchar 100 true true The user's email address.
ip varchar 15 true true The user's IP address.
moderated smallint N/A false   Whether or not the comment is moderated.
modificationDate bigint N/A false   The date the comment was modified.
name varchar 100 true true The user's name.
objectID bigint N/A false   The object ID for the comment's parent object.
objectType int N/A false   The object type for the comment's parent object.
parentCommentID bigint N/A true   The ID of the parent comment.
parentObjectID bigint N/A true   The object ID of the parent to the comment's parent object.
parentObjectType int N/A true   The object type of the parent to the comment's parent object.
status int N/A false   The published status of the comment.
url varchar 255 true true The user's URL.
userID bigint N/A true   The user ID of the user who made the comment.