Introduction
This document outlines the data type conventions and tables in the Jive Forums
database schema. Some information, like column indexes and foreign keys, is
omitted. For this, please read the individual schema of the database you're
interested in. Data types may also differ somewhat in each individual database
schema.
Data Type Conventions
-
Date column type support varies widely across databases. Therefore, Jive
Forums specially encodes dates as 64 bit numbers. The long value is the
internal representation of Java Date objects, which can be obtained with
code such as the following:
long currentDate = new Date().getTime();
For information about converting dates into a more human-readable
formats, see the following Knowledge Base documents: [41], [211], [231]
Note: Previous versions of Jive Forums
stored dates as CHAR(15) values, which was simply the long value
0-padded to 15 characters.
- Boolean values are always represented a numeric values: 0 for false
and 1 for true.
Database Tables
Below is a description of each of the tables in the Jive Forums database schema.
A yellow row denotes a primary key.
jiveAbuse (Report Abuse)
Column Name |
Type |
Length |
Description |
abuseID |
NUMBER |
n/a |
Primary Key |
abuseType |
NUMBER |
n/a |
The type of abuse report (constant defined in application) |
messageID |
NUMBER |
n/a |
The ID of the abusive message |
userID |
NUMBER |
n/a |
The user making the report |
reportDate |
NUMBER |
n/a |
The date the report was made |
comments |
VARCHAR |
255 |
Any comments the user submits with the report |
resolved |
NUMBER |
n/a |
|
top of page
jiveAnnounce (Announcements)
Column Name |
Type |
Length |
Description |
announcementID |
NUMBER |
n/a |
Announcement ID (Primary Key) |
objectType |
NUMBER |
n/a |
Object type associated with the announcement |
objectID |
NUMBER |
n/a |
Object ID the announcement is associated with. |
userID |
NUMBER |
n/a |
User who created the announcement. |
subject |
VARCHAR |
255 |
The subject of the announcement. |
body |
LONG VARCHAR/CLOB/TEXT |
n/a |
The body of the announcement. |
startDate |
NUMBER |
n/a |
Start date |
endDate |
NUMBER |
n/a |
End date |
top of page
jiveAnnounceProp (Announcement Properties)
Column Name |
Type |
Length |
Description |
announcementID |
NUMBER |
n/a |
Announcement ID (Primary Key) |
name |
NUMBER |
n/a |
Property name (Primary Key) |
propValue |
VARCHAR |
4000 |
Property value. |
top of page
jiveAnswer (Question answers)
Column Name |
Type |
Length |
Description |
threadID |
NUMBER |
n/a |
ID of the answer's thread (Primary Key) |
messageID |
NUMBER |
n/a |
ID of the answer's message (Primary Key) |
forumID |
NUMBER |
n/a |
ID of the answer's forum |
userID |
NUMBER |
n/a |
ID of the answer's user (can be NULL) |
helpfulAnswer |
NUMBER |
n/a |
Indicates if the answer was helpful (boolean 1 or 0) |
correctAnswer |
NUMBER |
n/a |
Indicates if the answer was correct (boolean 1 or 0) |
top of page
jiveAttachment (Attachment Meta-Data)
Column Name |
Type |
Length |
Description |
attachmentID |
NUMBER |
n/a |
Attachment ID (Primary Key). |
objectType |
NUMBER |
n/a |
Type of object the attachment belongs to. |
objectID
|
NUMBER |
n/a |
ID of object the attachment belongs to. |
filename |
VARCHAR |
255 |
Name of attachment. |
filesize |
NUMBER |
n/a |
Size of attachment in bytes. |
contentType |
VARCHAR |
50 |
MIME-type of attachment. |
creationDate |
NUMBER |
n/a |
Creation date. |
modificationDate |
NUMBER |
n/a |
Last modified date. |
top of page
jiveAttachData (Binary Attachment Data)
Column Name |
Type |
Length |
Description |
attachmentID |
NUMBER |
n/a |
Attachment ID (Primary Key). |
attachmentData |
BLOB |
n/a |
Binary data of the attachment. |
top of page
jiveAttachmentProp (Attachment Properties)
Column Name |
Type |
Length |
Description |
attachmentID (Primary Key) |
NUMBER |
n/a |
Attachment ID. |
name (Primary Key) |
VARCHAR |
255 |
Poperty name. |
propValue |
VARCHAR |
4000 |
Property value. |
top of page
jiveAvatar (Avatar definitions)
Column Name |
Type |
Length |
Description |
avatarID (Primary Key) |
NUMBER |
n/a |
Avatar ID. |
modValue |
NUMBER |
n/a |
The moderation value for the avatar |
ownerID |
NUMBER |
n/a |
The ID of the person who created the avatar. |
top of page
jiveAvatarProp (Avatar Properties)
Column Name |
Type |
Length |
Description |
avatarID (Primary Key) |
NUMBER |
n/a |
Avatar ID. |
name (Primary Key) |
VARCHAR |
255 |
Poperty name. |
propValue |
VARCHAR |
4000 |
Property value. |
top of page
jiveAvatarUser (User avatars)
Column Name |
Type |
Length |
Description |
avatarID (Primary Key) |
NUMBER |
n/a |
Avatar ID. |
userID (Primary Key) |
NUMBER |
n/a |
ID of the user associated with the avatar. |
top of page
jiveBan (Banning Users)
Column Name |
Type |
Length |
Description |
banID |
NUMBER |
n/a |
Primary key |
banType |
NUMBER |
n/a |
The type of ban (constants defined in the application) |
bannedUserID |
NUMBER |
|
The ID of the user being banned |
ipAddress |
VARCHAR |
15 |
The IP address being banned |
adminID |
NUMBER |
n/a |
The ID of the admin making the ban decision |
banLevel |
NUMBER |
n/a |
The ban punishment (constants defined in application) |
creationDate |
NUMBER |
n/a |
The date the ban was created |
expirationDate |
NUMBER |
n/a |
The date the ban expires |
comments |
VARCHAR |
50 |
Any comments associated with the ban |
top of page
jiveBatchWatch (Batch Email Watches)
Column Name |
Type |
Length |
Description |
userID |
NUMBER |
n/a |
The user associated with the batch watch. |
frequency |
VARCHAR |
50 |
CRON expression for how often batch emails should be sent. |
prevEmailDate |
NUMBER |
n/a |
Date that last batch email was sent. |
top of page
jiveCategory (Category Data)
Column Name |
Type |
Length |
Description |
categoryID |
NUMBER |
n/a |
Category ID (Primary Key) |
name |
VARCHAR |
255 |
Category name. |
description |
VARCHAR |
4000 |
Category description. |
creationDate |
NUMBER |
n/a |
Creation date. |
modificationDate |
NUMBER |
n/a |
Last modified date. |
lft |
NUMBER |
n/a |
The "left" value for category in the category tree structure. |
rgt |
NUMBER |
n/a |
The "right" value for category in the category tree structure. |
top of page
jiveCategoryProp (Category Properties)
Column Name |
Type |
Length |
Description |
categoryID |
NUMBER |
n/a |
Category ID. |
name |
VARCHAR |
255 |
Property name. |
propValue |
VARCHAR |
4000 |
Property value. |
top of page
jiveForum (Forum Data)
Column Name |
Type |
Length |
Description |
forumID |
NUMBER |
n/a |
Forum ID (Primary Key) |
name |
VARCHAR |
255 |
Forum name. |
nntpName |
VARCHAR |
255 |
NNTP name (unique). |
description |
VARCHAR |
4000 |
Forum description. |
modDefaultThreadVal |
NUMBER |
n/a |
Default moderation value for new threads. |
modDefaultMsgVal |
NUMBER |
n/a |
Default moderation value upon message creation |
creationDate |
NUMBER |
n/a |
Creation date |
modificationDate |
NUMBER |
n/a |
Last modified date |
categoryIndex |
NUMBER |
n/a |
The index of the forum in the category (used for sorting the forums
in a category). |
categoryID |
NUMBER |
n/a |
ID of the category that the forum belongs to. |
forumIndexCounter |
NUMBER |
n/a |
Highest forum index value from the jiveMessage table, used to
sequentially mark messages in a forum. |
top of page
jiveForumProp (Forum Properties)
Column Name |
Type |
Length |
Description |
forumID |
NUMBER |
n/a |
Forum ID. |
name |
VARCHAR |
255 |
Property name. |
propValue |
VARCHAR |
4000 |
Property value. |
top of page
jiveGateway (Gateways)
Column Name |
Type |
Length |
Description |
gatewayID |
NUMBER |
n/a |
Primary key |
forumID |
NUMBER |
n/a |
The ID the gateway is tied to |
type |
VARCHAR |
10 |
The type of gateway (constants defined in application) |
importEnabled |
NUMBER |
n/a |
Indicates whether or not imports are enabled |
exportEnabled |
NUMBER |
n/a |
Indicates whether or not exports are enabled |
disableCutOffDate |
NUMBER |
n/a |
Indicates whether or not to disable cut-off dates |
top of page
jiveGatewayProp (Gateway Properties)
Column Name |
Type |
Length |
Description |
gatewayID |
NUMBER |
n/a |
The ID of the gateway (Primary key) |
name |
VARCHAR |
100 |
The property name (Primary key) |
propValue |
VARCHAR |
4000 |
The property value |
top of page
jiveGroup (Group Data)
Column Name |
Type |
Length |
Description |
groupID |
NUMBER |
n/a |
Group ID (Primary Key). |
name |
VARCHAR |
255 |
Group name. |
description |
VARCHAR |
4000 |
Group description. |
creationDate |
NUMBER |
n/a |
Creation date. |
modificationDate |
NUMBER |
n/a |
Last modified date. |
top of page
jiveGroupPerm (Group Permissions)
Column Name |
Type |
Length |
Description |
objectType |
NUMBER |
n/a |
Object type (e.g., Forum, Message, Thread). |
objectID |
NUMBER |
n/a |
ID of the object referenced type the objectType column. |
groupID |
NUMBER |
n/a |
Group ID. |
permissionType |
NUMBER |
n/a |
The type of perm - additive or negative. |
permission |
NUMBER |
n/a |
Permission value (bitmask of all permissions the group has on the
object). |
top of page
jiveGroupProp (Group Properties)
Column Name |
Type |
Length |
Description |
groupID |
NUMBER |
n/a |
Group ID. |
name |
VARCHAR |
100 |
Property name. |
propValue |
VARCHAR |
4000 |
Property value. |
top of page
jiveGroupUser (Maps Users to Groups)
Column Name |
Type |
Length |
Description |
groupID |
NUMBER |
n/a |
Group ID (Primary Key). |
userID |
NUMBER |
n/a |
User ID (Primary Key). |
administrator |
NUMBER |
n/a |
Adminstrator (Boolean) (Primary Key). |
top of page
jiveHTTPReadStatSession (HTTP-Specific Read Stats Info)
Column Name |
Type |
Length |
Description |
referrer |
VARCHAR |
255 |
The web referrer (URL) for the session. |
userAgent |
VARCHAR |
255 |
The visitor's user agent (browser, OS ver, etc). |
IP |
VARCHAR |
16 |
The visitor's IP. |
country |
VARCHAR |
4 |
The country code of the visitor. |
bytesSent |
NUMBER |
n/a |
The number of bytes transferred over the session. |
sessionID |
NUMBER |
n/a |
ID of the read stat session. |
top of page
jiveID (Used for Unique ID Sequence Generation)
Column Name |
Type |
Length |
Description |
idType |
NUMBER |
n/a |
ID type (e.g., Forum, Thread, Message, Group, User) (Primary
Key). |
id |
NUMBER |
n/a |
Next available block of IDs (used for database-independent ID
sequence generator). |
top of page
jiveLocalizedProp (Localized Properties)
Column Name |
Type |
Length |
Description |
name |
VARCHAR |
100 |
The name of the property (Primary key) |
locale |
VARCHAR |
100 |
The locale code of the property (Primary key) |
propValue |
TEXT |
n/a |
The value of the property |
top of page
jiveMessage (Message Data)
Column Name |
Type |
Length |
Description |
messageID |
NUMBER |
n/a |
Message ID (Primary Key). |
parentMessageID |
NUMBER |
n/a |
Parent message ID. |
threadID |
NUMBER |
n/a |
ID of thread to which message belongs. |
forumID |
NUMBER |
n/a |
ID of forum to which message belongs. |
forumIndex |
NUMBER |
n/a |
An increasing sequence value for messages in the forum; primarily
used for NNTP. |
userID |
NUMBER |
n/a |
User ID of message's author. |
subject |
VARCHAR |
255 |
Subject of message. |
body |
LONG VARCHAR/CLOB/TEXT |
n/a |
Message body. |
modValue |
NUMBER |
n/a |
Moderation value of message. |
rewardPoints |
NUMBER |
n/a |
Reward points for message (used for incentive schemes for
posting). |
creationDate |
NUMBER |
n/a |
Creation date. |
modificationDate |
NUMBER |
n/a |
Last modified date. |
top of page
jiveMessageProp (Message Properties)
Column Name |
Type |
Length |
Description |
messageID |
NUMBER |
n/a |
Message ID. |
name |
VARCHAR |
100 |
Property name. |
propValue |
VARCHAR |
4000 |
Property value. |
top of page
jiveModeration (Audit Table for Moderation Decisions)
Column Name |
Type |
Length |
Description |
objectID |
NUMBER |
n/a |
Object ID of object which has had a change in moderation value. |
objectType |
NUMBER |
n/a |
Object Type (e.g., Message, Thread). |
userID |
NUMBER |
n/a |
User ID of user who made moderation decision. |
modDate |
NUMBER |
n/a |
Date of modification/decision. |
modValue |
NUMBER |
n/a |
Resulting moderation value. |
top of page
jiveNNTPReadStatSession (NNTP-Specific Read Stats Info)
Column Name |
Type |
Length |
Description |
creationDate |
NUMBER |
n/a |
The date the session was created. |
endDate |
NUMBER |
n/a |
The date the session ended. |
bytesReceived |
NUMBER |
n/a |
The number of bytes sent out for the entirety of the session. |
bytesSent |
NUMBER |
n/a |
The number of bytes transferred over the session. |
IP |
VARCHAR |
16 |
The visitor's IP. |
country |
VARCHAR |
4 |
The country code of the visitor. |
sessionID |
NUMBER |
n/a |
ID of the read stat session. |
top of page
jivePMessage (Private Messages)
Column Name |
Type |
Length |
Description |
pMessaegID |
NUMBER |
n/a |
Private message ID (Primary Key). |
ownerID |
NUMBER |
n/a |
The user whose mailbox the private message is in. For example, the
ownerID is different from the recipient ID when the message is a
draft. |
senderID |
NUMBER |
n/a |
The user who sent the private message. |
recipientID |
NUMBER |
n/a |
The user who received the private message. |
subject |
VARCHAR |
255 |
The subject of the private message. |
body |
LONG VARCHAR/CLOB/TEXT |
n/a |
The body of the private message. |
readStatus |
NUMBER |
n/a |
The read status - read or unread. |
folderID |
NUMBER |
n/a |
The ID of the folder the message lives in. |
pMessageDate |
NUMBER |
n/a |
The private message creation date. |
top of page
jivePMessageFldr (Private Message Folders)
Column Name |
Type |
Length |
Description |
folderID |
NUMBER |
n/a |
Private message folder ID (Primary Key). |
userID |
NUMBER |
n/a |
Owner of the folder. |
name |
VARCHAR |
255 |
Name of the folder. |
top of page
jivePMessageProp (Private Message Properties)
Column Name |
Type |
Length |
Description |
pMessageID |
NUMBER |
n/a |
Private message ID (Primary Key). |
name |
VARCHAR |
100 |
Property name. |
propValue |
VARCHAR |
4000 |
Property value. |
top of page
jivePoll (Polls)
Column Name |
Type |
Length |
Description |
pollID |
NUMBER |
n/a |
Poll ID (Primary Key) |
objectType |
NUMBER |
n/a |
Object type associated with the poll. |
objectID |
NUMBER |
n/a |
Object ID the poll is associated with. |
userID |
NUMBER |
n/a |
The user who posted the poll or NULL if it was anonymous. |
name |
VARCHAR |
255 |
Poll Name |
description |
VARCHAR |
4000 |
Poll Description |
pollMode |
NUMBER |
n/a |
A mask for various poll options. |
creationDate |
NUMBER |
n/a |
Creation date. |
modificationDate |
NUMBER |
n/a |
Last modified date. |
startDate |
NUMBER |
n/a |
The date the poll becomes active. |
endDate |
NUMBER |
n/a |
The date the poll becomes inactive. |
expireDate |
NUMBER |
n/a |
The date the poll will be deleted from the system. |
top of page
jivePollOption (Poll options)
Column Name |
Type |
Length |
Description |
pollID |
NUMBER |
n/a |
Poll ID (Primary Key). |
optionIndex |
NUMBER |
n/a |
The index of the poll option for ordering (Primary Key). |
optionText |
VARCHAR |
255 |
The name of the option. |
top of page
jivePollVote (Stores Votes in Polls)
Column Name |
Type |
Length |
Description |
pollID |
NUMBER |
n/a |
Poll ID (Primary Key). |
userID |
NUMBER |
n/a |
The user who voted. |
guestID |
VARCHAR |
255 |
A unique identifier for a guest to prevent double voting. |
optionIndex |
NUMBER |
n/a |
The index of the option the poll is tied to. |
voteDate |
NUMBER |
n/a |
The date the vote was made. |
top of page
jiveQuestion (Questions)
Column Name |
Type |
Length |
Description |
threadID |
NUMBER |
n/a |
ID of the thread associated with this thread (Primary Key). |
forumID |
NUMBER |
n/a |
The ID of the forum the question is in. |
userID |
NUMBER |
n/a |
The user who created the question. |
creationDate |
NUMBER |
n/a |
Creation date of the question. |
resolutionDate |
NUMBER |
n/a |
The date the question was resolved (can be NULL). |
resolutionState |
NUMBER |
n/a |
The state the question is in. |
top of page
jiveQuestionProp (Question Properties)
Column Name |
Type |
Length |
Description |
questionID |
NUMBER |
n/a |
Question ID (Primary Key). |
name |
VARCHAR |
100 |
Property name. |
propValue |
VARCHAR |
4000 |
Property value. |
top of page
jiveProfileField (Profile Fields)
Column Name |
Type |
Length |
Description |
fieldID |
NUMBER |
n/a |
The ID of the field (Primary key) |
name |
VARCHAR |
255 |
The name of the field |
description |
TEXT |
n/a |
The description of the field |
required |
NUMBER |
n/a |
Whether or not the field is required |
filterable |
NUMBER |
n/a |
Whether or not the field is filterable |
searchable |
NUMBER |
n/a |
Whether or not the field is searchable |
visible |
NUMBER |
n/a |
Whether or not the field is visible |
editable |
NUMBER |
n/a |
Whether or not the field is editable |
fieldType |
NUMBER |
n/a |
The type of field |
idx |
NUMBER |
n/a |
The index of the field in the field list |
top of page
jiveProfileFieldOption (Profile Field Options)
Column Name |
Type |
Length |
Description |
fieldID |
NUMBER |
n/a |
The ID of the field (Primary Key) |
value |
VARCHAR |
255 |
The value of the option |
idx |
NUMBER |
n/a |
The index of the option in the option list |
defaultOption |
NUMBER |
n/a |
The default option index |
top of page
jiveProperty (Jive Configuration Data)
Column Name |
Type |
Length |
Description |
name |
VARCHAR |
100 |
Property name (Primary Key). |
propValue |
VARCHAR |
4000 |
Property value. |
top of page
jiveRating (Object Ratings)
Column Name |
Type |
Length |
Description |
objectID |
NUMBER |
n/a |
ID of the object the rating is associated with. |
objectType |
NUMBER |
n/a |
Type of object the rating is associated with. |
userID |
NUMBER |
n/a |
The user making the rating. |
score |
NUMBER |
n/a |
The score of the rating. |
top of page
jiveRatingType (Rating Types)
Column Name |
Type |
Length |
Description |
score |
NUMBER |
n/a |
The score value of the rating. |
description |
VARCHAR |
255 |
The description of the rating, ie "Helpful". |
top of page
jiveReadStat (Read Statistics)
Column Name |
Type |
Length |
Description |
readStatID |
NUMBER |
n/a |
ID of the read stat. |
userID |
NUMBER |
n/a |
ID of the user making the read. |
objectType |
NUMBER |
n/a |
Type of object being read. |
objectID |
NUMBER |
n/a |
The ID of the object being read. |
creationDate |
NUMBER |
n/a |
The date of the object read. |
sessionID |
NUMBER |
n/a |
The ID of the session where the read stat occurred. |
top of page
jiveReadStatSession (Read Statistics Sessions)
Column Name |
Type |
Length |
Description |
sessionID |
NUMBER |
n/a |
ID of the read stat session. |
visitorID |
VARCHAR |
32 |
A unique identifier for a user or a guest. |
creationDate |
NUMBER |
n/a |
The date the session was created. |
top of page
jiveReadTracker (Tracks Which Messages a User has Read)
Column Name |
Type |
Length |
Description |
userID |
NUMBER |
n/a |
User ID of reader (Primary Key). |
objectType |
NUMBER |
n/a |
Type of Object read (thread, message, etc.) (Primary Key). |
objectID |
NUMBER |
n/a |
ID of object read (Primary Key). |
readDate |
NUMBER |
n/a |
Date read. |
top of page
jiveReward (Tracks Reward Points Given)
Column Name |
Type |
Length |
Description |
userID |
NUMBER |
n/a |
User ID. |
creationDate |
NUMBER |
n/a |
Creation date. |
rewardPoints |
NUMBER |
n/a |
Reward points. |
messageID |
NUMBER |
n/a |
Message ID for which points were awarded. |
threadID |
NUMBER |
n/a |
Thread ID for which points were awarded. |
top of page
jiveSearch (Logs all Searches)
Column Name |
Type |
Length |
Description |
searchID |
NUMBER |
n/a |
Search ID (Primary Key). |
searchType |
NUMBER |
n/a |
The type of search. For Jive Forums this will always be the same
value. |
userID |
NUMBER |
n/a |
ID of the user initiating the search |
query |
TEXT |
n/a |
The search query that was executed. |
searchDuration |
NUMBER |
n/a |
Time in milliseconds of search execution. |
numResults |
NUMBER |
n/a |
The number of search results returned. |
searchDate |
NUMBER |
n/a |
The date the search was made. |
top of page
jiveSearchClick (Logs all Clicks on Search Results)
Column Name |
Type |
Length |
Description |
searchID |
NUMBER |
n/a |
Search ID (Primary Key). |
messageID |
NUMBER |
n/a |
The ID of the message that was clicked. |
clickDate |
NUMBER |
n/a |
The date the result was clicked. |
top of page
jiveSearchCriteria (Logs all Search Criteria)
Column Name |
Type |
Length |
Description |
searchID |
NUMBER |
n/a |
Search ID. |
criteriaName |
VARCHAR |
100 |
The name of the search criteria. |
criteriaValue |
VARCHAR |
4000 |
The value of the search criteria. |
top of page
jiveSkill (Skill Matrix)
Column Name |
Type |
Length |
Description |
skillID |
NUMBER |
n/a |
Primary Key |
name |
VARCHAR |
255 |
The name of the skill |
inherit |
NUMBER |
n/a |
Whether or not this skill inherits from a parent set of skills |
parentID |
NUMBER |
n/a |
The ID of the parent skill |
idx |
NUMBER |
n/a |
The index of the skill in the skill list |
depth |
NUMBER |
n/a |
The heirarchical level of the skill (ie, 3 levels from the
root) |
top of page
jiveSkillValue (Skill Matrix Values)
Column Name |
Type |
Length |
Description |
valueID |
NUMBER |
n/a |
Primary key |
skillID |
NUMBER |
n/a |
The skill id this value relates to |
name |
VARCHAR |
255 |
The name of the skill value |
description |
TEXT |
n/a |
The skill's description |
value |
NUMBER |
n/a |
The value of the skill |
top of page
jiveStatusLevel (Status Levels)
Column Name |
Type |
Length |
Description |
statusLevelID |
NUMBER |
n/a |
ID of the status level (Primary Key). |
name |
VARCHAR |
255 |
Status level name. |
description |
VARCHAR |
4000 |
Status level description. |
forumID |
NUMBER |
n/a |
The ID of the forum the question is in. |
imagePath |
VARCHAR |
255 |
Path to an image for this status level (not null). |
largeImagePath |
VARCHAR |
255 |
Path to a large image for this status level (null). |
minPoints |
NUMBER |
n/a |
The minimum points for this status level. |
maxPoints |
NUMBER |
n/a |
The minimum points for this status level. |
groupID |
NUMBER |
n/a |
The ID of the group associated with this status level. |
top of page
jiveStatusLevelProp (Status Level Properties)
Column Name |
Type |
Length |
Description |
statusLevelID |
NUMBER |
n/a |
Status Level ID (Primary Key). |
name |
VARCHAR |
100 |
Property name. |
propValue |
VARCHAR |
4000 |
Property value. |
top of page
jiveThemeMap (Theme Mappings)
Column Name |
Type |
Length |
Description |
theme |
VARCHAR |
32 |
The name of the theme |
mapType |
VARCHAR |
16 |
The type of mapping this is (constants defined in application) |
numValue |
NUMBER |
n/a |
The ID mapping (if it's a forum or category type theme) |
stringValue |
VARCHAR |
100 |
The value of the mapping (if this is a URL or locale type
theme) |
top of page
jiveThread (Thread Data)
Column Name |
Type |
Length |
Description |
threadID |
NUMBER |
n/a |
Thread ID (Primary Key). |
forumID |
NUMBER |
n/a |
ID of forum that thread belongs to. |
rootMessageID |
NUMBER |
n/a |
ID of root message in thread. |
modValue |
NUMBER |
n/a |
Moderation Value of Thread |
rewardPoints |
NUMBER |
n/a |
Reward Points available in this Thread |
creationDate |
NUMBER |
n/a |
Creation date. |
modificationDate |
NUMBER |
n/a |
Last modified date. |
top of page
jiveThreadProp (Thread Properties)
Column Name |
Type |
Length |
Description |
threadID |
NUMBER |
n/a |
Thread ID. |
name |
VARCHAR |
100 |
Property name. |
propValue |
VARCHAR |
4000 |
Property value. |
top of page
jiveUser (User Data)
Column Name |
Type |
Length |
Description |
userID |
NUMBER |
n/a |
User ID (Primary Key). |
username |
VARCHAR |
30 |
Username. |
passwordHash |
VARCHAR |
32 |
Password Data (hex-encoded MD5 hash of actual password). |
name |
VARCHAR |
100 |
Full name. |
nameVisible |
NUMBER |
n/a |
Privacy flag for showing name to other users (Boolean). |
email |
VARCHAR |
100 |
Email address. |
emailVisible |
NUMBER |
n/a |
Privacy flag for showing email to other users (Boolean). |
creationDate |
NUMBER |
n/a |
Creation date. |
modificationDate |
NUMBER |
n/a |
Last modified date. |
top of page
jiveUserPerm (Permissions for Users)
Column Name |
Type |
Length |
Description |
objectType |
NUMBER |
n/a |
Type of object (system, category, forum). |
objectID |
NUMBER |
n/a |
ID of the object being referenced by the objectType column. |
userID |
NUMBER |
n/a |
The ID of the user being granted the permission. |
permissionType |
NUMBER |
n/a |
Indicates the type of perm - additive or negative. |
permission |
NUMBER |
n/a |
Bitmask of permissions the user has on the object. |
top of page
jiveUserProfile (User Extended Profile)
Column Name |
Type |
Length |
Description |
userID |
NUMBER |
n/a |
The ID if the user this profile is associated with |
fieldID |
NUMBER |
n/a |
The ID of the field |
value |
VARCHAR |
255 |
The value set for the field |
top of page
jiveUserProp (User Properties)
Column Name |
Type |
Length |
Description |
userID |
NUMBER |
n/a |
User ID (Primary Key). |
name |
VARCHAR |
100 |
Property name. |
propValue |
VARCHAR |
4000 |
Property value. |
top of page
jiveUserReward (Tracks a User's Reward Points)
Column Name |
Type |
Length |
Description |
userID |
NUMBER |
n/a |
User ID (Primary Key). |
rewardPoints |
NUMBER |
n/a |
Reward points for user. |
top of page
jiveUserRoster (Buddy List Data -- For Future Use)
Column Name |
Type |
Length |
Description |
userID |
NUMBER |
n/a |
User ID (Primary Key). |
subUserID |
NUMBER |
n/a |
User ID of roster member (Primary Key). |
top of page
jiveUserSkillValue (User skill value link table)
Column Name |
Type |
Length |
Description |
skillID |
NUMBER |
n/a |
The ID of the skill |
valueID |
NUMBER |
n/a |
The value ID |
userID |
NUMBER |
n/a |
The ID of the user |
top of page
jiveViewCount (Tracks Number of Reads on Categories, Threads, etc)
Column Name |
Type |
Length |
Description |
objectID |
NUMBER |
n/a |
ID of the object (Primary Key). |
objectType |
NUMBER |
n/a |
The type of the object (Primary Key). |
parentObjectID |
NUMBER |
n/a |
ID of the object that this object "belongs" to. For example, a
thread belongs to a forum, a forum belongs to a category, etc. |
viewCount |
NUMBER |
n/a |
Number of times the object has been read. |
top of page
jiveWatch (Tracks Users Watching Categories, Forums, Threads,
Users)
Column Name |
Type |
Length |
Description |
userID |
NUMBER |
n/a |
ID of user who is watching (Primary Key). |
objectID |
NUMBER |
n/a |
ID of the object being watched (Primary Key). |
objectType |
NUMBER |
n/a |
The type of the object being watched (forum, thread, category, user)
(Primay Key). |
watchType |
NUMBER |
n/a |
Type of watch (normal watch, email watch, batch email watch)
(Primary Key). |
expirable |
NUMBER |
n/a |
Flag to indicate if the watch be automatically deleted/expired
(Boolean). |
top of page
jiveWatchSettings (User Watch Settings)
Column Name |
Type |
Length |
Description |
userID |
NUMBER |
n/a |
The ID of the user these settings relate to |
autoWatchNewTopics |
NUMBER |
n/a |
Whether or not to automatically watch new topics |
autoWatchReplies |
NUMBER |
n/a |
Whether or not to automatically watch topics you reply to |
receiveEmails |
NUMBER |
n/a |
Whether or not emails are received from watches |
batchFrequency |
NUMBER |
n/a |
The frequency at which batch watches are sent (constant defined in
the application) |
lastBatchEmail |
NUMBER |
n/a |
The time the last batch watch email was sent |
top of page