This document describes tables in the Clearspace database.

Some information, like column indexes and foreign keys, is omitted. For this, please read the individual schema of the database you're interested in. Data types may also differ somewhat in each individual database schema. See the Clearspace Installation Guide for more database-related information.

See Database Tables for a list of tables and their column descriptions.

See Entity Relationship Illustrations for ER illustrations.

Data Type Conventions

Database Tables

Table Name Description
jiveAbuse Abuse data table.
jiveActivity A table that stores all recent activity happing in the application
jiveAnnounce Container table for announcement data
jiveAnnounceProp Properties for announcements.
jiveAnswer Answer data table.
jiveApprovalWrkflw Workflow approval table.
jiveAttachData Attachment binary data table.
jiveAttachment Attachment definition table.
jiveAttachmentDL Statistical data table for attachment downloads.
jiveAttachmentProp Properties for attachments.
jiveAttachSettings Attachment settings.
jiveAttachTypes Allowed/Disallowed attachment content types.
jiveAttachVersion Version table for document attachments.
jiveAuditLog Audit messages resulting from admin activity
jiveAvatar Avatar data table.
jiveAvatarProp Properties for avatars.
jiveAvatarUser Avatar/user association table.
jiveBan Ban data table.
jiveBlog Blog data table.
jiveBlogPost Blog post data table.
jiveBlogPostProp Properties for blog posts.
jiveBlogProp Properties for blogs.
jiveCollaboration Junction Table for Collaborators and Jive Objects
jiveComment Comments.
jiveCommentProp Properties for comments.
jiveCommunity Container table for community data.
jiveCommunityProp Properties for communities
jiveContainerAprvr Container approvers.
jiveContainerBlog Blog/container association table.
jiveContentBackup Content backup table
jiveDataType Datatype definition table.
jiveDocBodyConfig Setting data for document bodies.
jiveDocBodyTypes Allowed/Disallowed binary body content types.
jiveDocBodyVersion Document body versions.
jiveDocCollab Document collaboration.
jiveDocElementType Document element types.
jiveDocType Document type data table.
jiveDocTypeElement Document type elements.
jiveDocTypeProp Properties for document types.
jiveDocument Document data table.
jiveDocumentAudit Document audit trail (not currently used).
jiveDocumentBody The body of the document.
jiveDocumentProp Properties for documents.
jiveDocVersion Document version table.
jiveDocVersionCmmt Comments on document versions.
jiveDraft Draft data table.
jiveDraftImage Draft/Image assocation table
jiveDraftProp Properties for drafts.
jiveEmailToken User email token data table.
jiveEntitlement Entitlement data for Clearspace objects
jiveField Field data table.
jiveFieldFrmtProp Properties for field formatters.
jiveFieldOption Field option data table.
jiveFieldType Document Field types.
jiveFieldValue Field values.
jiveFieldVldtrProp Properties for field validators.
jiveGateway Gateway data table.
jiveGatewayProp Properties for gateways.
jiveGroup Container table for group data.
jiveGroupPerm Group permissions.
jiveGroupProp Properties for groups.
jiveGroupUser Container table for specifying the users in a group.
jiveI18nText provides internationalized text for other tables.
jiveID ID Sequence table.
jiveImage Image data table.
jiveImageData Image data.
jiveImageVersion Version table for document images.
jiveInvite Table for invitations
jiveInviteProp Properties for invitations.
jiveLabelElement Label elements.
jiveLinkObject Link data table.
jiveLocalizedProp Localized system wide Jive properties.
jiveMessage Container data for forum message data.
jiveMessageProp Properties for messages.
jiveModeration Audit table for moderation events.
jiveObjectTag Tag/object association table.
jiveOSPropEntry OSWorkflow property table.
jivePCheckPoint Container table for work space checkPoint data.
jivePlugin Plugin information
jivePluginProp A table that contents contains custom properties stored for plugins
jivePMessage Container table for private message data.
jivePMessageFldr Private message folders.
jivePMessageProp Properties for private messages.
jivePoll Poll data table.
jivePollOption Poll options table.
jivePollVote Poll vote data table.
jivePopularity A table that stores archived content popularity scores for generating popular content
jivePresenter Presention information data table.
jiveProfileField Profile field data table.
jiveProfileFldOpt Profile field option data table.
jiveProject Container table for work space data.
jiveProjectProp Properties for work spaces
jiveProjectStatus Table for project status.
jiveProperty System wide Jive properties.
jivePTask Container table for work space data.
jivePTaskProp Properties for work space checkPoints
jivePTracker user/project association table.
jiveQuestion Question data table.
jiveQuestionProp Properties for questions.
jiveRating Rating data table.
jiveRatingType Rating types.
jiveReadTracker Read tracking data table.
jiveReference Jive Reference Table
jiveSearch Search logging data table.
jiveSearchClick Search result clickthrough tracking table.
jiveSearchCriteria Search criteria data table.
jiveSearchEngine Installed OpenSearch engine information
jiveSectionElement Section elements.
jiveSGroup Container table for social groups.
jiveSGroupMember Member table for social groups.
jiveSGroupProp Properties for social groups
jiveShare Jive Artifact Sharing Information
jiveStat Statistics.
jiveStatLvlScen Status level scenarios.
jiveStatusLevel Status levels.
jiveStatusLevelPnt Status level points.
jiveTag Tag data table.
jiveTagSet Tag set data table.
jiveTagSetMap Association table for tag sets and tags.
jiveThemeMap Mapping table for theme mapping data.
jiveThread Container table for forum thread data.
jiveThreadProp Properties for threads.
jiveTrackback Trackback data table for blogs.
jiveTrackbackProp Properties for trackbacks.
jiveTypeVldtrProp Properties for document type validators.
jiveUser Container table for user data.
jiveUserContainer Representation of user-owned content aggregation
jiveUserIMHandle User IM handles.
jiveUserPerm User permissions.
jiveUserProfile User profile data table.
jiveUserProp Properties for users.
jiveUserRel Historical relationships between users
jiveUserRelGraph A container for a set of relationships.
jiveUserRoster User Rosters.
jiveUserStatus User status information
jiveUserToContent Relationship between a user container and their content.
jiveUsrRelGrApr A set of users who approve all new graph relationships.
jiveUsrRelGrNtf A set of users who are notified of graph relationship changes.
jiveUsrRelList User-specific lists of relationships
jiveUsrRelListMap Maps user relationship lists to relationships
jiveVersion Version data table.
jiveViewCount Object view counts.
jiveWatch Container table for user watch data.
jiveWatchSettings Watch settings data table.
jiveWFCurrentStep OSWorkflow workflow current step table.
jiveWFCurrStepPrev OSWorkflow previous workflow step table.
jiveWFEntry OSWorkflow entry table.
jiveWFHistoryStep OSWorkflow workflow history table.
jiveWFHistStepPrev OSWorkflow history step table.
jiveWidget Installed widget information
jiveWidgetFrame Container table for Widget frames
jiveWidgetFrmProp Properties for widget frames
jiveWikiLink Wiki link tracking table.
jiveWLayout Installed widget layout information
jiveWLayoutFrame Container table for Widget Layout frames

