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.
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.
jiveBlogToUser	Blog/user association table.
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.
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.
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.
jiveOSPropEntry	OSWorkflow property table.
jivePCheckPoint	Container table for work space checkPoint data.
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
jiveProperty	System wide Jive properties.
jivePTask	Container table for work space data.
jivePTaskProp	Properties for work space checkPoints
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.
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.
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
jiveUsrRelGrApr	A set of users who approve all new graph relationships.
jiveUsrRelGrNtf	A set of users who are notified of graph relationship changes.
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.
messageID	bigint	N/A	false		The ID of the abusive message.
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.
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.
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.
containerBlog	smallint	N/A	true		Whether or not this blog is a container blog.
creationDate	bigint	N/A	false		The date the blog was created.
description	varchar	1000	true	true	The description of the blog.
displayName	varchar	255	false	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

jiveBlogToUser

Blog/user association table.

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

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.
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

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.

Top of the page

jiveDocVersion

Document version table.

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

Top of the page

jiveDocVersionCmmt

Comments on document versions.

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

Top of the page

jiveDraft

Draft data table.

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

Top of the page

jiveDraftImage

Draft/Image assocation table

Column Name	Type	Length	Nullable	Unicode	Description
draftID	bigint	N/A	false		The ID of the draft. Primary key.
imageID	bigint	N/A	false		The ID of the image. Primary key.

Top of the page

jiveDraftProp

Properties for drafts.

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

Top of the page

jiveEmailToken

User email token data table.

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

Top of the page

jiveField

Field data table.

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

Top of the page

jiveFieldFrmtProp

Properties for field formatters.

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

Top of the page

jiveFieldOption

Field option data table.

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

Top of the page

jiveFieldType

Document Field types.

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

Top of the page

jiveFieldValue

Field values.

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

Top of the page

jiveFieldVldtrProp

Properties for field validators.

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

Top of the page

jiveGateway

Gateway data table.

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

Top of the page

jiveGatewayProp

Properties for gateways.

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

Top of the page

jiveGroup

Container table for group data.

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

Top of the page

jiveGroupPerm

Group permissions.

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

Top of the page

jiveGroupProp

Properties for groups.

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

Top of the page

jiveGroupUser

Container table for specifying the users in a group.

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

Top of the page

jiveID

ID Sequence table.

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

Top of the page

jiveImage

Image data table.

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

Top of the page

jiveImageData

Image data.

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

Top of the page

jiveImageVersion

Version table for document images.

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

Top of the page

jiveLabelElement

Label 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.
value	varchar	255	true	true	The label's value.

Top of the page

jiveLinkObject

Link data table.

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

Top of the page

jiveLocalizedProp

Localized system wide Jive properties.

Column Name	Type	Length	Nullable	Unicode	Description
locale	varchar	100	false		The locale code of the property. Primary key.
name	varchar	100	false	true	The name of the property. Primary key.
propValue	text	N/A	false	true	The value of the property.

Top of the page

jiveMessage

Container data for forum message data.

Column Name	Type	Length	Nullable	Unicode	Description
body	text	N/A	true	true	Message body.
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		Creation date.
messageID	bigint	N/A	false		Message ID. Primary key.
modificationDate	bigint	N/A	false		Last modified date.
modValue	int	N/A	false		Moderation value of message.
parentMessageID	bigint	N/A	true		Parent message ID.
rewardPoints	int	N/A	false		Reward points for message (used for incentive schemes for posting).
subject	varchar	255	true	true	Subject of message.
threadID	bigint	N/A	false		ID of thread to which message belongs.
userID	bigint	N/A	true		User ID of message's author.

Top of the page

jiveMessageProp

Properties for messages.

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

Top of the page

jiveModeration

Audit table for moderation events.

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

Top of the page

jiveObjectTag

Tag/object association table.

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

Top of the page

jiveOSPropEntry

OSWorkflow property table.

