Documentation : Application Database Schema

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.
jiveBookmark	provides bookmarking for Jive SBS content
jiveBridge	Table for bridged CS instances.
jiveCollaboration	Junction Table for Collaborators and Jive Objects
jiveComment	Comments.
jiveCommentProp	Properties for comments.
jiveCommunity	Container table for community data.
jiveCommunityProp	Properties for communities
jiveCommunityTag	Tag/object/user association table
jiveContainerAprvr	Container approvers.
jiveContainerBlog	Blog/container association table.
jiveContentBackup	Content backup table
jiveCredential	Store for persisting credentials
jiveDataType	Datatype definition table.
jiveDocBodyConfig	Setting data for document bodies.
jiveDocBodyTypes	Allowed/Disallowed binary body content types.
jiveDocBodyVersion	Document body versions.
jiveDocCollab	Document collaboration.
jiveDocElementType	Document element types.
jiveDocType	Document type data table.
jiveDocTypeElement	Document type elements.
jiveDocTypeProp	Properties for document types.
jiveDocument	Document data table.
jiveDocumentAudit	Document audit trail (not currently used).
jiveDocumentBody	The body of the document.
jiveDocumentProp	Properties for documents.
jiveDocVersion	Document version table.
jiveDocVersionCmmt	Comments on document versions.
jiveDraft	Draft data table.
jiveDraftImage	Draft/Image assocation table
jiveDraftProp	Properties for drafts.
jiveEmailToken	User email token data table.
jiveEntitlement	Entitlement data for Jive SBS objects
jiveExternalURL	holds URL information for external favorites
jiveFeatured	Store content to be featured in a container
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.
jiveFollow	Containers (Projects/Spaces) a user is following
jiveGateway	Gateway data table.
jiveGatewayProp	Properties for gateways.
jiveGroup	Container table for group data.
jiveGroupPerm	Group permissions.
jiveGroupProp	Properties for groups.
jiveGroupUser	Container table for specifying the users in a group.
jiveI18nText	provides internationalized text for other tables.
jiveID	ID Sequence table.
jiveImage	Image data table.
jiveImageData	Image data.
jiveImageVersion	Version table for document images.
jiveInvite	Table for invitations
jiveInviteProp	Properties for invitations.
jiveLabel	holds labels used for personal organization of various jive objects
jiveLabelElement	Label elements.
jiveLabelMap	Maps labels to jive objects
jiveLabelType	Maps labels to one or many jive object types
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.
jiveObjectType	Stores the type ID and code of object types
jiveOSPropEntry	OSWorkflow property table.
jivePCheckPoint	Container table for work space checkPoint data.
jivePermMask	Stores permissions with it's permission mask
jivePlugin	Plugin information
jivePluginProp	A table that contents contains custom properties stored for plugins
jivePMessage	Container table for private message data.
jivePMessageFldr	Private message folders.
jivePMessageProp	Properties for private messages.
jivePoll	Poll data table.
jivePollOption	Poll options table.
jivePollVote	Poll vote data table.
jivePopularity	A table that stores archived content popularity scores for generating popular content
jivePresenter	Presention information data table.
jiveProfileField	Profile field data table.
jiveProfileFldOpt	Profile field option data table.
jiveProject	Container table for work space data.
jiveProjectProp	Properties for work spaces
jiveProjectStatus	Table for project status.
jiveProperty	System wide Jive properties.
jivePTask	Container table for work space data.
jivePTaskProp	Properties for work space checkPoints
jiveQuestion	Question data table.
jiveQuestionProp	Properties for questions.
jiveRating	Rating data table.
jiveRatingType	Rating types.
jiveReadTracker	Read tracking data table.
jiveReference	Jive Reference Table
jiveSearch	Search logging data table.
jiveSearchClick	Search result clickthrough tracking table.
jiveSearchCriteria	Search criteria data table.
jiveSearchEngine	Installed OpenSearch engine information
jiveSectionElement	Section elements.
jiveSGroup	Container table for social groups.
jiveSGroupMember	Member table for social groups.
jiveSGroupProp	Properties for social groups
jiveShare	Jive Artifact Sharing Information
jiveStat	Statistics.
jiveStatLvlScen	Status level scenarios.
jiveStatusLevel	Status levels.
jiveStatusLevelPnt	Status level points.
jiveTag	Tag data table.
jiveTagSet	Tag set data table.
jiveTagSetMap	Association table for tag sets and tags.
jiveThemeMap	Mapping table for theme mapping data.
jiveThread	Container table for forum thread data.
jiveThreadProp	Properties for threads.
jiveTrackback	Trackback data table for blogs.
jiveTrackbackProp	Properties for trackbacks.
jiveTypeVldtrProp	Properties for document type validators.
jiveTypeWatchConf	holds user content type auto watch preferences
jiveUser	Container table for user data.
jiveUserContainer	Representation of user-owned content aggregation
jiveUserIMHandle	User IM handles.
jiveUserPerm	User permissions.
jiveUserProfile	User profile data table.
jiveUserProp	Properties for users.
jiveUserRel	Historical relationships between users
jiveUserRelGraph	A container for a set of relationships.
jiveUserRoster	User Rosters.
jiveUserStatus	User status information
jiveUsrRelGrApr	A set of users who approve all new graph relationships.
jiveUsrRelGrNtf	A set of users who are notified of graph relationship changes.
jiveUsrRelList	User-specific lists of relationships
jiveUsrRelListMap	Maps user relationship lists to relationships
jiveVersion	Version data table.
jiveVideo	Provides support for videos
jiveVideoScreens	Look up table for video screen grabs
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 Table