jiveAbuse

Abuse data table.

Column Name Type Length Nullable Unicode Description
abuseID bigint N/A false   The ID of the abuse. Primary key.
abuseType bigint N/A false   The type of abuse report (constant defined in application).
comments varchar 255 true true Any comments the user submits with the report.
objectID bigint N/A false   The ID of the abusive object.
objecttype bigint N/A false   The type of the abusive object.
reportDate bigint N/A false   The date the report was made.
resolved smallint N/A true   Whether or not the report has been resolved.
userID bigint N/A false   The user making the report.

Top of the page

jiveActivity

A table that stores all recent activity happing in the application

Column Name Type Length Nullable Unicode Description
activityID bigint N/A false   The primary key of the activity entry. Primary key.
activityType int N/A false   The type of the activity that occurred.
containerID bigint N/A false   The ID of the object that contains the activity object, like a community or blog.
containerType int N/A false   The type of the object that contains the activity object, like a community or blog.
creationDate bigint N/A false   The date of the activity occurred.
objectID bigint N/A false   The ID of the activity object.
objectType int N/A false   The type of the activity object.
userID bigint N/A true   The user ID that caused the activity.

Top of the page

jiveAnnounce

Container table for announcement data

Column Name Type Length Nullable Unicode Description
announcementID bigint N/A false   Announcement ID. Primary key.
body text N/A false true The body of the announcement.
endDate bigint N/A true   End date.
objectID bigint N/A true   Object ID the announcement is associated with.
objectType int N/A false   Object type associated with the announcement.
startDate bigint N/A false   Start date.
status int N/A false   The published status of the announcement.
subject varchar 255 false true The subject of the announcement.
userID bigint N/A false   User who created the announcement.