Column Name	Type	Length	Nullable	Unicode	Description
dataValue	blob	N/A	true
dateValue	bigint	N/A	true
floatValue	float	N/A	true
globalKey	varchar	150	true	true
itemKey	varchar	150	true	true
itemType	int	N/A	true
numberValue	bigint	N/A	true
stringValue	varchar	255	true	true

Top of the page

jivePCheckPoint

Container table for work space checkPoint data.

Column Name	Type	Length	Nullable	Unicode	Description
checkPointID	bigint	N/A	false		Project Check Point ID. Primary key.
creationDate	bigint	N/A	false		Create date of checkPoint.
description	varchar	1000	true	true	Check Points's description.
dueDate	bigint	N/A	false		Due date of the checkPoint.
modificationDate	bigint	N/A	false		Last modification date of checkPoint.
name	varchar	255	false	true	Check Point's name.
projectID	bigint	N/A	false		Project ID.

Top of the page

jivePluginProp

A table that contents contains custom properties stored for plugins

Column Name	Type	Length	Nullable	Unicode	Description
pluginName	varchar	100	false		The name of the plugin Primary key.
propName	varchar	100	false		The name of the property Primary key.
propValue	varchar	3500	false		The value of the property

Top of the page

jivePMessage

Container table for private message data.

Column Name	Type	Length	Nullable	Unicode	Description
body	text	N/A	true	true	The body of the private message.
folderID	bigint	N/A	false		The ID of the folder the message lives in.
ownerID	bigint	N/A	false		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.
pMessageDate	bigint	N/A	false		The private message creation date.
pMessageID	bigint	N/A	false		Private message ID. Primary key.
readStatus	smallint	N/A	false		The read status -- read or unread.
recipientID	bigint	N/A	true		The user who received the private message.
senderID	bigint	N/A	true		The user who sent the private message.
subject	varchar	255	true	true	The subject of the private message.

Top of the page

jivePMessageFldr

Private message folders.

Column Name	Type	Length	Nullable	Unicode	Description
folderID	bigint	N/A	false		Private message folder ID. Primary key.
name	varchar	255	true		Name of the folder.
userID	bigint	N/A	false		Owner of the folder. Primary key.

Top of the page

jivePMessageProp

Properties for private messages.

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

Top of the page

jivePoll

Poll data table.

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

Top of the page

jivePollOption

Poll options table.

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

Top of the page

jivePollVote

Poll vote data table.

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

Top of the page

jivePopularity

A table that stores archived content popularity scores for generating popular content

Column Name	Type	Length	Nullable	Unicode	Description
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 the activity score was calculated.
objectID	bigint	N/A	false		The ID of the activity object.
objectType	int	N/A	false		The type of the activity object.
popularityID	bigint	N/A	false		The primary key of the popularity entry. Primary key.
score	int	N/A	false		The calculated popularity score based off current activity.

Top of the page

jivePresenter

Presention information data table.

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

Top of the page

jiveProfileField

Profile field data table.

Column Name	Type	Length	Nullable	Unicode	Description
description	varchar	1000	true	true	The description of the field.
extManaged	smallint	N/A	false		Whether or not the field data is managed by an external system
extMapping	varchar	2048	true		Config string used to look up field value in an external system
fieldID	bigint	N/A	false		The ID of the field. Primary key.
fieldType	int	N/A	false		The type of field.
idx	int	N/A	false		The index of the field in the field list.
isDefault	smallint	N/A	false		Whether or not the field is a default field
isEditable	smallint	N/A	false		Whether or not the field is editable.
isFilterable	smallint	N/A	false		Whether or not the field is filterable.
isList	smallint	N/A	false		Whether values are lists
isRequired	smallint	N/A	false		Whether or not the field is required.
isSearchable	smallint	N/A	false		Whether or not the field is searchable.
isVisible	smallint	N/A	false		Whether or not the field is visible.
name	varchar	255	false	true	The name of the field.