Abuse data table.

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

Back to the table list.

jiveActivity Table

A table that stores all recent activity happing in the application

Column Name	Type	Length	Nullable	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.

Back to the table list.

jiveAnnounce Table

Container table for announcement data

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

Back to the table list.

jiveAnnounceProp Table

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.

Back to the table list.

jiveAnswer Table

Answer data table.

Column Name	Type	Length	Nullable	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).

Back to the table list.

jiveApprovalWrkflw Table

Workflow approval table.

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

Back to the table list.

jiveAttachData Table

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.

Back to the table list.

jiveAttachment Table

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.

Back to the table list.

jiveAttachmentDL Table

Statistical data table for attachment downloads.

Column Name	Type	Length	Nullable	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.

Back to the table list.

jiveAttachmentProp Table

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.

Back to the table list.

jiveAttachSettings Table

Attachment settings.

Column Name	Type	Length	Nullable	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.

Back to the table list.

jiveAttachTypes Table

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.

Back to the table list.

jiveAttachVersion Table

Version table for document attachments.

Column Name	Type	Length	Nullable	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.

Back to the table list.

jiveAuditLog Table

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.

Back to the table list.

jiveAvatar Table

Avatar data table.

Column Name	Type	Length	Nullable	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.

Back to the table list.

jiveAvatarProp Table

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.

Back to the table list.

jiveAvatarUser Table

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.

Back to the table list.

jiveBan Table

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.

Back to the table list.

jiveBlog Table

Blog data table.

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

Back to the table list.

jiveBlogPost Table

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.

Back to the table list.

jiveBlogPostProp Table

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.

Back to the table list.

jiveBlogProp Table

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.

Back to the table list.

jiveBookmark Table

provides bookmarking for Jive SBS content