Top of the page

jiveAnnounceProp

Properties for announcements.

Column Name Type Length Nullable Unicode Description
announcementID bigint N/A false   Announcement ID. Primary key.
name varchar 100 false true Property name. Primary key.
propValue varchar 3500 false true Property value.

Top of the page

jiveAnswer

Answer data table.

Column Name Type Length Nullable Unicode Description
containerID bigint N/A false   ID of the answer's container.
containerType bigint N/A false   Type of the answer's container.
correctAnswer smallint N/A false   Indicates if the answer was correct (boolean 1 or 0).
helpfulAnswer smallint N/A false   Indicates if the answer was helpful (boolean 1 or 0).
messageID bigint N/A false   ID of the answer's message. Primary key.
threadID bigint N/A false   ID of the answer's thread. Primary key.
userID bigint N/A true   ID of the answer's user (can be NULL).

Top of the page

jiveApprovalWrkflw

Workflow approval table.

Column Name Type Length Nullable Unicode Description
approvalTime bigint N/A true   The time the user approved/rejected the object.
approved smallint N/A false   Whether or not the object has been approved by the user.
creationTime bigint N/A false   The time the approval entry was created.
objID bigint N/A false   The ID of the object. Primary key.
queuedType smallint N/A false   The type of queue the workflow item should be displayed in.
rejected smallint N/A false   Whether or not the object has been rejected by the user.
requestMessage varchar 255 true true A message to the user from which the approval is being requested.
responseMessage varchar 255 true true A response message to go with the approval or rejection.
typeID bigint N/A false   The ID of the object type. Primary key.
userID bigint N/A false   User ID. Primary key.
workflowID bigint N/A false   Workflow ID. Primary key.

Top of the page

jiveAttachData

Attachment binary data table.

Column Name Type Length Nullable Unicode Description
attachmentData blob N/A false   Binary data of the attachment.
attachmentID bigint N/A false   Attachment ID. Primary key.

Top of the page

jiveAttachment

Attachment definition table.

Column Name Type Length Nullable Unicode Description
attachmentID bigint N/A false   Attachment ID. Primary key.
contentType varchar 100 false   MIME-type of attachment.
creationDate bigint N/A false   Creation date.
documentID varchar 255 true true The ID of the (temporary) parent document.
fileName varchar 255 false true Name of attachment.
fileSize int N/A false   Size of attachment in bytes.
modificationDate bigint N/A false   Last modified date.
objectID bigint N/A true   ID of object the attachment belongs to.
objectType int N/A false   Type of object the attachment belongs to.

Top of the page

jiveAttachmentDL

Statistical data table for attachment downloads.

Column Name Type Length Nullable Unicode Description
attachmentID bigint N/A false   Attachment ID.
downloadComplete smallint N/A false   Flag to specify whether the download was completed or not.
downloadDate bigint N/A false   Download date.

Top of the page

jiveAttachmentProp

Properties for attachments.

Column Name Type Length Nullable Unicode Description
attachmentID bigint N/A false   Attachment ID. Primary key.
name varchar 100 false true Property name. Primary key.
propValue varchar 3500 false true Property value.

Top of the page

jiveAttachSettings

Attachment settings.

