Contents

  • Database Tables
  • Entity Relationship Diagrams

    • This document describes tables in the application database. The application database provides storage for core content activity, and optionally user data.

    Note: 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 System Requirements for more database-related information.

    Data Type Conventions

    Database Tables

    Table Name Description
    jiveAbuse Abuse data table.
    jiveActivity A table that stores all recent activity happing in the application
    jiveAnnounce Container table for announcement data
    jiveAnnounceProp Properties for announcements.
    jiveAnswer Answer data table.
    jiveApprovalWrkflw Workflow approval table.
    jiveAttachData Attachment binary data table.
    jiveAttachment Attachment definition table.
    jiveAttachmentDL Statistical data table for attachment downloads.
    jiveAttachmentProp Properties for attachments.
    jiveAttachSettings Attachment settings.
    jiveAttachTypes Allowed/Disallowed attachment content types.
    jiveAttachVersion Version table for document attachments.
    jiveAuditLog Audit messages resulting from admin activity
    jiveAvatar Avatar data table.
    jiveAvatarProp Properties for avatars.
    jiveAvatarUser Avatar/user association table.
    jiveBan Ban data table.
    jiveBlog Blog data table.
    jiveBlogPost Blog post data table.
    jiveBlogPostProp Properties for blog posts.
    jiveBlogProp Properties for blogs.
    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 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.

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

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

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

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

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

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

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

    Back to the table list.

    jiveContainerBlog Table

    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.

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

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

    Back to the table list.

    jiveDocCollab Table

    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.

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

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

    Back to the table list.

    jiveEntitlement Table

    Entitlement data for Jive SBS objects

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

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

    Back to the table list.

    jiveI18nText Table

    provides internationalized text for other tables.

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

    Back to the table list.

    jiveInvite Table

    Table for invitations

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

    Back to the table list.

    jiveObjectTag Table

    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.

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

    Back to the table list.