Column Name	Type	Length	Nullable	Description
creationDate	bigint	N/A	false	the date and time on which this favorite was created
creatorId	bigint	N/A	false	the id of the entity which created the favorite
creatorType	int	N/A	false	the type of entity which created the favorite
id	bigint	N/A	false	uniquely identifies favorite system wide Primary key.
markedId	bigint	N/A	false	the unique id related to the entity which is being bookmarked
markedType	int	N/A	false	the type of entity which is being bookmarked
modificationDate	bigint	N/A	false	the date and time on which this favorite was last modified
notes	varchar	3500	true	for particular kinds of bookmarked content the user can provide notes about a favorited piece of content
ownerId	bigint	N/A	false	the unique id of the entity which will own this favorite
ownerType	int	N/A	false	the type of entity which owns this favorite
status	int	N/A	false	an int which contains the current state of the favorite in the favorite workflow, awaiting moderation, abusive, awaiting acceptance, accepted, etc
subject	varchar	255	true	for particular kinds of bookmarked content the user can provide a subject or title

Back to the table list.

jiveBridge Table

Table for bridged CS instances.

Column Name	Type	Length	Nullable	Unicode	Description
bridgeID	bigint	N/A	false		ID. Primary key.
creationDate	bigint	N/A	false		Create date of partner entry.
description	varchar	255	true	true	Brief Description of the bridged CS instance.
disabled	smallint	N/A	N/A		Indicates the bridge is disabled
engineID	bigint	N/A	false		The OpenSearch engineID for this bridge.
name	varchar	255	false	true	Name of the remote CS instance, used in display.
url	varchar	255	false	true	Project Status Description.
userID	bigint	N/A	false		The ID of the user that created the bridge entry.

Back to the table list.

jiveCollaboration Table

Junction Table for Collaborators and Jive Objects

Column Name	Type	Length	Nullable	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

Back to the table list.

jiveComment Table

Comments.

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

Back to the table list.

jiveCommentProp Table

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.

Back to the table list.

jiveCommunity Table

Container table for community data.

Column Name	Type	Length	Nullable	Unicode	Description
communityID	bigint	N/A	false		Community ID. Primary key.
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.

Back to the table list.

jiveCommunityProp Table

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.

Back to the table list.

jiveCommunityTag Table

Tag/object/user association table

Column Name	Type	Length	Nullable	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.
userID	bigint	N/A	false	user id associated with the tag.

Back to the table list.

jiveContainerAprvr Table

Container approvers.

Column Name	Type	Length	Nullable	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.

Back to the table list.

jiveContainerBlog Table

Blog/container association table.

Column Name	Type	Length	Nullable	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.

Back to the table list.

jiveContentBackup Table

Content backup table

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

Back to the table list.

jiveCredential Table

Store for persisting credentials

Column Name	Type	Length	Nullable	Description
artifactID	bigint	N/A	false	The artifact ID, e.g. Bridge, SearchEngine, VideoProvider, LDAP, JDBC, etc..
token	raw	2000	false	Binary data for the credentials token.
type	int	N/A	false	Artifact type associated with the credentials. This should be an integer constant defined in JiveConstants to avoid collisions.
userID	bigint	N/A	false	The user ID.

Back to the table list.

jiveDataType Table

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.

Back to the table list.

jiveDocBodyConfig Table

Setting data for document bodies.

Column Name	Type	Length	Nullable	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.

Back to the table list.

jiveDocBodyTypes Table

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.

Back to the table list.

jiveDocBodyVersion Table

Document body versions.

Column Name	Type	Length	Nullable	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.

Back to the table list.

jiveDocCollab Table

Document collaboration.

Column Name	Type	Length	Nullable	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.

Back to the table list.

jiveDocElementType Table

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.

Back to the table list.

jiveDocType Table

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.

Back to the table list.

jiveDocTypeElement Table

Document type elements.

Column Name	Type	Length	Nullable	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.

Back to the table list.

jiveDocTypeProp Table

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.

Back to the table list.

jiveDocument Table

Document data table.

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

Back to the table list.

jiveDocumentAudit Table

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.

Back to the table list.

jiveDocumentBody Table

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.

Back to the table list.

jiveDocumentProp Table

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.

Back to the table list.

jiveDocVersion Table

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).
status	int	N/A	false		The published status of the document.
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.

Back to the table list.