Top of the page

jiveProfileFldOpt

Profile field option data table.

Column Name	Type	Length	Nullable	Unicode	Description
defaultOption	smallint	N/A	false		Whether or not the option is the default option.
fieldID	bigint	N/A	false		The ID of the field.
fieldValue	varchar	255	false	true	The value of the option.
idx	int	N/A	false		The index of the option in the option list.

Top of the page

jiveProject

Container table for work space data.

Column Name	Type	Length	Nullable	Unicode	Description
creationDate	bigint	N/A	false		Create date of Project.
description	varchar	1000	true	true	Project description.
dueDate	bigint	N/A	true		Due date of the Project.
dueDateNull	int	N/A	false		Whether the project has a due date or not.
modificationDate	bigint	N/A	false		Last modification date of Project.
name	varchar	255	false	true	Project name.
parentObjectID	bigint	N/A	false		The ID of the parent object of the work space.
parentObjectType	int	N/A	false		The type of the parent object of the work space.
projectID	bigint	N/A	false		Project ID. Primary key.
userID	bigint	N/A	false		The ID of the user that created the project.

Top of the page

jiveProjectProp

Properties for work spaces

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

Top of the page

jiveProperty

System wide Jive properties.

Column Name	Type	Length	Nullable	Unicode	Description
name	varchar	255	false	true	Property name. Primary key.
propValue	varchar	3500	false	true	Property value.

Top of the page

jivePTask

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.

Top of the page

jivePTaskProp

Properties for work space checkPoints

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

Top of the page

jiveQuestion

Question data table.

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

Top of the page

jiveQuestionProp

Properties for questions.

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

Top of the page

jiveRating

Rating data table.

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

Top of the page

jiveRatingType

Rating types.

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

Top of the page

jiveReadTracker

Read tracking data table.

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

Top of the page

jiveReference

Jive Reference Table

Column Name	Type	Length	Nullable	Unicode	Description
referenceID	bigint	N/A	false		The jiveReference id. Primary key.
refererObjectID	bigint	N/A	false		The refer's object id.
refererObjectType	smallint	N/A	false		The refer's object type.
refObjectID	bigint	N/A	false		The reference's object id.
refObjectType	smallint	N/A	false		The reference's object type.

Top of the page

jiveSearch

Search logging data table.

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

Top of the page

jiveSearchClick

Search result clickthrough tracking table.

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

Top of the page

jiveSearchCriteria

Search criteria data table.

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

Top of the page

jiveSearchEngine

Installed OpenSearch engine information

Column Name	Type	Length	Nullable	Unicode	Description
authenticated	smallint	N/A	false		Whether or not the search engine requires authentication.
description	varchar	2000	true	true	A description of the engine.
descriptorURL	varchar	2000	true	true	The URL of the search engine's OpenSearch descriptor file.
enabled	int	N/A	false		One if the search engine is enabled, zero if it is disabled (does not show up to the end user).
engineID	bigint	N/A	false		Installed OpenSearch Engine ID. Primary key.
externalSearchURL	varchar	2000	false	true	The external URL to search against.
iconURL	varchar	2000	true	true	The URL of the search engine's icon.
maxResultCount	int	4	false	true	The maximum number of results to return.
password	varchar	40	true	true	A password, if the search engine requires authentication.
queryTestTerm	varchar	40	true	true	A search term to test query capabilities.
searchContentType	varchar	100	true	true	The content type of the results returned by a search.
searchHttpMethod	varchar	10	true	true	The HTTP method of the search.
searchURL	varchar	2000	false	true	The URL to search against.
shortName	varchar	255	false	true	The short name of the engine.
username	varchar	40	true	true	A username, if the search engine requires authentication.

Top of the page

jiveSectionElement

Section 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.
parentID	bigint	N/A	false		The ID of the parent element. Primary key.

