pdf

Database Schema Guide

This document outlines the data type conventions and tables in the Clearspace database schema. 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 Illustration for an ER illustration.

Data Type Conventions

  • Date column type support varies widely across databases. Therefore, Clearspace specially encodes dates as 64-bit numbers. The long value is the internal representation of Java Date objects, which can be obtained with code such as the following: 
    long currentDate = new Date().getTime();

    For information about converting dates into a more human-readable formats, see the following Knowledge Base documents: [41], [211], [231]

  • Boolean values are always represented a numeric values: 0 for false and 1 for true.

Database Tables

Table Name Description
jiveAbuse Abuse data table.
jiveAnnounce Container table for announcement data
jiveAnnounceProp Properties for announcements.
jiveAnswer Answer data table.
jiveApprovalWkflow 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.
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.
jiveBlogToUser Blog/user association table.
jiveComment Comments.
jiveCommentProp Properties for comments.
jiveCommunity Container table for community data.
jiveCommunityAprvr Community approvers.
jiveCommunityBlog Blog/community association table.
jiveCommunityProp Properties for communities
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.
jiveDraftProp Properties for drafts.
jiveEmailToken User email token data table.
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.
jiveID ID Sequence table.
jiveImage Image data table.
jiveImageData Image data.
jiveImageVersion Version table for document images.
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.
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.
jivePresenter Presention information data table.
jiveProfileField Profile field data table.
jiveProfileFldOpt Profile field option data table.
jiveProperty System wide Jive properties.
jiveQuestion Question data table.
jiveQuestionProp Properties for questions.
jiveRating Rating data table.
jiveRatingType Rating types.
jiveReadTracker Read tracking data table.
jiveSearch Search logging data table.
jiveSearchClick Search result clickthrough tracking table.
jiveSearchCriteria Search criteria data table.
jiveSectionElement Section elements.
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.
jiveUserIMHandle User IM handles.
jiveUserPerm User permissions.
jiveUserProfile User profile data table.
jiveUserProp Properties for users.
jiveUserRoster User Rosters.
jiveVersion Version data table.
jiveViewCount Object view counts.
jiveWatch Container table for user watch data.
jiveWatchSettings Watch settings data table.
jiveWikiLink Wiki link tracking table.

jiveAbuse

Abuse data table.

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

top of page

jiveAnnounce

Container table for announcement data

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

top of page

jiveAnnounceProp

Properties for announcements.

Column Name Type Length Description
announcementID bigint N/A Announcement ID.
name varchar 100 Property name.
propValue varchar 3500 Property value.

top of page

jiveAnswer

Answer data table.

Column Name Type Length Description
threadID bigint N/A ID of the answer's thread.
messageID bigint N/A ID of the answer's message.
communityID bigint N/A ID of the answer's community.
userID bigint N/A ID of the answer's user (can be NULL).
helpfulAnswer smallint N/A Indicates if the answer was helpful (boolean 1 or 0).
correctAnswer smallint N/A Indicates if the answer was correct (boolean 1 or 0).

top of page

jiveApprovalWkflow

Workflow approval table.

Column Name Type Length Description
workflowID bigint N/A Workflow ID.
internalDocID bigint N/A The ID of the document.
userID bigint N/A User ID.
approved smallint N/A Whether or not the document has been approved by the user.
rejected smallint N/A Whether or not the document has been rejected by the user.
approvalTime bigint N/A The time the user approved/rejected the document.

top of page

jiveAttachData

Attachment binary data table.

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

top of page

jiveAttachment

Attachment definition table.

Column Name Type Length Description
attachmentID bigint N/A Attachment ID. Primary key.
objectType int N/A Type of object the attachment belongs to.
objectID bigint N/A ID of object the attachment belongs to.
fileName varchar 255 Name of attachment.
fileSize int N/A Size of attachment in bytes.
contentType varchar 50 MIME-type of attachment.
creationDate bigint N/A Creation date.
modificationDate bigint N/A Last modified date.

top of page

jiveAttachmentDL

Statistical data table for attachment downloads.

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

top of page

jiveAttachmentProp

Properties for attachments.

Column Name Type Length Description
attachmentID bigint N/A Attachment ID.
name varchar 100 Property name.
propValue varchar 3500 Property value.

top of page

jiveAttachSettings

Attachment settings.

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

top of page

jiveAttachTypes