jiveDocVersionCmmt Table

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.

Back to the table list.

jiveDraft Table

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.

Back to the table list.

jiveDraftImage Table

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.

Back to the table list.

jiveDraftProp Table

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.

Back to the table list.

jiveEmailToken Table

User email token data table.

Column Name	Type	Length	Nullable	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.

Back to the table list.

jiveEntitlement Table

Entitlement data for Jive SBS objects

Column Name	Type	Length	Nullable	Description
contentType	int	N/A	false	Content type for which the bitmask applies.
creationDate	bigint	N/A	true
entitlementID	bigint	N/A	false	ID the entitlement data Primary key.
entitlementMask	int	N/A	false	Bitmask of entitlements the user has on the object.
groupID	bigint	N/A	true	The ID of the group to which the entitlement is granted.
modificationDate	bigint	N/A	true
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).
userID	bigint	N/A	true	The ID of the user to which the entitlement is granted.

Back to the table list.

jiveExternalURL Table

holds URL information for external favorites

Column Name	Type	Length	Nullable	Description
creationDate	bigint	N/A	false	the date and time on which this URL entry was created
host	varchar	255	false	the hostname of the URL such as www.jivesoftware.com
id	bigint	N/A	false	uniquely identifies URL system wide Primary key.
mimeType	varchar	100	true	mime type related to the given url
modificationDate	bigint	N/A	false	last modification date of the external URL
path	varchar	255	true	the path of the URL such as /community
port	int	N/A	true	the port of the URL such as 80
protocol	varchar	10	false	the protocol of the URL such as http
query	varchar	255	true	the query string of the URL such as foo=bar
ref	varchar	245	true	the anchor of the URL such as #foo
status	int	N/A	false
title	varchar	1000	true	a title extracted from the url

Back to the table list.

jiveFeatured Table

Store content to be featured in a container

Column Name	Type	Length	Nullable	Description
containerID	bigint	N/A	false	Container content is featured in Primary key.
containerType	int	N/A	false	Type of container the content is featured in Primary key.
creationDate	bigint	N/A	false	the date and time when this item was featured
objectID	bigint	N/A	false	id of the content to be feautred Primary key.
objectType	int	N/A	false	The type of content being featured Primary key.

Back to the table list.

jiveField Table

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.

Back to the table list.

jiveFieldFrmtProp Table

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.

Back to the table list.

jiveFieldOption Table

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.

Back to the table list.

jiveFieldType Table

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.

Back to the table list.

jiveFieldValue Table

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.

Back to the table list.

jiveFieldVldtrProp Table

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.

Back to the table list.

jiveFollow Table

Containers (Projects/Spaces) a user is following

Column Name	Type	Length	Nullable	Description
containerID	bigint	N/A	false	The ID of the container Primary key.
containerType	int	N/A	false	The type of the container Primary key.
creationDate	bigint	N/A	false	The creation date of the entry.
userID	bigint	N/A	false	The ID of the user following the container. Primary key.

Back to the table list.

jiveGateway Table

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.

Back to the table list.

jiveGatewayProp Table

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

Back to the table list.

jiveGroup Table

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.

Back to the table list.

jiveGroupPerm Table

Group permissions.

Column Name	Type	Length	Nullable	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.

Back to the table list.

jiveGroupProp Table

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.

Back to the table list.

jiveGroupUser Table

Container table for specifying the users in a group.

Column Name	Type	Length	Nullable	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.

Back to the table list.

jiveI18nText Table

provides internationalized text for other tables.

Column Name	Type	Length	Nullable	Description
creationDate	bigint	N/A	false	Create date of the text record.
locale	varchar	100	false	The locale code of the text.
modificationDate	bigint	N/A	false	Last modification date of the text record.
objectAttribute	int	N/A	false	Attribute of the object (name, description).
objectID	bigint	N/A	false	ID of the object being referenced by the objectType column.
objectType	int	N/A	false	Type of object (profile field, status level).
text	varchar	2000	false	The internationalized text. Primary key.
textID	bigint	N/A	false	System generated surrogate key. Primary key.