Top of the page

jiveShare

Jive Artifact Sharing Information

Column Name	Type	Length	Nullable	Unicode	Description
createdBy	bigint	N/A	false
creationDate	bigint	N/A	true
jiveObjectId	bigint	N/A	false		The unique ID of the jive object being shared
jiveObjectType	smallint	N/A	false
modificationDate	bigint	N/A	true
shareEnd	bigint	N/A	false
shareID	bigint	N/A	false		Unique ID for the share Primary key.
shareStart	bigint	N/A	false
shareState	smallint	N/A	false
updatedBy	bigint	N/A	false

Top of the page

jiveStat

Statistics.

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

Top of the page

jiveStatLvlScen

Status level scenarios.

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

Top of the page

jiveStatusLevel

Status levels.

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

Top of the page

jiveStatusLevelPnt

Status level points.

Column Name	Type	Length	Nullable	Unicode	Description
code	varchar	20	false	true
containerID	bigint	N/A	false		The container ID associated with the point.
containerType	smallint	N/A	false		The container type associated with the point.
creationDate	bigint	N/A	false		The creation date of the point.
objectID	bigint	N/A	false		The object ID associated with the point.
objectType	int	N/A	false		The object type associated with the point.
pointID	bigint	N/A	false		The ID of the point. Primary key.
points	bigint	N/A	false		Points.
userID	bigint	N/A	false		The user ID for the point.

Top of the page

jiveTag

Tag data table.

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

Top of the page

jiveTagSet

Tag set data table.

Column Name	Type	Length	Nullable	Unicode	Description
containerID	bigint	N/A	false		The ID of the container associated with the tag set.
containerType	int	N/A	false		The type of the container associated with the tag set.
creationDate	bigint	N/A	false		The date the tag set was created.
description	varchar	1000	true	true	A description for the tag set.
modificationDate	bigint	N/A	false		The date the tag set was last modified.
name	varchar	100	false	true	The name of the tag set.
tagSetID	bigint	N/A	false		The ID of the tag set. Primary key.

Top of the page

jiveTagSetMap

Association table for tag sets and tags.

Column Name	Type	Length	Nullable	Unicode	Description
tagID	bigint	N/A	false		The ID of the tag. Primary key.
tagSetID	bigint	N/A	false		The ID of the tag set. Primary key.

Top of the page

jiveThemeMap

Mapping table for theme mapping data.

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

Top of the page

jiveThread

Container table for forum thread data.

Column Name	Type	Length	Nullable	Unicode	Description
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		Creation date.
modificationDate	bigint	N/A	false		Last modified date.
modValue	int	N/A	false		Moderation value of thread.
rewardPoints	int	N/A	false		Reward points available in this thread.
rootMessageID	bigint	N/A	false		ID of root message in the thread.
threadID	bigint	N/A	false		Thread ID. Primary key.

Top of the page

jiveThreadProp

Properties for threads.

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

Top of the page

jiveTrackback

Trackback data table for blogs.

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

Top of the page

jiveTrackbackProp

Properties for trackbacks.

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

Top of the page

jiveTypeVldtrProp

Properties for document type validators.

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

Top of the page

jiveUser

Container table for user data.

Column Name	Type	Length	Nullable	Unicode	Description
creationDate	bigint	N/A	false		Creation date.
email	varchar	100	false		Email address.
emailVisible	int	N/A	false		Privacy flag for showing email to other users (Boolean).
federated	int	N/A	false		Indicates if the system of record is outside clearspace
isExternal	int	N/A	false		Indicates if a user is external to the system and this account is simply a place holder
lastLoggedIn	bigint	N/A	false		Last time the user logged in.
modificationDate	bigint	N/A	false		Last modified date.
name	varchar	100	true	true	Full name.
nameVisible	int	N/A	false		Privacy flag for showing name to other users (Boolean).
passwordHash	varchar	64	false		AES-265 One-way hash of the user password and salt.
userEnabled	int	N/A	false		Whether the current user is enabled or not.
userID	bigint	N/A	false		User ID. Primary key.
username	varchar	100	false	true	User name.
visible	int	N/A	false		Indicates if the user will be in a search result or not

