This document describes tables in the application database. The application database provides storage for core content activity, and optionally user data.
long currentDate = new Date().getTime();
For information about converting dates into a more human-readable formats, see the following Knowledge Base documents: [41], [211], [231]
| Table Name | Description |
|---|---|
| jiveAbuse | Abuse data table. |
| jiveActivity | A table that stores all recent activity happing in the application |
| jiveActivityHistry | A table that stores aggregated activity counts |
| jiveAnnounce | Container table for announcement data |
| jiveAnnounceProp | Properties for announcements. |
| jiveAnswer | Answer data table. |
| jiveApprovalWrkflw | Workflow approval table. |
| jiveAttachSettings | Attachment settings. |
| jiveAttachTypes | Allowed/Disallowed attachment content types. |
| jiveAttachVersion | Version table for document attachments. |
| jiveAttachment | Attachment definition table. |
| jiveAttachmentDL | Statistical data table for attachment downloads. |
| jiveAttachmentProp | Properties for 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. |
| jiveBridgeOption | Table for bridge options: opensearch, widgets, bridged content |
| jiveBridgedCont | Table for bridged content |
| jiveBridgedContMsg | Table for bridged content messages |
| 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. |
| jiveContent | Table for storing generic content |
| jiveContentBackup | Content backup table |
| jiveContentProp | Table for storing generic content properties |
| jiveCredential | Store for persisting credentials |
| jiveCustomPermLvl | Custom Permission Levels |
| jiveDataType | Datatype definition table. |
| jiveDefObjPermLvl | Default object permission levels granted to all objects of a particular type when applied |
| 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. |
| jiveDocVersion | Document version table. |
| jiveDocVersionCmmt | Comments on document versions. |
| jiveDocument | Document data table. |
| jiveDocumentAudit | Document audit trail (not currently used). |
| jiveDocumentBody | The body of the document. |
| jiveDocumentProp | Properties for documents. |
| 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 |
| jiveEntitlementMsk | Bit masks used by entitlements |
| jiveEntlmntInherit | The listing of containers which are inheriting entitlement settings from their parent containers |
| jiveExtContext | |
| 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. |
| jiveGrantedPermLvl | When a perm level is set on an entity it is stored in this table |
| 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. |
| 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 |
| jiveLicenseConfirm | Stores license report confirmations. |
| jiveLicenseReport | Stores license reports. |
| jiveLinkObject | Link data table. |
| jiveLocalizedProp | Localized system wide Jive properties. |
| jiveMessage | Container data for forum message data. |
| jiveMessageProp | Properties for messages. |
| jiveMetering | Stores metered resource usage stats |
| jiveModeration | Audit table for moderation events. |
| jiveOSPropEntry | OSWorkflow property table. |
| jiveObjPermLvl | Permission levels available for objects |
| jiveObjPermLvlExt | Extension information for object permission levels |
| jiveObjPermLvlMap | Mapping between object permission levels and permission levels |
| jiveObjPermLvlMsk | Maps masks to perm levels |
| jiveObjTypeMsk | All masks available for a particular object type |
| jiveObjectTag | Tag/object association table. |
| jiveObjectTagSet | Association table for tag sets and jive content objects. |
| jiveObjectType | Stores the type ID and code of object types |
| jivePCheckPoint | Container table for work space checkPoint data. |
| jivePMessage | Container table for private message data. |
| jivePMessageFldr | Private message folders. |
| jivePMessageProp | Properties for private messages. |
| jivePTask | Container table for work space data. |
| jivePTaskProp | Properties for work space checkPoints |
| jivePageViewConfig | Stores customized configurationd data for page view metering |
| jivePermLevel | Permission levels |
| jivePermLvlMsk | Maps masks and object types to perm levels |
| jivePermMask | Stores permissions with it's permission mask |
| jivePlugin | Plugin information |
| jivePluginProp | A table that contents contains custom properties stored for plugins |
| 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. |
| jiveQuestion | Question data table. |
| jiveQuestionProp | Properties for questions. |
| jiveRating | Rating data table. |
| jiveRatingType | Rating types. |
| jiveReadTracker | Read tracking data table. |
| jiveReference | Jive Reference Table |
| jiveRmtBridgedCont | Table for remote bridged content |
| jiveSGroup | Container table for social groups. |
| jiveSGroupMember | Member table for social groups. |
| jiveSGroupProp | Properties for social groups |
| jiveSearch | Search logging data table. |
| jiveSearchClick | Search result clickthrough tracking table. |
| jiveSearchCriteria | Search criteria data table. |
| jiveSearchEngine | Installed OpenSearch engine information |
| jiveSectionElement | Section elements. |
| jiveShare | Jive Artifact Sharing Information |
| jiveStat | Statistics. |
| jiveStatLvlScen | Status level scenarios. |
| jiveStatusLevel | Status levels. |
| jiveStatusLevelPnt | Status level points. |
| jiveTag | Tag data table. |
| jiveTagCloud | Container/tag cloud association 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 |
| jiveUUID | Stores the type, ID, version and UUID jive objects |
| jiveUUIDExt | Stores UUID to external id mappings |
| jiveUser | Container table for user data. |
| jiveUserContainer | Representation of user-owned content aggregation |
| jiveUserContnrProp | A table that contents contains custom properties stored for user containers |
| 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. |
| jiveWFCurrStepPrev | OSWorkflow previous workflow step table. |
| jiveWFCurrentStep | OSWorkflow workflow current step table. |
| jiveWFEntry | OSWorkflow entry table. |
| jiveWFHistStepPrev | OSWorkflow history step table. |
| jiveWFHistoryStep | OSWorkflow workflow history table. |
| jiveWLayout | Installed widget layout information |
| jiveWLayoutFrame | Container table for Widget Layout frames |
| jiveWatch | Container table for user watch data. |
| jiveWatchSettings | Watch settings data table. |
| jiveWidget | Installed widget information |
| jiveWidgetFrame | Container table for Widget frames |
| jiveWidgetFrmProp | Properties for widget frames |
| jiveWikiLink | Wiki link tracking table. |
The following diagrams illustrate relationships between tables where primary/foreign key relationships exist. Tables not connect through such relationships were omitted from the diagrams.
Blogs, polls, announcements, and private messages