Column Name Type Length Nullable Unicode Description
allowByDefault smallint N/A false   Whether all content types are allowed by default.
enabled smallint N/A false   Whether of not attachments are enabled for the document type.
maxNumber int N/A false   The maximum number of attachments.
maxSize int N/A false   The maximum size of attachments in bytes.
typeID bigint N/A false   The ID of the document type. Primary key.

Top of the page

jiveAttachTypes

Allowed/Disallowed attachment content types.

Column Name Type Length Nullable Unicode Description
allowedType varchar 50 true true A comma separated list of allowed content types.
disallowedType varchar 50 true true A comma separated list of disallowed content types.
typeID bigint N/A false   The ID of the document type.

Top of the page

jiveAttachVersion

Version table for document attachments.

Column Name Type Length Nullable Unicode Description
attachmentID bigint N/A false   The ID of the attachment. Primary key.
internalDocID bigint N/A false   The ID of the document. Primary key.
versionID int N/A false   The ID of the document version. Primary key.

Top of the page

jiveAuditLog

Audit messages resulting from admin activity

Column Name Type Length Nullable Unicode Description
auditMessageID bigint N/A false   Audit Message ID. Primary key.
description varchar 1024 false true Logical name of the action.
details varchar 2048 true   The description of the action performed.
node varchar 512 false   The ip address of the node on which the action was initiated.
timestamp bigint N/A false   Date and time of when the action took place.
userID bigint N/A false   ID of user who performed the action.

Top of the page

jiveAvatar

Avatar data table.

Column Name Type Length Nullable Unicode Description
avatarID bigint N/A false   Avatar ID. Primary key.
modValue int N/A false   The moderation value for the avatar.
ownerID bigint N/A true   The ID of the person who created the avatar.

Top of the page

jiveAvatarProp

Properties for avatars.

Column Name Type Length Nullable Unicode Description
avatarID bigint N/A false   Avatar ID. Primary key.
name varchar 100 false true Property name. Primary key.
propValue varchar 3500 false true Property value.

Top of the page

jiveAvatarUser

Avatar/user association table.

Column Name Type Length Nullable Unicode Description
avatarID bigint N/A false   Avatar ID. Primary key.
userID bigint N/A false   ID of the user associated with the avatar. Primary key.

Top of the page

jiveBan

Ban data table.

Column Name Type Length Nullable Unicode Description
adminID bigint N/A false   The ID of the admin making the ban decision.
banID bigint N/A false   The ID of the ban. Primary key.
banLevel int N/A false   The ban punishment (constants defined in application).
bannedUserID bigint N/A true   The ID of the user being banned.
banType int N/A false   The type of ban (constants defined in the application).
comments varchar 50 true true Any comments associated with the ban.
creationDate bigint N/A false   The date the ban was created.
expirationDate bigint N/A true   The date the ban expires.
ipAddress varchar 15 true true The IP address being banned.

Top of the page

jiveBlog

Blog data table.

Column Name Type Length Nullable Unicode Description
blogID bigint N/A false   The ID of the blog. Primary key.
cmAuthentication smallint N/A true   The comment authentication strategy of this blog.
cmModeration smallint N/A true   Whether or not comment moderation is enabled.
cmNotification smallint N/A true   Whether or not comment notification is enabled.
containerID bigint N/A false   The ID of the container to which this blog belongs.
containerType int N/A false   The type of the container to which this blog belongs.
creationDate bigint N/A false   The date the blog was created.
description varchar 1000 true true The description of the blog.
displayName varchar 255 true true The display name of the blog (shows in URLs).
feedEnabled smallint N/A true   Whether or not feeds are enabled for the blog (constants defined in the application).
feedFullContent smallint N/A true   Whether or not feed contain full blog post content.
modificationDate bigint N/A false   The data the blog was modified.
name varchar 255 false true The name of the blog.
pingOverride smallint N/A true   Whether global ping settings are overridden by this blog or not.
pingServices text N/A true true A list of services to ping when this blog is updated.
tbModeration smallint N/A true   Whether or not trackback moderation is enabled.
tbNotification smallint N/A true   Whether or not trackback notification is enabled.

Top of the page

jiveBlogPost

Blog post data table.