Allowed/Disallowed attachment content types.

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

top of page

jiveAttachVersion

Version table for document attachments.

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

top of page

jiveAvatar

Avatar data table.

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

top of page

jiveAvatarProp

Properties for avatars.

Column Name Type Length Description
avatarID bigint N/A Avatar ID.
name varchar 100 Property name.
propValue varchar 3500 Property value.

top of page

jiveAvatarUser

Avatar/user association table.

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

top of page

jiveBan

Ban data table.

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

top of page

jiveBlog

Blog data table.

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

top of page

jiveBlogPost

Blog post data table.

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

top of page

jiveBlogPostProp

Properties for blog posts.

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

top of page

jiveBlogProp

Properties for blogs.

Column Name Type Length Description
blogID bigint N/A The ID of the blog.
name varchar 100 Property name.
propValue varchar 3500 Property value.

top of page

jiveBlogToUser

Blog/user association table.

Column Name Type Length Description
blogID bigint N/A The ID of the blog.
userID bigint N/A The ID of the user associated with the blog.

top of page

jiveComment

Comments.

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

top of page

jiveCommentProp

Properties for comments.

Column Name Type Length Description
commentID bigint N/A The ID of the comment.
name varchar 100 Property name.
propValue varchar 3500 Property value.

top of page

jiveCommunity

Container table for community data.

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

top of page

jiveCommunityAprvr

Community approvers.

Column Name Type Length Description
communityID bigint N/A Community ID.
userID bigint N/A Approver User ID.

top of page

jiveCommunityBlog

Blog/community association table.

Column Name Type Length Description
communityID bigint N/A The ID of the community.
blogID bigint N/A The ID of the blog associated with the community.

top of page

jiveCommunityProp

Properties for communities

Column Name Type Length Description
communityID bigint N/A Community ID.
name varchar 100 Property name.
propValue varchar 3500 Property value.

top of page

jiveDataType

Datatype definition table.

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

top of page

jiveDocBodyConfig

Setting data for document bodies.

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

top of page

jiveDocBodyTypes

Allowed/Disallowed binary body content types.

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

top of page

jiveDocBodyVersion

Document body versions.

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

top of page

jiveDocCollab

Document collaboration.

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

top of page

jiveDocElementType

Document element types.

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

top of page

jiveDocType

Document type data table.

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

top of page

jiveDocTypeElement

Document type elements.

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

top of page

jiveDocTypeProp

Properties for document types.

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

top of page

jiveDocument

Document data table.

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

top of page

jiveDocumentAudit

Document audit trail (not currently used).

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

top of page

jiveDocumentBody

The body of the document.

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

top of page

jiveDocumentProp

Properties for documents.

Column Name Type Length Description
internalDocID bigint N/A The ID of the document.
name varchar 100 Property name.
propValue varchar 3500 Property value.

top of page

jiveDocVersion

Document version table.

Column Name Type Length Description
internalDocID bigint N/A The ID of the document.
versionID int N/A The version ID.
state varchar 20 The current document state (constants defined in the application).
userID bigint N/A The user ID who created the document version.
creationDate bigint N/A The creation date of the document version.
modificationDate bigint N/A The date of the last modification to the document version.
language char 2 The language for the document version.
title varchar 255 The document title.
summary text N/A A summary for the document.
minorVersion smallint N/A Whether or not the version is a minor change to the document.

top of page

jiveDocVersionCmmt

Comments on document versions.

Column Name Type Length Description
vCommentID bigint N/A The version comment ID. Primary key.
internalDocID bigint N/A The ID of the document.
versionID int N/A The version ID.
userID bigint N/A The user ID.
creationDate bigint N/A The date the comment was created.
comments text N/A The comment's text.

top of page

jiveDraft

Draft data table.

Column Name Type Length Description
draftID bigint N/A The ID of the draft. Primary key.
draftType int N/A The type of draft.
objectType int N/A The object type the draft is associated with.
objectID bigint N/A The object ID the draft is associated with.
userID bigint N/A The ID of the user who created the draft.
subject varchar 255 The subject of the draft.
body text N/A The body of the draft.
modificationDate bigint N/A The date the draft was last modified.

top of page

jiveDraftProp

Properties for drafts.

Column Name Type Length Description
draftID bigint N/A The ID of the draft.
name varchar 100 The property name.
propValue varchar 3500 The property value.

