jiveDocument Table

Document data table.

Column Name Type Length Nullable Unicode Description
commentStatus int N/A false   The status of comments for the document (constants defined in the application).
containerID bigint N/A false   The ID of the container the document is within.
containerType int N/A false   The type of the container the document is within.
creationDate bigint N/A false   The document's creation date.
documentID varchar 255 false true The external ID of the document.
editPolicy int N/A false   The authorship policy for the document.
expirationDate bigint N/A false   The date the document expires.
internalDocID bigint N/A false   The internal ID of the document. Primary key.
meanRating int N/A false   The mean rating for the document.
readCount int N/A false   The number of times the document has been read.
recommended smallint N/A false   Whether or not the document was recommended by a user.
trackbacksEnabled smallint N/A false   Whether or not trackbacks are enabled.
typeID bigint N/A false   The ID of the document type associated with the document.
userID bigint N/A false   The ID of the user who created the document.
versionID int N/A false   The ID of the latest version of the document.
workflowID bigint N/A true   The ID of the workflow associated with the document.