Column Name Type Length Nullable Unicode Description
blogID bigint N/A false   The ID of the blog this blog post is contained within.
blogpostID bigint N/A false   The ID of the blog post. Primary key.
body text N/A true true The body of the blog post.
commentStatus int N/A false   The comment status of the blog post (constants defined in the application).
creationDate bigint N/A false   The date the blog post was created.
modificationDate bigint N/A false   The date the blog post was last modified.
permalink varchar 255 true true The permanent link URL to the blog post.
publishDate bigint N/A false   The date the blog post was published.
status int N/A false   The published status of the blog post.
subject varchar 255 true true The subject of the blog post.
trackbacksEnabled smallint N/A false   Whether or not trackbacks are enabled for the blog post.
userID bigint N/A false   The ID of the user who created the blog post.

Top of the page

jiveBlogPostProp

Properties for blog posts.

Column Name Type Length Nullable Unicode Description
blogpostID bigint N/A false   The ID of the blog post. Primary key.
name varchar 100 false true Property name. Primary key.
propValue varchar 3500 false true Property value.

Top of the page

jiveBlogProp

Properties for blogs.

Column Name Type Length Nullable Unicode Description
blogID bigint N/A false   The ID of the blog. Primary key.
name varchar 100 false true Property name. Primary key.
propValue varchar 3500 false true Property value.

Top of the page

jiveCollaboration

Junction Table for Collaborators and Jive Objects

Column Name Type Length Nullable Unicode Description
collaborationEnd bigint N/A false  
collaborationID bigint N/A false   Primary key.
collaborationStart bigint N/A false  
collaborationState smallint N/A false  
createdBy bigint N/A false  
creationDate bigint N/A true  
modificationDate bigint N/A true  
shareID bigint N/A false   ID of the share for this collaboration
updatedBy bigint N/A false  
userID bigint N/A false   ID of the user collaborating on the document

Top of the page

jiveComment

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 100 true true The user's URL.
userID bigint N/A true   The user ID of the user who made the comment.

Top of the page

jiveCommentProp

Properties for comments.

Column Name Type Length Nullable Unicode Description
commentID bigint N/A false   The ID of the comment. Primary key.
name varchar 100 false true Property name. Primary key.
propValue varchar 3500 false true Property value.

Top of the page

jiveCommunity

Container table for community data.

Column Name Type Length Nullable Unicode Description
communityID bigint N/A false   Community ID. Primary key.
contentTypes bigint N/A false   The types of content that are permissable in the community.
creationDate bigint N/A false   Create date of community.
description varchar 1000 true true Community description.
displayName varchar 255 false true Community display name (shows in URLs).
lft int N/A false   The left value of the community in the tree.
localeCode varchar 32 true   The locale code for the community.
modDfltMsgVal int N/A false   The default message moderation value.
modDfltThreadVal int N/A false   The default thread moderation value.
modificationDate bigint N/A false   Last modification date of community.
name varchar 255 false true Community name.
rgt int N/A false   The right value of the community in the tree.
workflowID bigint N/A true   The default workflowID for the community.

Top of the page

jiveCommunityProp

Properties for communities

Column Name Type Length Nullable Unicode Description
communityID bigint N/A false   Community ID. Primary key.
name varchar 100 false true Property name. Primary key.
propValue varchar 3500 false true Property value.

Top of the page

jiveContainerAprvr

Container approvers.

Column Name Type Length Nullable Unicode Description
containerID bigint N/A false   Container ID. Primary key.
containerType int N/A false   Container Type. Primary key.
userID bigint N/A false   Approver User ID. Primary key.

Top of the page

jiveContainerBlog

Blog/container association table.

Column Name Type Length Nullable Unicode Description
blogID bigint N/A false   The ID of the blog associated with the container. Primary key.
containerID bigint N/A false   The ID of the container. Primary key.
containerType int N/A false   The type of the container. Primary key.

Top of the page

jiveContentBackup

Content backup table

Column Name Type Length Nullable Unicode Description
body text N/A true true
modificationDate bigint N/A false  
objectID bigint N/A false   Primary key.
objectType int N/A false   Primary key.
versionID int N/A false   Primary key.

