jivePTask Table

Container table for work space data.

Column Name Type Length Nullable Unicode Description
assignorID bigint N/A true   ID of the user that assigned the task.
body varchar 3500 true true Task notes.
completed int N/A false   Whether the current task is completed or not.
creationDate bigint N/A false   Create date of the task.
dueDate bigint N/A true   Due date of the task.
dueDateNull int N/A false   Whether the current task has a due date or not.
modificationDate bigint N/A false   Last modification date of the task.
ownerID bigint N/A true   ID of the user that is assigned the task.
parentObjectID bigint N/A false   The ID of the parent object of the task.
parentObjectType int N/A false   The type of the parent object of the task.
subject varchar 3500 false true Task description.
taskID bigint N/A false   Project Task ID. Primary key.
userID bigint N/A true   ID of the user that created the task.