Back to the table list.

jiveID Table

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.

Back to the table list.

jiveImage Table

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.

Back to the table list.

jiveImageData Table

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.

Back to the table list.

jiveImageVersion Table

Version table for document images.

Column Name	Type	Length	Nullable	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.

Back to the table list.

jiveInvite Table

Table for invitations

Column Name	Type	Length	Nullable	Description
creationDate	bigint	N/A	false	The date the invitation was created
email	varchar	100	true	Email address of the user recieving the invitation
invitationId	bigint	N/A	false	Unique ID for the invitation Primary key.
inviterId	bigint	N/A	true	ID of the user who initiated the invitation.
modificationDate	bigint	N/A	false	The date the invitation was last modified
objectId	bigint	N/A	false	The id of the object being shared
objectType	int	N/A	false	Type of the object being shared
revokeDate	bigint	N/A	true	the date on which this invitation was revoked.
revokerId	bigint	N/A	true	The date on which this invitation was revoked
sentDate	bigint	N/A	true	The date at which the invitation was sent
state	int	N/A	false	The state of the invitation
userId	bigint	N/A	true	ID of the user receiving the invitation.

Back to the table list.

jiveInviteProp Table

Properties for invitations.

Column Name	Type	Length	Nullable	Unicode	Description
invitationId	bigint	N/A	false		Unique ID for the invitation Primary key.
name	varchar	100	false	true	Property name Primary key.
propValue	varchar	3500	false	true	Property value

Back to the table list.

jiveLabel Table

holds labels used for personal organization of various jive objects

Column Name	Type	Length	Nullable	Description
labelID	bigint	N/A	false	uniquely identifies the label system wide Primary key.
name	varchar	200	false	The name of the label.
ownerID	bigint	N/A	false	User ID of label owner.
style	varchar	200	true	A CSS style descriptor for the label

Back to the table list.

jiveLabelElement Table

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.

Back to the table list.

jiveLabelMap Table

Maps labels to jive objects

Column Name	Type	Length	Nullable	Description
labelID	bigint	N/A	false	The label ID.
objectID	bigint	N/A	false	The jive object ID.
objectType	int	N/A	false	Object type associated with the label.

Back to the table list.

jiveLabelType Table

Maps labels to one or many jive object types

Column Name	Type	Length	Nullable	Unicode	Description
labelID	bigint	N/A	false		The label ID.
objectType	int	N/A	false		Object type associated with the label.

Back to the table list.

jiveLinkObject Table

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.

Back to the table list.

jiveLocalizedProp Table

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.

Back to the table list.

jiveMessage Table

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).
status	int	N/A	false		The published status of the message.
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.

Back to the table list.

jiveMessageProp Table

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.

Back to the table list.

jiveModeration Table

Audit table for moderation events.

Column Name	Type	Length	Nullable	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.

Back to the table list.

jiveObjectTag Table

Tag/object association table.

Column Name	Type	Length	Nullable	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.

Back to the table list.

jiveObjectType Table

Stores the type ID and code of object types

Column Name	Type	Length	Nullable	Unicode	Description
code	varchar	255	false		The code of the type.
typeID	int	N/A	false		the unique ID the represents the type Primary key.

Back to the table list.

jiveOSPropEntry Table

OSWorkflow property table.

Column Name	Type	Length	Nullable	Unicode
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

Back to the table list.

jivePCheckPoint Table

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.

Back to the table list.

jivePermMask Table

Stores permissions with it's permission mask

Column Name	Type	Length	Nullable	Unicode	Description
mask	int	N/A	false		the unique mask assigned to the permission
name	varchar	255	false		The name of the permission. Primary key.

Back to the table list.

jivePlugin Table

Plugin information