Top of the page

jiveDataType

Datatype definition table.

Column Name Type Length Nullable Unicode Description
dataType varchar 20 false   The name of the datatype. Primary key.
dataTypeID bigint N/A false   The ID of the dataType. Primary key.

Top of the page

jiveDocBodyConfig

Setting data for document bodies.

Column Name Type Length Nullable Unicode Description
allowByDefault int N/A false   Whether all content types are allowed by default.
enabled int N/A false   Whether or not binary document bodies are allowed.
maxSize int N/A false   The maximum size of binary document bodies in bytes.
typeID bigint N/A false   The ID of the document type. Primary key.

Top of the page

jiveDocBodyTypes

Allowed/Disallowed binary body content types.

Column Name Type Length Nullable Unicode Description
allowedType varchar 50 true true A comma separated list of allowed content types.
disallowedType varchar 50 true true A comma separated list of disallowed content types.
typeID bigint N/A false   The ID of the document type.

Top of the page

jiveDocBodyVersion

Document body versions.

Column Name Type Length Nullable Unicode Description
bodyID bigint N/A false   The ID of the body. Primary key.
internalDocID bigint N/A false   The ID of the document. Primary key.
versionID int N/A false   The version ID. Primary key.

Top of the page

jiveDocCollab

Document collaboration.

Column Name Type Length Nullable Unicode Description
collaboratorType smallint N/A false   The type of collaboration (constants defined in the application). Primary key.
internalDocID bigint N/A false   The ID of the document. Primary key.
userID bigint N/A false   The user ID. Primary key.

Top of the page

jiveDocElementType

Document element types.

Column Name Type Length Nullable Unicode Description
elementTypeID bigint N/A false   The ID of the element type. Primary key.
name varchar 20 false true The name of the element type.

Top of the page

jiveDocType

Document type data table.

Column Name Type Length Nullable Unicode Description
description varchar 1000 true true The type's description.
name varchar 100 false true The name of the document type.
presenterID bigint N/A true   The ID of the presenter for document type.
typeID bigint N/A false   The ID of the document type. Primary key.
typeIndex int N/A false   The index of this type.
validator varchar 255 true true The classname of validator to validate this document type.

Top of the page

jiveDocTypeElement

Document type elements.

Column Name Type Length Nullable Unicode Description
documentTypeID bigint N/A false   The ID of the document type. Primary key.
elementID bigint N/A false   The ID of the element. Primary key.
elementIndex int N/A false   The index of the element.
elementTypeID bigint N/A false   The ID of the element type.
fRowVersion bigint N/A true   A sequence for the field row version.

Top of the page

jiveDocTypeProp

Properties for document types.

Column Name Type Length Nullable Unicode Description
name varchar 100 false true Property name. Primary key.
propValue varchar 3500 false true proeprty value.
typeID bigint N/A false   The ID of the document type. Primary key.

Top of the page

jiveDocument

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.

Top of the page

jiveDocumentAudit

Document audit trail (not currently used).

Column Name Type Length Nullable Unicode Description
alterDate bigint N/A false   The date the document was altered.
alterType bigint N/A false   The type of alteration.
fieldID bigint N/A true   The field ID that was altered.
internalDocID bigint N/A false   The ID of the document.
oldValue text N/A true true The old value before alteration.
userID bigint N/A true   The user ID.
versionID int N/A false   The version ID.

Top of the page

jiveDocumentBody

The body of the document.

Column Name Type Length Nullable Unicode Description
bodyData blob N/A true   The binary data for the binary document body.
bodyID bigint N/A false   The ID of the body. Primary key.
bodyText text N/A true true The text of the document body.
contentType varchar 100 true   The content type of the binary document body.
creationDate bigint N/A false   The creation date of the document body.
fileName varchar 255 true true The name of the binary document body.
fileSize int N/A true   The size of the binary document body.

Top of the page

jiveDocumentProp

Properties for documents.

Column Name Type Length Nullable Unicode Description
internalDocID bigint N/A false   The ID of the document. Primary key.
name varchar 100 false true Property name. Primary key.
propValue varchar 3500 false true Property value.