top of page

jiveEmailToken

User email token data table.

Column Name Type Length Description
userID bigint N/A The ID of the user this token is associated with.
tokenValue int N/A The value of the email token.
tokenDate bigint N/A The date the email token was sent.

top of page

jiveField

Field data table.

Column Name Type Length Description
fieldID bigint N/A The ID of the field. Primary key.
fieldTypeID bigint N/A The ID of the field type for this field.
name varchar 100 The name of the field.
displayName varchar 100 The display name of the field.
description varchar 1000 The field's description.
defValue varchar 255 The default value for the field.
alterable smallint N/A Whether or not the field is alterable.
searchable smallint N/A Whether or not the field is searchable.
required smallint N/A Whether or not the field is required.
visible smallint N/A Whether or not the field is visible to end users.
filterable smallint N/A Whether or not the field is filterable.
maxSize int N/A The maximum size of the field.
fRowVersion bigint N/A A sequence for the field row version.

top of page

jiveFieldFrmtProp

Properties for field formatters.

Column Name Type Length Description
fieldTypeID bigint N/A The ID of the field type.
name varchar 100 The property name.
propValue varchar 3500 The property value.

top of page

jiveFieldOption

Field option data table.

Column Name Type Length Description
optionID bigint N/A The ID of the option. Primary key.
fieldID bigint N/A The field ID the option is associated with.
optionValue varchar 255 The value of the option.
optionIndex int N/A The option's index in the field.
defaultOption int N/A Whether or not the option is the default option for the field.

top of page

jiveFieldType

Document Field types.

Column Name Type Length Description
fieldTypeID bigint N/A The ID of the field type. Primary key.
name varchar 20 The name of the field type.
displayName varchar 100 The display name of the field type.
description varchar 1000 The field type's description.
dataTypeID bigint N/A The ID of the datatype for this field type.
formatter varchar 255 The classname of the formatter for this field type.
validator varchar 255 The classname of the validator for this field type.
modifiable int N/A Whether or not this field type can be modified.

top of page

jiveFieldValue

Field values.

Column Name Type Length Description
internalDocID bigint N/A The ID of the document.
versionID int N/A The ID of the document version.
fieldID bigint N/A The field ID.
numValue bigint N/A The option ID if the field is a selection.
strValue varchar 3500 The string value for the field's value if it's not a selection.

top of page

jiveFieldVldtrProp

Properties for field validators.

Column Name Type Length Description
fieldTypeID bigint N/A The ID of the field type.
name varchar 100 The property name.
propValue varchar 3500 The property value.

top of page

jiveGateway

Gateway data table.

Column Name Type Length Description
gatewayID bigint N/A The ID of the gateway. Primary key.
communityID bigint N/A The ID of the community the gateway is associated with.
gatewayType varchar 10 The type of the gateway.
importEnabled int N/A True if importing is enabled for this gateway.
exportEnabled int N/A True if exporting is enabled for this gateway.
disableCutOffDate int N/A True to disable cutoff date (date before which no messages will be imported).

top of page

jiveGatewayProp

Properties for gateways.

Column Name Type Length Description
gatewayID bigint N/A The ID of the gateway.
name varchar 100 Property name.

top of page

jiveGroup

Container table for group data.

Column Name Type Length Description
groupID bigint N/A Group ID. Primary key.
name varchar 100 Group name.
description varchar 1000 Group description.
creationDate bigint N/A Creation date.
modificationDate bigint N/A Last modified date.

top of page

jiveGroupPerm

Group permissions.

Column Name Type Length Description
objectType int N/A Object type (system, community, document).
objectID bigint N/A ID of the object referenced type the objectType column.
groupID bigint N/A Group ID.
permissionType int N/A The type of permission - additive or negative.
permission int N/A Permission value (bitmask of all permissions the group has on the object)

top of page

jiveGroupProp

Properties for groups.

Column Name Type Length Description
groupID bigint N/A Group ID.
name varchar 100 Property name.
propValue varchar 3500 Property value.

top of page

jiveGroupUser

Container table for specifying the users in a group.

Column Name Type Length Description
groupID bigint N/A Group ID.
userID bigint N/A User ID.
administrator int N/A Administrator (Boolean).

top of page

jiveID

ID Sequence table.

Column Name Type Length Description
idType int N/A ID type (for example, Discussion, Thread, Message, Group, User). Primary key.
id bigint N/A Next available block of IDs (used for database-independent ID sequence generator).