Column Name	Type	Length	Nullable	Unicode	Description
creationDate	bigint	N/A	false		The date the plugin was installed
data	blob	N/A	true		Plugin jar file content
modificationDate	bigint	N/A	false		The date the invitation was last modified, probably updated the data entry
name	varchar	100	false	true	Plugin Name
pluginID	bigint	N/A	false		Unique ID for the plugin entry Primary key.

Back to the table list.

jivePluginProp Table

A table that contents contains custom properties stored for plugins

Column Name	Type	Length	Nullable	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

Back to the table list.

jivePMessage Table

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.
creationDate	bigint	N/A	false		The private message creation date.
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 modification 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.
sentDate	bigint	N/A	true		The private message sent date.
status	int	N/A	false		The published status of the private message.
subject	varchar	255	true	true	The subject of the private message.

Back to the table list.

jivePMessageFldr Table

Private message folders.

Column Name	Type	Length	Nullable	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.

Back to the table list.

jivePMessageProp Table

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.

Back to the table list.

jivePoll Table

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.
status	int	N/A	false		The published status of the thread.
userID	bigint	N/A	true		The user who posted the poll or NULL if it was anonymous.

Back to the table list.

jivePollOption Table

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.

Back to the table list.

jivePollVote Table

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.

Back to the table list.

jivePopularity Table

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

Column Name	Type	Length	Nullable	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.

Back to the table list.

jivePresenter Table

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.

Back to the table list.

jiveProfileField Table

Profile field data table.

Column Name	Type	Length	Nullable	Unicode	Description
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.
regIdx	int	N/A	false		Index of the field on the registration page.

Back to the table list.

jiveProfileFldOpt Table

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.

Back to the table list.

jiveProject Table

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.

Back to the table list.

jiveProjectProp Table

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.

Back to the table list.

jiveProjectStatus Table

Table for project status.

Column Name	Type	Length	Nullable	Unicode	Description
creationDate	bigint	N/A	false		Create date of Project Status.
projectID	bigint	N/A	false		Project ID.
statusDesc	varchar	255	true	true	Project Status Description.
statusID	bigint	N/A	false		Project Status ID. Primary key.
statusType	int	N/A	false		The project status type.
userID	bigint	N/A	false		The ID of the user that created the status.

Back to the table list.

jiveProperty Table

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.

Back to the table list.

jivePTask Table

Container table for work space data.

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

Back to the table list.

jivePTaskProp Table

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.

Back to the table list.

jiveQuestion Table

Question data table.

Column Name	Type	Length	Nullable	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.

Back to the table list.

jiveQuestionProp Table

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.

Back to the table list.

jiveRating Table

Rating data table.

Column Name	Type	Length	Nullable	Description
creationDate	bigint	N/A	true	Create date of a rating.
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.

Back to the table list.

jiveRatingType Table

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.

Back to the table list.

jiveReadTracker Table

Read tracking data table.

Column Name	Type	Length	Nullable	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.

Back to the table list.

jiveReference Table

Jive Reference Table

Column Name	Type	Length	Nullable	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.

Back to the table list.

jiveSearch Table

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.

Back to the table list.

jiveSearchClick Table

Search result clickthrough tracking table.

Column Name	Type	Length	Nullable	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.

Back to the table list.

jiveSearchCriteria Table

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.

Back to the table list.

jiveSearchEngine Table

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.

Back to the table list.

jiveSectionElement Table

Section elements.

Column Name	Type	Length	Nullable	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.

Back to the table list.

jiveSGroup Table

Container table for social groups.

Column Name	Type	Length	Nullable	Unicode	Description
creationDate	bigint	N/A	false		Create date of the social group.
description	varchar	1000	true	true	Social group description.
displayName	varchar	255	false	true	URL safe social group name.
groupID	bigint	N/A	false		Social group ID. Primary key.
groupType	int	N/A	false		The type of the social group (open, member, private, etc)
modificationDate	bigint	N/A	false		Last modification date of social group.
name	varchar	255	false	true	Social group name.
userID	bigint	N/A	false		The ID of the user that created the social group.