Top of the page

jiveUserIMHandle

User IM handles.

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

Top of the page

jiveUserPerm

User permissions.

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

Top of the page

jiveUserProfile

User profile data table.

Column Name	Type	Length	Nullable	Unicode	Description
fieldID	bigint	N/A	false		The ID of the field.
primaryVal	smallint	N/A	false		Whether or not this value is the primary value in a list
userID	bigint	N/A	false		The ID if the user this profile is associated with.
value	varchar	3500	true	true	The value set for the field.

Top of the page

jiveUserProp

Properties for users.

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

Top of the page

jiveUserRel

Historical relationships between users

Column Name	Type	Length	Nullable	Unicode	Description
creationDate	bigint	N/A	false		The timestamp when a relation was created.
graphID	bigint	N/A	false		The ID of a relationship's graph.
relatedUserID	bigint	N/A	false		User ID of the object of the relationship.
relationshipID	bigint	N/A	false		The relationship ID. Primary key.
relnshipTypeID	int	1	false		The UserRelationship.RelationshipType of how the subject is related to the object.
retirementDate	bigint	N/A	true		The timestamp when a relation was retired - null if active.
state	varchar	20	false		The UserRelationship.RelationshipState of the relationship.
userID	bigint	N/A	false		User ID of the subject of the relationship.
workflowID	bigint	N/A	true		The ID of the approval workflow associated with this relationship.

Top of the page

jiveUserRelGraph

A container for a set of relationships.

Column Name	Type	Length	Nullable	Unicode	Description
approvalsEnabled	smallint	N/A	false		Whether of not use approval workflow.
drptChoiceAllowed	smallint	N/A	false		Can direct reports be chosen.
enabled	smallint	N/A	false		Whether of not the graph is enabled (globally visible to end users).
graphID	bigint	N/A	false		The relationship graph ID. Primary key.
graphTypeID	int	N/A	false		The relationship graph type (Hierarchical or Mesh).
labelDirRpt	varchar	40	true	true	The label for a direct report.
labelManager	varchar	40	true	true	The label for a manager.
labelPeer	varchar	40	true	true	The label for a peer.
mgrChoiceAllowed	smallint	N/A	false		Can managers be chosen.
name	varchar	255	false	true	The name of the graph.
peerChoiceAllowed	smallint	N/A	false		Can peers be chosen.

Top of the page

jiveUserRoster

User Rosters.

Column Name	Type	Length	Nullable	Unicode	Description
subUserID	bigint	N/A	false		User ID of roster member. Primary key.
userID	bigint	N/A	false		User ID. Primary key.

Top of the page

jiveUserStatus

User status information

Column Name	Type	Length	Nullable	Unicode	Description
creationDate	bigint	N/A	false		The timestamp of status update.
userID	bigint	N/A	false		User ID.
userStatusID	bigint	N/A	false		User Status ID. Primary key.
userStatusText	varchar	512	false	true	User Status text.

Top of the page

jiveUsrRelGrApr

A set of users who approve all new graph relationships.

Column Name	Type	Length	Nullable	Unicode	Description
graphID	bigint	N/A	false		The relationship graph ID.
userID	bigint	N/A	false		User ID.

Top of the page

jiveUsrRelGrNtf

A set of users who are notified of graph relationship changes.

Column Name	Type	Length	Nullable	Unicode	Description
graphID	bigint	N/A	false		The relationship graph ID.
userID	bigint	N/A	false		User ID.

Top of the page

jiveVersion

Version data table.

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

Top of the page

jiveViewCount

Object view counts.