top of page

jiveImage

Image data table.

Column Name Type Length Description
imageID bigint N/A The ID of the image. Primary key.
objectType int N/A The object type of the object associated with the image.
objectID bigint N/A The object ID of the object associated with the image.
fileName varchar 255 The file name of the image.
fileSize int N/A The size of the image in bytes.
contentType varchar 50 The MIME type of the image.
creationDate bigint N/A The date the image was created.
modificationDate bigint N/A The date the image was last modified.

top of page

jiveImageData

Image data.

Column Name Type Length Description
imageID bigint N/A The ID of the image. Primary key.
imageData blob N/A The binary image data.

top of page

jiveImageVersion

Version table for document images.

Column Name Type Length Description
imageID bigint N/A The ID of the image.
internalDocID bigint N/A The ID of the document.
versionID int N/A The ID of the document version.

top of page

jiveLabelElement

Label elements.

Column Name Type Length Description
elementID bigint N/A The ID of the element.
documentTypeID bigint N/A The ID of the document type.
value varchar 255 The label's value.

top of page

jiveLinkObject

Link data table.

Column Name Type Length Description
linkKey varchar 255 The link key. Primary key.
objectType int N/A The object type for the link.
objectID bigint N/A The object ID for the link.

top of page

jiveLocalizedProp

Localized system wide Jive properties.

Column Name Type Length Description
name varchar 100 The name of the property.
propValue text N/A The value of the property.
locale varchar 100 The locale code of the property.

top of page

jiveMessage

Container data for forum message data.

Column Name Type Length Description
messageID bigint N/A Message ID. Primary key.
parentMessageID bigint N/A Parent message ID.
threadID bigint N/A ID of thread to which message belongs.
communityID bigint N/A ID of community to which message belongs.
communityIndex int N/A An increasing sequence value for messages in the community; primarily used for NNTP.
userID bigint N/A User ID of message's author.
subject varchar 255 Subject of message.
body text N/A Message body.
modValue int N/A Moderation value of message.
rewardPoints int N/A Reward points for message (used for incentive schemes for posting).
creationDate bigint N/A Creation date.
modificationDate bigint N/A Last modified date.

top of page

jiveMessageProp

Properties for messages.

Column Name Type Length Description
messageID bigint N/A Message ID.
name varchar 100 Property name.
propValue varchar 3500 Property value.

top of page

jiveModeration

Audit table for moderation events.

Column Name Type Length Description
objectType int N/A Object Type (for example, Message, Thread).
objectID bigint N/A Object ID of object which has had a change in moderation value.
userID bigint N/A User ID of user who made moderation decision.
modDate bigint N/A Date of modification/decision.
modValue bigint N/A Resulting moderation value.

top of page

jiveObjectTag

Tag/object association table.

Column Name Type Length Description
objectType int N/A The object type associated with the tag.
objectID bigint N/A The ID of the object associated with the tag.
tagID bigint N/A The ID of the tag.
creationDate bigint N/A The creation date of the tag.

top of page

jivePMessage

Container table for private message data.

Column Name Type Length Description
pMessageID bigint N/A Private message ID. Primary key.
ownerID bigint N/A The user whose mailbox the private message is in. For example, the ownerID is different from the recipient ID when the message is a draft.
senderID bigint N/A The user who sent the private message.
recipientID bigint N/A The user who received the private message.
subject varchar 255 The subject of the private message.
body text N/A The body of the private message.
readStatus smallint N/A The read status - read or unread.
folderID bigint N/A The ID of the folder the message lives in.
pMessageDate bigint N/A The private message creation date.

top of page

jivePMessageFldr

Private message folders.

Column Name Type Length Description
folderID bigint N/A Private message folder ID.
userID bigint N/A Owner of the folder.
name varchar 255 Name of the folder.

top of page

jivePMessageProp

Properties for private messages.

Column Name Type Length Description
pMessageID bigint N/A Private message ID.
name varchar 100 Property name.
propValue varchar 3500 Property value.

top of page

jivePoll

Poll data table.