Back to the table list.

jiveSGroupMember Table

Member table for social groups.

Column Name	Type	Length	Nullable	Description
creationDate	bigint	N/A	false	Date the member was added to the social group.
groupID	bigint	N/A	false	Social group ID. Primary key.
membershipID	bigint	N/A	false	Membership ID
memberType	int	N/A	false	The type of the member (admin, contributor, etc)
userID	bigint	N/A	false	Member ID Primary key.
workflowID	bigint	N/A	true	Workflow ID

Back to the table list.

jiveSGroupProp Table

Properties for social groups

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

Back to the table list.

jiveShare Table

Jive Artifact Sharing Information

Column Name	Type	Length	Nullable	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

Back to the table list.

jiveStat Table

Statistics.

Column Name	Type	Length	Nullable	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.

Back to the table list.

jiveStatLvlScen Table

Status level scenarios.

Column Name	Type	Length	Nullable	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.

Back to the table list.

jiveStatusLevel Table

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.

Back to the table list.

jiveStatusLevelPnt Table

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.

Back to the table list.

jiveTag Table

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.

Back to the table list.

jiveTagSet Table

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.

Back to the table list.

jiveTagSetMap Table

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.

Back to the table list.

jiveThemeMap Table

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.

Back to the table list.

jiveThread Table

Container table for forum thread data.

Column Name	Type	Length	Nullable	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.
status	int	N/A	false	The published status of the thread.
threadID	bigint	N/A	false	Thread ID. Primary key.

Back to the table list.

jiveThreadProp Table

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.

Back to the table list.

jiveTrackback Table

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).
status	int	N/A	false		The published status of the trackback.
title	varchar	100	true	true	The title of the trackback.
trackbackID	bigint	N/A	false		The ID of the trackback. Primary key.
url	varchar	255	true	true	The trackback URL.

Back to the table list.

jiveTrackbackProp Table

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.

Back to the table list.

jiveTypeVldtrProp Table

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.

Back to the table list.

jiveTypeWatchConf Table

holds user content type auto watch preferences

Column Name	Type	Length	Nullable
enabled	smallint	N/A	false
objecttype	int	N/A	false
userid	bigint	N/A	false
watchType	varchar	100	false

Back to the table list.

jiveUser Table

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 the application
firstName	varchar	100	true	true	First name.
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.
lastName	varchar	100	true	true	Last name.
lastProfileUpdate	bigint	N/A	false		Last time the user's profile was updated.
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.
status	int	N/A	false		The current status of a newly registered user
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

Back to the table list.

jiveUserContainer Table

Representation of user-owned content aggregation

Column Name	Type	Length	Nullable	Unicode	Description
creationDate	bigint	N/A	false
description	varchar	1000	true	true	The description of the container.
displayName	varchar	255	true	true	The display name of the container.
modificationDate	bigint	N/A	false
name	varchar	255	true	true	The name of the user container.
userContainerID	bigint	N/A	false		Primary key.
userID	bigint	N/A	false

Back to the table list.

jiveUserIMHandle Table

User IM handles.

Column Name	Type	Length	Nullable	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.

Back to the table list.

jiveUserPerm Table

User permissions.

Column Name	Type	Length	Nullable	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.

Back to the table list.

jiveUserProfile Table

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.

Back to the table list.

jiveUserProp Table

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.

Back to the table list.

jiveUserRel Table

Historical relationships between users

Column Name	Type	Length	Nullable	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.

Back to the table list.

jiveUserRelGraph Table

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.
reflexive	smallint	N/A	false		Are the graph relationships reflexive.

Back to the table list.

jiveUserRoster Table

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.

Back to the table list.

jiveUserStatus Table

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.

Back to the table list.

jiveUsrRelGrApr Table

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.

Back to the table list.

jiveUsrRelGrNtf Table

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.