Column Name	Type	Length	Nullable	Unicode	Description
objectID	bigint	N/A	false		ID of the object. Primary key.
objectType	int	N/A	false		The type of the object. Primary key.
parentObjectID	bigint	N/A	true		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	true		Number of times the object has been read.

Top of the page

jiveWatch

Container table for user watch data.

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

Top of the page

jiveWatchSettings

Watch settings data table.

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

Top of the page

jiveWFCurrentStep

OSWorkflow workflow current step table.

Column Name	Type	Length	Nullable	Unicode	Description
actionID	smallint	N/A	true
caller	varchar	20	true
dueDate	timestamp	N/A	true
entryID	bigint	N/A	true
finishDate	timestamp	N/A	true
id	bigint	N/A	false		Primary key.
owner	varchar	20	true	true
startDate	timestamp	N/A	true
status	varchar	20	true
stepID	smallint	N/A	true

Top of the page

jiveWFCurrStepPrev

OSWorkflow previous workflow step table.

Column Name	Type	Length	Nullable	Unicode	Description
id	bigint	N/A	false		Primary key.
previousID	bigint	N/A	false		Primary key.

Top of the page

jiveWFEntry

OSWorkflow entry table.

Column Name	Type	Length	Nullable	Unicode	Description
id	bigint	N/A	false		Primary key.
name	varchar	20	true	true
state	int	N/A	true

Top of the page

jiveWFHistoryStep

OSWorkflow workflow history table.

Column Name	Type	Length	Nullable	Unicode	Description
actionID	int	N/A	true
caller	varchar	20	true	true
dueDate	timestamp	N/A	true
entryID	bigint	N/A	true
finishDate	timestamp	N/A	true
id	bigint	N/A	false		Primary key.
owner	varchar	20	true	true
startDate	timestamp	N/A	true
status	varchar	20	true	true
stepID	int	N/A	true

Top of the page

jiveWFHistStepPrev

OSWorkflow history step table.

Column Name	Type	Length	Nullable	Unicode	Description
id	bigint	N/A	false		Primary key.
previousID	bigint	N/A	false		Primary key.

Top of the page

jiveWidget

Installed widget information

Column Name	Type	Length	Nullable	Unicode	Description
className	varchar	255	false	true	The className of the installed widget.
widgetID	bigint	N/A	false		Installed Widget ID. Primary key.

Top of the page

jiveWidgetFrame

Container table for Widget frames

Column Name	Type	Length	Nullable	Unicode	Description
containerID	int	N/A	false		Container ID holding the widget frame.
frameID	bigint	N/A	false		Widget Frame ID. Primary key.
frameIndex	int	N/A	false		Index of the widget frame within the container.
parentObjectID	bigint	N/A	false		Parent object ID the widget frame is associated with.
parentObjectType	int	N/A	false		Parent object type associated with the widget frame.
published	int	N/A	false		One if the widget frame is published, otherwise it is draft.
widgetID	bigint	N/A	false		Widget ID.

Top of the page

jiveWidgetFrmProp

Properties for widget frames

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

Top of the page

jiveWikiLink

Wiki link tracking table.

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

Top of the page

jiveWLayout

Installed widget layout information

Column Name	Type	Length	Nullable	Unicode	Description
className	varchar	255	false	true	The className of the installed widget layout.
disabled	int	N/A	false		True if the layout is disabled, false otherwise.
layoutID	bigint	N/A	false		Installed Widget Layout ID. Primary key.

Top of the page

jiveWLayoutFrame

Container table for Widget Layout frames

Column Name	Type	Length	Nullable	Unicode	Description
layoutID	bigint	N/A	false		Widget layout ID.
parentObjectID	bigint	N/A	false		Parent object ID the widget layout is associated with. Primary key.
parentObjectType	int	N/A	false		Parent object type associated with the widget layout. Primary key.
published	int	N/A	false		One if the widget layout is published, otherwise it is draft. Primary key.

Top of the page