Column Name Type Length Description
pollID bigint N/A Poll ID. Primary key.
objectType int N/A Object type associated with the poll.
objectID bigint N/A Object ID the poll is associated with.
userID bigint N/A The user who posted the poll or NULL if it was anonymous.
name varchar 255 Poll name.
description varchar 1000 Poll description.
pollMode bigint N/A A mask for various poll options.
creationDate bigint N/A Creation date.
modificationDate bigint N/A Last modified date.
startDate bigint N/A The date the poll becomes active.
endDate bigint N/A The date the poll becomes inactive.
expireDate bigint N/A The date the poll will be deleted from the system.

top of page

jivePollOption

Poll options table.

Column Name Type Length Description
pollID bigint N/A Poll ID.
optionIndex int N/A The index of the poll option for ordering.
optionText varchar 255 The name of the option.

top of page

jivePollVote

Poll vote data table.

Column Name Type Length Description
pollID bigint N/A Poll ID.
userID bigint N/A The user who voted.
guestID varchar 255 A unique identifier for a guest to prevent double voting.
optionIndex int N/A The index of the option the poll is tied to.
voteDate bigint N/A The date the vote was made.

top of page

jivePresenter

Presention information data table.

Column Name Type Length Description
presenterID bigint N/A The ID of the presenter. Primary key.
name varchar 100 The name of the presenter.
template text N/A The file template for this presenter.
modificationDate bigint N/A The date this presenter was last modified.

top of page

jiveProfileField

Profile field data table.

Column Name Type Length Description
fieldID bigint N/A The ID of the field. Primary key.
name varchar 255 The name of the field.
description varchar 1000 The description of the field.
isRequired smallint N/A Whether or not the field is required.
isFilterable smallint N/A Whether or not the field is filterable.
isSearchable smallint N/A Whether or not the field is searchable.
isVisible smallint N/A Whether or not the field is visible.
isEditable smallint N/A Whether or not the field is editable.
fieldType int N/A The type of field.
idx int N/A The index of the field in the field list.

top of page

jiveProfileFldOpt

Profile field option data table.

Column Name Type Length Description
fieldID bigint N/A The ID of the field.
fieldValue varchar 255 The value of the option.
idx int N/A The index of the option in the option list.
defaultOption smallint N/A The default option index.

top of page

jiveProperty

System wide Jive properties.

Column Name Type Length Description
name varchar 100 Property name. Primary key.
propValue varchar 3500 Property value.

top of page

jiveQuestion

Question data table.

Column Name Type Length Description
threadID bigint N/A ID of the thread associated with this thread. Primary key.
communityID bigint N/A The ID of the community the question is in.
userID bigint N/A The user who created the question.
creationDate bigint N/A Creation date of the question.
resolutionDate bigint N/A The date the question was resolved (can be NULL).
resolutionState int N/A The state the question is in.

top of page

jiveQuestionProp

Properties for questions.

Column Name Type Length Description
threadID bigint N/A Question ID.
name varchar 100 Property name.
propValue varchar 3500 Property value.

top of page

jiveRating

Rating data table.

Column Name Type Length Description
objectID bigint N/A ID of the object the rating is associated with.
objectType int N/A Type of object the rating is associated with.
userID bigint N/A The user making the rating.
score int N/A The score of the rating.

top of page

jiveRatingType

Rating types.

Column Name Type Length Description
score int N/A The score value of the rating. Primary key.
description varchar 1000 The description of the rating; for example, "Helpful".

top of page

jiveReadTracker

Read tracking data table.

Column Name Type Length Description
userID bigint N/A User ID of reader. Primary key.
objectType int N/A Type of Object read (thread, message, etc.). Primary key.
objectID bigint N/A ID of object read. Primary key.
readDate bigint N/A Date read.

top of page

jiveSearch

Search logging data table.

Column Name Type Length Description
searchID bigint N/A Search ID. Primary key.
userID bigint N/A ID of the user initiating the search.
query varchar 3500 The search query that was executed.
searchDuration int N/A Time in milliseconds of search execution.
numResults int N/A The number of search results returned.
searchDate bigint N/A The date the search was made.

top of page

jiveSearchClick

Search result clickthrough tracking table.

Column Name Type Length Description
searchID bigint N/A Search ID.
objectType bigint N/A Object type clicked through to.
objectID bigint N/A Object ID clicked through to.
clickDate bigint N/A The date the result was clicked.

top of page

jiveSearchCriteria

Search criteria data table.

Column Name Type Length Description
searchID bigint N/A Search ID.
criteriaName varchar 100 The name of the search criteria.
criteriaValue varchar 3500 The value of the search criteria.