Back to the table list.

jiveUsrRelList Table

User-specific lists of relationships

Column Name	Type	Length	Nullable	Description
labelStyle	varchar	200	true	A CSS style descriptor for the list avatar.
listID	bigint	N/A	false	The list ID. Primary key.
name	varchar	200	false	The name of the list.
userID	bigint	N/A	false	User ID of list owner.

Back to the table list.

jiveUsrRelListMap Table

Maps user relationship lists to relationships

Column Name	Type	Length	Nullable	Unicode	Description
listID	bigint	N/A	false		The list ID.
relationshipID	bigint	N/A	false		The relationship ID.

Back to the table list.

jiveVersion Table

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.

Back to the table list.

jiveVideo Table

Provides support for videos

Column Name	Type	Length	Nullable	Unicode	Description
body	text	N/A	true	true	The body/description of the media file.
commentStatus	int	N/A	false		Status of the object Published/Draft/Awaiting Moderation etc...
containerID	bigint	N/A	false		Container media lives in
containerType	int	N/A	false		Type of container the media lives in
creationDate	bigint	N/A	false		the date and time on which this media was created
duration	int	N/A	false		Length of the video.
embedded	smallint	N/A	true		Flag to determine if video is embedded (Boolean)
externalID	varchar	512	true		Primary key given by encoding service
isdone	smallint	N/A	false		Flag to determine if the video is done transcoding
modificationDate	bigint	N/A	false		the date and time on which this media was last modified
status	int	N/A	false		Status of the object Published/Draft/Awaiting Moderation etc...
subject	varchar	255	true	true	The subject/title of the media file.
userID	bigint	N/A	false		User who created the video.
vidID	bigint	N/A	false		Uniquely describes a video system wide Primary key.

Back to the table list.

jiveVideoScreens Table

Look up table for video screen grabs

Column Name	Type	Length	Nullable	Description
attachmentID	bigint	N/A	false	attachment id where the grab data is stored
isDefault	smallint	N/A	false	True if the image is the default
vidID	bigint	N/A	false	video id the grab belongs to

Back to the table list.

jiveViewCount Table

Object view counts.

Column Name	Type	Length	Nullable	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	bigint	N/A	true	Number of times the object has been read.

Back to the table list.

jiveWatch Table

Container table for user watch data.

Column Name	Type	Length	Nullable	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.

Back to the table list.

jiveWatchSettings Table

Watch settings data table.

Column Name	Type	Length	Nullable	Description
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.

Back to the table list.

jiveWFCurrentStep Table

OSWorkflow workflow current step table.

Column Name	Type	Length	Nullable	Unicode	Description
actionID	smallint	N/A	true
caller	varchar	100	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	100	true	true
startDate	timestamp	N/A	true
status	varchar	20	true
stepID	smallint	N/A	true

Back to the table list.

jiveWFCurrStepPrev Table

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.

Back to the table list.

jiveWFEntry Table

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

Back to the table list.

jiveWFHistoryStep Table

OSWorkflow workflow history table.

Column Name	Type	Length	Nullable	Unicode	Description
actionID	int	N/A	true
caller	varchar	100	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	100	true	true
startDate	timestamp	N/A	true
status	varchar	20	true	true
stepID	int	N/A	true

Back to the table list.

jiveWFHistStepPrev Table

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.

Back to the table list.

jiveWidget Table

Installed widget information

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

Back to the table list.

jiveWidgetFrame Table

Container table for Widget frames

Column Name	Type	Length	Nullable	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.

Back to the table list.

jiveWidgetFrmProp Table

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	text	N/A	false	true	Property value.

Back to the table list.

jiveWikiLink Table

Wiki link tracking table.

Column Name	Type	Length	Nullable	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.

Back to the table list.

jiveWLayout Table

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.

Back to the table list.

jiveWLayoutFrame Table

Container table for Widget Layout frames

Column Name	Type	Length	Nullable	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.