top of page

jiveSectionElement

Section elements.

Column Name Type Length Description
elementID bigint N/A The ID of the element.
parentID bigint N/A The ID of the parent element.
documentTypeID bigint N/A The ID of the document type.
elementTypeID bigint N/A The ID of the element type.
elementIndex int N/A The index of the element.

top of page

jiveStat

Statistics.

Column Name Type Length Description
statID bigint N/A The ID of the statistic.
communityID bigint N/A The ID of the community.
statDate bigint N/A The statistic date.
statValue float N/A The statistic value.

top of page

jiveStatLvlScen

Status level scenarios.

Column Name Type Length Description
scenarioID bigint N/A The ID of the scenario. Primary key.
i18nKey varchar 100 The i18n key for the scenario.
points bigint N/A Points.
enabled smallint N/A Whether or not the scenario is enabled.

top of page

jiveStatusLevel

Status levels.

Column Name Type Length Description
statusLevelID bigint N/A ID of the status level. Primary key.
name varchar 255 Status level name.
description varchar 1000 Status level description.
imagePath varchar 255 Path to an image for this status level (not null).
largeImagePath varchar 255 Path to a large image for this status level (null).
minPoints int N/A The minimum points for this status level.
maxPoints int N/A The minimum points for this status level.
groupID bigint N/A The ID of the group associated with this status level.

top of page

jiveStatusLevelPnt

Status level points.

Column Name Type Length Description
pointID bigint N/A The ID of the point. Primary key.
userID bigint N/A The user ID for the point.
communityID bigint N/A The community ID associated with the point.
points bigint N/A Points.
objectType int N/A The object type associated with the point.
objectID bigint N/A The object ID associated with the point.
creationDate bigint N/A The creation date of the point.

top of page

jiveTag

Tag data table.

Column Name Type Length Description
tagID bigint N/A The ID of the tag. Primary key.
tagname varchar 100 The name of the tag.
creationDate bigint N/A The creation date of the tag.

top of page

jiveTagSet

Tag set data table.

Column Name Type Length Description
tagSetID bigint N/A The ID of the tag set. Primary key.
name varchar 100 The name of the tag set.
description varchar 1000 A description for the tag set.
creationDate bigint N/A The date the tag set was created.
modificationDate bigint N/A The date the tag set was last modified.
communityID bigint N/A The ID of the community associated with the tag set.

top of page

jiveTagSetMap

Association table for tag sets and tags.

Column Name Type Length Description
tagSetID bigint N/A The ID of the tag set.
tagID bigint N/A The ID of the tag.

top of page

jiveThemeMap

Mapping table for theme mapping data.

Column Name Type Length Description
theme varchar 32 The name of the theme.
mapType varchar 16 The type of mapping this is (constants defined in application).
numValue bigint N/A The ID mapping (if it's a discussion or community type theme).
stringValue varchar 100 The value of the mapping (if this is a URL or locale type theme).

top of page

jiveThread

Container table for forum thread data.

Column Name Type Length Description
threadID bigint N/A Thread ID. Primary key.
communityID bigint N/A ID of the community that the thread belongs to.
rootMessageID bigint N/A ID of root message in the thread.
modValue int N/A Moderation value of thread.
rewardPoints int N/A Reward points available in this thread.
creationDate bigint N/A Creation date.
modificationDate bigint N/A Last modified date.

top of page

jiveThreadProp

Properties for threads.

Column Name Type Length Description
threadID bigint N/A Thread ID.
name varchar 100 Property name.
propValue varchar 3500 Property value.

top of page

jiveTrackback

Trackback data table for blogs.

Column Name Type Length Description
trackbackID bigint N/A The ID of the trackback. Primary key.
title varchar 100 The title of the trackback.
excerpt text N/A The excerpt of a external trackback.
objectType int N/A The object type the trackback is associated with.
objectID bigint N/A The ID of the object the trackback is associated with.
parentObjectType int N/A The object type of the parent object to the object the trackback is associated with.
parentObjectID bigint N/A The ID of the parent object to the object the trackback is associated with.
url varchar 100 The trackback URL.
senderName varchar 100 The sender's name (external trackbacks only).
ip varchar 15 The IP of the person who created the trackback.
moderated smallint N/A Whether or not the trackback is moderated.
creationDate bigint N/A The creation date of the trackback.
modificationDate bigint N/A The modification date of the trackback.

top of page

jiveTrackbackProp

Properties for trackbacks.

Column Name Type Length Description
trackbackID bigint N/A The ID of the trackback.
name varchar 100 Property name.
propValue varchar 3500 Property value.

top of page

jiveTypeVldtrProp

Properties for document type validators.

Column Name Type Length Description
typeID bigint N/A The ID of the document type.
name varchar 100 Property name.
propValue varchar 3500 Property value.

top of page

jiveUser

Container table for user data.

Column Name Type Length Description
userID bigint N/A User ID. Primary key.
username varchar 30 User name.
passwordHash varchar 32 Password Data (hex-encoded MD5 hash of actual password).
name varchar 100 Full name.
nameVisible int N/A Privacy flag for showing name to other users (Boolean).
email varchar 100 Email address.
emailVisible int N/A Privacy flag for showing email to other users (Boolean).
creationDate bigint N/A Creation date.
modificationDate bigint N/A Last modified date.

top of page

jiveUserIMHandle

User IM handles.

Column Name Type Length Description
userID bigint N/A The user ID.
imHandle varchar 100 The IM handle for the user.
imType int N/A The type of IM.

top of page

jiveUserPerm

User permissions.

Column Name Type Length Description
objectType int N/A Type of object (system, community, document).
objectID bigint N/A ID of the object being referenced by the objectType column.
userID bigint N/A The ID of the user being granted the permission.
permissionType int N/A Indicates the type of permission - additive or negative.
permission int N/A Bitmask of permissions the user has on the object.

top of page

jiveUserProfile

User profile data table.

Column Name Type Length Description
userID bigint N/A The ID if the user this profile is associated with.
fieldID bigint N/A The ID of the field.
value varchar 3500 The value set for the field.

top of page

jiveUserProp

Properties for users.

Column Name Type Length Description
userID bigint N/A User ID.
name varchar 100 Property name.
propValue varchar 3500 Property value.

top of page

jiveUserRoster

User Rosters.

Column Name Type Length Description
userID bigint N/A User ID.
subUserID bigint N/A User ID of roster member.

top of page

jiveVersion

Version data table.

Column Name Type Length Description
name varchar 50 The name of the version key. Primary key.
version int N/A The latest version number this instance is up to.

top of page

jiveViewCount

Object view counts.

Column Name Type Length Description
objectType int N/A The type of the object.
objectID bigint N/A ID of the object.
parentObjectID bigint N/A ID of the object that this object "belongs" to. For example, a thread belongs to a discussion, a discussion community belongs to a category, etc.
viewCount int N/A Number of times the object has been read.

top of page

jiveWatch

Container table for user watch data.

Column Name Type Length Description
userID bigint N/A ID of user who is watching.
objectType int N/A The type of the object being watched (discussion, thread, community, user).
objectID bigint N/A ID of the object being watched.
watchType int N/A Type of watch (normal watch, email watch, batch email watch).
expirable smallint N/A Flag to indicate if the watch be automatically deleted/expired (Boolean).

top of page

jiveWatchSettings

Watch settings data table.

Column Name Type Length Description
userID bigint N/A The ID of the user these settings relate to. Primary key.
autoWatchNewTopics smallint N/A Whether or not to automatically watch new topics.
autoWatchReplies smallint N/A Whether or not to automatically watch topics you reply to.
receiveEmails smallint N/A Whether or not emails are received from watches.
batchFrequency smallint N/A The frequency at which batch watches are sent (constant defined in the application).
lastBatchEmail bigint N/A The time the last batch watch email was sent.

top of page

jiveWikiLink

Wiki link tracking table.

Column Name Type Length Description
objectType int N/A The object type containing the link.
objectID bigint N/A The object ID containing the link.
targetLinkType int N/A The target link type (Constants defined in the application).
targetObjectType int N/A The link target object type.
targetObjectID bigint N/A The link target object ID.
targetAttachmentID bigint N/A The target attachment ID.
targetURL varchar 255 The target URL.
targetText varchar 255 The link text.
targetDescription varchar 255 The link description.
targetAnchorText varchar 255 The target anchor text.

top of page

Entity Relationship Illustration

The following diagrams illustrate relationships between tables where primary/foreign key relationships exist. Tables not connect through such relationships were omitted from the diagrams.