Jive v6 Core Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

sbs6a.public contains 1585 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
jiveoauthclientaccesstoken accesstoken varchar 127  √  null
jiveoauthtoken accesstoken varchar 127  √  null
jiveoauthtoken accesstokenexp int8 19  √  null
jivewfcurrentstep actionid int2 5  √  null
jivewfhistorystep actionid int4 10  √  null
jiveoauthpairing activationdate int8 19  √  null
jivestreamentry activityfaviconurl varchar 1024  √  null
jivestreamentry activityid varchar 3500  √  null
jivestreamentry activityidmd5 varchar 127  √  null
jivestreamentry activityspec varchar 32  √  null
jiveattachtypes allowedtype varchar 50  √  null
jivedocbodytypes allowedtype varchar 50  √  null
jiveapperror appid int8 19  √  null
jivebinmetadata appinstanceid int8 19  √  null
jiveapp apppath varchar 127  √  null
jiveapprovalwrkflw approvaltime int8 19  √  null
jiveappaction appview varchar 255  √  null
jiveptask assignorid int8 19  √  null
jiveban banneduserid int8 19  √  null
jiveblogpost body text 2147483647  √  null
jivecontent body text 2147483647  √  null
jivecontentbackup body text 2147483647  √  null
jivedraft body text 2147483647  √  null
jivemessage body text 2147483647  √  null
jiveptask body varchar 3500  √  null
jivestreamentry body varchar 1024  √  null
jivetermsandcond body text 2147483647  √  null
jivedocumentbody bodytext text 2147483647  √  null
jivewidget bridgeid int8 19  √  null
jivewfcurrentstep caller varchar 100  √  null
jivewfhistorystep caller varchar 100  √  null
jiveoauthtoken clientsecret varchar 127  √  null
jiveblog cmauthentication int2 5  √  null
jiveabuse comments varchar 255  √  null
jiveban comments varchar 50  √  null
jivequestprogress completiondate int8 19  √  null
jivepageviewconfig configxml text 2147483647  √  null
jivelicenseconfirm confirmationbody text 2147483647  √  null
jivelicenseconfirm confirmationbodye text 2147483647  √  null
jivecontent containerid int8 19  √  null
jivecontent containertype int8 19  √  null
jivebinmetadata contentencoding varchar 255  √  null
jivebinmetadata contentlanguage varchar 255  √  null
jivebinmetadata contentlength int8 19  √  null
jivebinmetadata contentlocation varchar 2000  √  null
jivebinmetadata contentmd5 varchar 255  √  null
jivebinmetadata contenttype varchar 255  √  null
jivedocumentbody contenttype varchar 100  √  null
jivedvrevartifact contenttype varchar 100  √  null
jiveoauthstore contextid int8 19  √  null
jiveactivityhistry createcount int4 10  √  null
jivecontent creationdate int8 19  √  null
jiveentitlement creationdate int8 19  √  null
jiverating creationdate int8 19  √  null
jivecustompermlvl creatorid int8 19  √  null
jiveappalert creatorname varchar 1024  √  null
jiveappinstalert creatorname varchar 1024  √  null
jiveappalert creatoruserid int8 19  √  null
jiveappinstalert creatoruserid int8 19  √  null
jivecnxtauthstyle credentialstypes varchar 255  √  null
jiveplugin data bytea 2147483647  √  null
jivesession data bytea 2147483647  √  null
jiveospropentry datavalue bytea 2147483647  √  null
jiveospropentry datevalue int8 19  √  null
jivefield defvalue varchar 255  √  null
jivebinmetadata description varchar 2000  √  null
jiveblog description varchar 1000  √  null
jivebridge description varchar 255  √  null
jivecnxtauthstyle description varchar 2048  √  null
jivecnxtcredtype description varchar 2048  √  null
jivecnxtendpoint description varchar 2048  √  null
jivecnxttag description varchar 2048  √  null
jivecommunity description varchar 1000  √  null
jivedoctype description varchar 1000  √  null
jivefield description varchar 1000  √  null
jivefieldtype description varchar 1000  √  null
jivegroup description varchar 1000  √  null
jiveoauthclient description varchar 1000  √  null
jiveobjpermlvl description varchar 255  √  null
jiveocbmetadata description varchar 2000  √  null
jivepcheckpoint description varchar 1000  √  null
jivepoll description text 2147483647  √  null
jiveproject description varchar 1000  √  null
jivesearchengine description varchar 2000  √  null
jivesgroup description varchar 1000  √  null
jivestatics description varchar 1000  √  null
jivestatuslevel description varchar 1000  √  null
jivetagset description varchar 1000  √  null
jivesearchengine descriptorurl varchar 2000  √  null
jiveauditlog details varchar 2048  √  null
jivegateway disablecutoffdate int4 10  √  null
jiveattachtypes disallowedtype varchar 50  √  null
jivedocbodytypes disallowedtype varchar 50  √  null
jivebinmetadata displayname varchar 255  √  null
jiveblog displayname varchar 255  √  null
jivebrowsecntr displayname varchar 255  √  null
jivecnxtauthstyle displayname varchar 255  √  null
jivecnxtcredtype displayname varchar 255  √  null
jivecnxtendpoint displayname varchar 255  √  null
jivecnxttag displayname varchar 255  √  null
jivecnxtendpoint documentationurl varchar 2048  √  null
jiveattachment documentid varchar 255  √  null
jiveproject duedate int8 19  √  null
jiveptask duedate int8 19  √  null
jivewfcurrentstep duedate timestamp 29,6  √  null
jivewfhistorystep duedate timestamp 29,6  √  null
jiveappalert effectivedate int8 19  √  null
jiveappinstalert effectivedate int8 19  √  null
jivecomment email varchar 100  √  null
jiveinvite email varchar 100  √  null
jiveannounce enddate int8 19  √  null
jivewfcurrentstep entryid int8 19  √  null
jivewfhistorystep entryid int8 19  √  null
jivedvrevision evidocid varchar 50  √  null
jivedvrevision eviprevversionid varchar 50  √  null
jivedvrevision eviversionid varchar 50  √  null
jiveoauthstore expiration int8 19  √  null
jiveban expirationdate int8 19  √  null
jiveoauthpairing expirationdate int8 19  √  null
jiveoauthtoken expirationdate int8 19  √  null
jivesession expires int8 19  √  null
jiveprofilefield extmapping varchar 2048  √  null
jivegroup federated int2 5  √  null
jiveblog feedenabled int2 5  √  null
jiveblog feedfullcontent int2 5  √  null
jivedocumentaudit fieldid int8 19  √  null
jiveosappdata fieldsize int4 10  √  null
jiveosappdata fieldtype varchar 255  √  null
jiveosappdata fieldvalue text 2147483647  √  null
jivedocumentbody filename varchar 255  √  null
jivedvrevartifact filename varchar 255  √  null
jivedocumentbody filesize int4 10  √  null
jiveocbmetadata filesize int8 19  √  null
jivewfcurrentstep finishdate timestamp 29,6  √  null
jivewfhistorystep finishdate timestamp 29,6  √  null
jiveuser firstname varchar 100  √  null
jiveospropentry floatvalue float8 17,17  √  null
jivefieldtype formatter varchar 255  √  null
jivedoctypeelement frowversion int8 19  √  null
jivefield frowversion int8 19  √  null
jiveapp gadgethash varchar 127  √  null
jiveospropentry globalkey varchar 150  √  null
jiveentitlement groupid int8 19  √  null
jivepollvote guestid varchar 255  √  null
jivedvrevision hashbytes varchar 255  √  null
jiveappaction iconurl varchar 2048  √  null
jivecnxtendpoint iconurl varchar 2048  √  null
jivesearchengine iconurl varchar 2000  √  null
jiveappview initialheights varchar 127  √  null
jiveappview instanceappid int8 19  √  null
jiveocbmetadata instanceappid int8 19  √  null
jiveapp internalname varchar 255  √  null
jiveinvite inviterid int8 19  √  null
jivecomment ip varchar 15  √  null
jiveban ipaddress varchar 15  √  null
jiveospropentry itemkey varchar 150  √  null
jiveospropentry itemtype int4 10  √  null
jiveuserrelgraph labeldirrpt varchar 40  √  null
jiveuserrelgraph labelmanager varchar 40  √  null
jiveuserrelgraph labelpeer varchar 40  √  null
jiveusrrellist labelstyle varchar 200  √  null
jivestatuslevel largeimagepath varchar 255  √  null
jiveoauthaccesslog lastaccess int8 19  √  null
jivesession lastaccess int8 19  √  null
jiveuser lastname varchar 100  √  null
jiveofficecoauthors lastupdatedate int8 19  √  null
jivemetering lastupdatets int8 19  √  null
jiveproject lateststatusid int8 19  √  null
jiveuserprofile levelid int8 19  √  null
jivecommunity localecode varchar 32  √  null
jiveobjpermlvl lvltype varchar 25  √  null
jivesession maxinactive int4 10  √  null
jivedvrevstatus message varchar 3500  √  null
jiveerror message varchar 1024  √  null
jivemarketoutmsg message varchar 3500  √  null
jivethreadlatest messagecount int4 10  √  null
jivethreadlatest messageid int8 19  √  null
jivedvrevision metadata varchar 3500  √  null
jiveexternalurl mimetype varchar 100  √  null
jiveocbmetadata mimetype varchar 255  √  null
jivecontent modificationdate int8 19  √  null
jivecontentprop modificationdate int8 19  √  null
jiveentitlement modificationdate int8 19  √  null
jiveinboxentry modificationdate int8 19  √  null
jiverating modificationdate int8 19  √  null
jivecomment name varchar 100  √  null
jivepermlevel name varchar 25  √  null
jiveuser name varchar 100  √  null
jivewfentry name varchar 20  √  null
jivesystemjob nodeid varchar 512  √  null
jiveappalert notes varchar 1024  √  null
jiveappinstalert notes varchar 1024  √  null
jivebookmark notes varchar 3500  √  null
jiveospropentry numbervalue int8 19  √  null
jivefieldvalue numvalue int8 19  √  null
jivethememap numvalue int8 19  √  null
jiveannounce objectid int8 19  √  null
jiveattachment objectid int8 19  √  null
jiveimage objectid int8 19  √  null
jivestreamentry objectid int8 19  √  null
jiveuuid objectid int8 19  √  null
jivestreamentry objectmediatype varchar 32  √  null
jivestreamentry objecttitle varchar 1024  √  null
jivedraft objecttype int4 10  √  null
jivestreamentry objecttype int4 10  √  null
jiveuuid objecttype int4 10  √  null
jivedefobjpermlvl objtype int8 19  √  null
jiveobjpermlvl objtype int8 19  √  null
jivepermlvlmsk objtype int8 19  √  null
jivedocumentaudit oldvalue text 2147483647  √  null
jiveoauthpairing onetimecode varchar 24  √  null
jivewfcurrentstep owner varchar 100  √  null
jivewfhistorystep owner varchar 100  √  null
jiveavatar ownerid int8 19  √  null
jiveptask ownerid int8 19  √  null
jivedvrevision packageid int8 19  √  null
jivecomment parentcommentid int8 19  √  null
jivebinmetadata parentid int8 19  √  null
jivemessage parentmessageid int8 19  √  null
jivecomment parentobjectid int8 19  √  null
jivecomment parentobjecttype int4 10  √  null
jivebinmetadata parenttype int4 10  √  null
jiveoauthpasscode passcodeexpiration int8 19  √  null
jivesearchengine password varchar 40  √  null
jiveappaction path varchar 2048  √  null
jiveexternalurl path varchar 3500  √  null
jiveblogpost permalink varchar 255  √  null
jiveblog pingoverride int2 5  √  null
jiveblog pingservices text 2147483647  √  null
jivestatuslevelpntsum pointlevel int8 19  √  null
jiveexternalurl port int4 10  √  null
jivedoctype presenterid int8 19  √  null
jiveexternalurl query varchar 3500  √  null
jivesearchengine querytestterm varchar 40  √  'test'::character varying
jiveexternalurl ref varchar 3500  √  null
jiveoauthtoken refreshtoken varchar 127  √  null
jivestreamentry releasekeysha1 varchar 40  √  null
jivelicenseconfirm remoteconfirmid int8 19  √  null
jivewidget remotewidgetid int8 19  √  null
jivelicensereport reportbodye text 2147483647  √  null
jivelicensereport reportdate int8 19  √  null
jivelicensereport reporter varchar 100  √  null
jivelicenseconfirm reportid int8 19  √  null
jiveapprovalwrkflw requestmessage varchar 255  √  null
jiveinboxentry requestmessage varchar 255  √  null
jivequestion resolutiondate int8 19  √  null
jiveabuse resolved int2 5  √  null
jiveapprovalwrkflw responsemessage varchar 255  √  null
jiveinboxentry responsemessage varchar 255  √  null
jivesystemjob result varchar 3500  √  null
jivegroupuserhist retireddate int8 19  √  null
jiveuserrel retirementdate int8 19  √  0
jiveinvite revokedate int8 19  √  null
jiveinvite revokerid int8 19  √  null
jivesearchengine searchcontenttype varchar 100  √  null
jivesearchengine searchhttpmethod varchar 10  √  'GET'::character varying
jiveinvite sentdate int8 19  √  null
jiveapperror source varchar 1024  √  null
jiveerror source varchar 1024  √  null
jiveapperror sourcedescription varchar 1024  √  null
jiveerror srcobjid int8 19  √  null
jiveerror srcobjtype int8 19  √  null
jivewfcurrentstep startdate timestamp 29,6  √  null
jivewfhistorystep startdate timestamp 29,6  √  null
jivewfentry state int4 10  √  null
jiveapperror status int8 19  √  null
jivecontent status int4 10  √  null
jiveerror status int8 19  √  null
jivewfcurrentstep status varchar 20  √  null
jivewfhistorystep status varchar 20  √  null
jiveprojectstatus statusdesc varchar 255  √  null
jivewfcurrentstep stepid int2 5  √  null
jivewfhistorystep stepid int4 10  √  null
jiveospropentry stringvalue varchar 255  √  null
jivethememap stringvalue varchar 100  √  null
jivefieldvalue strvalue varchar 3500  √  null
jiveappaction style varchar 255  √  null
jivelabel style varchar 200  √  null
jiveblogpost subject varchar 255  √  null
jivebookmark subject varchar 255  √  null
jivebrowsecnt subject varchar 255  √  null
jivecontent subject varchar 255  √  null
jivedraft subject varchar 255  √  null
jivemessage subject varchar 255  √  null
jiveannounce subjecturl varchar 255  √  null
jiveerror subjobjid int8 19  √  null
jiveerror subjobjtype int8 19  √  null
jivedocversion summary text 2147483647  √  null
jivestreamentry summary varchar 3500  √  null
jiveapp syslicenseurlmd5 varchar 127  √  null
jiveapp systemlicenseurl varchar 1024  √  null
jivewikilink targetanchortext varchar 3500  √  null
jivewikilink targetattachmentid int8 19  √  null
jivewikilink targetdescription varchar 3500  √  null
jivestreamentry targetid int8 19  √  null
jivewikilink targetobjectid int8 19  √  null
jivewikilink targetobjecttype int4 10  √  null
jivewikilink targettext varchar 3500  √  null
jivestreamentry targettype int4 10  √  null
jivewikilink targeturl varchar 3500  √  null
jivepresenter template text 2147483647  √  null
jiveoauthpairing temppasscodeencoded varchar 32  √  null
jiveappactiontext text text 2147483647  √  null
jivestreamenttext text text 2147483647  √  null
jiveappview title varchar 128  √  null
jiveexternalurl title varchar 1000  √  null
jivestreamentry title varchar 420  √  null
jiveofficecoauthors ttl int8 19  √  null
jivewidget type varchar 255  √  null
jivestreamentry unmappedvalues text 2147483647  √  null
jivecomment url varchar 255  √  null
jiveexternallogin url varchar 255  √  null
jivestreamaction url varchar 3500  √  null
jiveactivity userid int8 19  √  null
jiveanswer userid int8 19  √  null
jivecomment userid int8 19  √  null
jivecontent userid int8 19  √  null
jivedocumentaudit userid int8 19  √  null
jivedraft userid int8 19  √  null
jiveentitlement userid int8 19  √  null
jiveinvite userid int8 19  √  null
jivemessage userid int8 19  √  null
jivepoll userid int8 19  √  null
jivepollvote userid int8 19  √  null
jiveptask userid int8 19  √  null
jiverating userid int8 19  √  null
jivesearchengine username varchar 40  √  null
jiveuserstatus userstatustext text 2147483647  √  null
jivedoctype validator varchar 255  √  null
jivefieldtype validator varchar 255  √  null
jivelabelelement value varchar 255  √  null
jiveuserprofile value varchar 3500  √  null
jiveuuid version int4 10  √  null
jiveactivityhistry viewcount int4 10  √  null
jiveviewcount viewcount int8 19  √  0
jiveappaction viewtarget varchar 255  √  null
jivecommunity workflowid int8 19  √  null
jivedocument workflowid int8 19  √  null
jivesgroupmember workflowid int8 19  √  null
jiveuserrel workflowid int8 19  √  null
jivecnxtendpoint wsdlurl varchar 2048  √  null
jiveabuse abuseid int8 19
jiveabuse abusetype int8 19
jivelicenseconfirm accepted int4 10
jiveapiaccessor accessorid int8 19
jiveapientitlement accessorid int8 19
jiveobjapiaccessor accessorid int8 19
jiveapiaccessor accessortype int4 10
jivebintoken accesstokenid int8 19
jiveocbtoken accesstokenid int8 19
jiveacccontainer acclaimid int8 19
jiveacclaim acclaimid int8 19
jiveacclaimprop acclaimid int8 19
jiveacclaimvote acclaimid int8 19
jiveacclaim acclaimtype varchar 20
jiveappinstalert acknowledged int8 19
jiveappaction actionid int8 19
jiveappactiontext actionid int8 19
jivebridgedcont active int4 10
jiveactivity activityid int8 19
jiveactivity activitytype int4 10
jiveban adminid int8 19
jivegroupuser administrator int4 10
jivegroupuserhist administrator int4 10
jivecnxtconnection alias varchar 255
jiveattachsettings allowbydefault int2 5
jivedocbodyconfig allowbydefault int4 10
jivefield alterable int2 5
jivedocumentaudit alterdate int8 19
jivedocumentaudit altertype int8 19
jiveuserannprop annid int8 19
jiveannounce announcementid int8 19
jiveannounceprop announcementid int8 19
jiveoauthtoken apiaccessorid int8 19
jivesession app varchar 100
jiveappalert appalertid int8 19
jiveappalertack appalertid int8 19
jiveosappdata appdataid int8 19
jiveapperror apperrorid int8 19
jiveapp appid int8 19
jiveappaction appid int8 19
jiveappalert appid int8 19
jiveinstanceapp appid int8 19
jiveosfileitem appid varchar 255
jiveappinstalert appinstalertid int8 19
jivecnxtconnection appinstanceid int8 19
jiveinstanceapp appinstanceuuid varchar 128
jiveuserrelgraph approvalsenabled int2 5 0
jiveapprovalwrkflw approved int2 5
jiveinstanceapp appurl varchar 1024
jiveinstanceapp appurlmd5 varchar 127
jiveapp appuuid varchar 127
jiveocservicestats appuuid varchar 127
jiveappview appviewid int8 19
jivecredential artifactid int8 19
jivedvrevartifact artifacttype varchar 20
jiveattachment attachmentid int8 19
jiveattachmentdl attachmentid int8 19
jiveattachmentprop attachmentid int8 19
jiveattachversion attachmentid int8 19
jiveappactiontext attribute int4 10
jivestreamenttext attribute int4 10
jiveauditlog auditmessageid int8 19
jivesearchengine authenticated int2 5 0
jivebrowsecnt authorid int8 19
jivecnxtauthstyle authstyleid int8 19
jivecnxtendpoint authstyleid int8 19
jiveavatar avatarid int8 19
jiveavatarprop avatarid int8 19
jiveavataruser avatarid int8 19
jiveban banid int8 19
jiveban banlevel int4 10
jiveban bantype int4 10
jivesystemjob beanid varchar 1024
jivebinmetadata binarymetadataid int8 19
jivebintoken binarymetadataid int8 19
jiveocbmetadata binarymetadataid int8 19
jiveocbtoken binarymetadataid int8 19
jivebinstore bindata bytea 2147483647
jivebinstore binkey varchar 255
jiveblog blogid int8 19
jiveblogpost blogid int8 19
jiveblogprop blogid int8 19
jiveblogpost blogpostid int8 19
jiveblogpostprop blogpostid int8 19
jiveannounce body text 2147483647
jivebridgedcontmsg body text 2147483647
jivecomment body text 2147483647
jivedocbodyversion bodyid int8 19
jivedocumentbody bodyid int8 19
jivebridgedcont bridgedcontid int8 19
jivebridgedcontmsg bridgedcontid int8 19
jivermtbridgedcont bridgedcontid int8 19
jivebridgedcontmsg bridgedcontmsgid int8 19
jivebridge bridgeid int8 19
jivebridgeoption bridgeid int8 19
jivebrowsecnt browseid int8 19
jivebrowsecntr browseid int8 19
jivebrowsefol browseid int8 19
jivebrowseprtd browseid int8 19
jivedevsettings cacheon int2 5
jiverenderedcontent cacheversion int8 19
jivestatuslevelpntsum calculationdate int8 19
jivestreamchannel channelsigmd5 varchar 127
jivestreamchannel channelsignature varchar 3500
jivepcheckpoint checkpointid int8 19
jivewidget classname varchar 255
jivewlayout classname varchar 255
jiveoauthclient clientid varchar 64
jiveoauthtoken clientid varchar 64
jiveoauthclient clientsecret varchar 127
jiveappalert code int8 19
jiveapperror code int8 19
jiveappinstalert code int8 19
jiveerror code int8 19
jivemarketoutmsg code int8 19
jiveobjecttype code varchar 255
jivestatlvlscen code varchar 20
jivestatuslevelpnt code varchar 20
jivedoccollab collaboratortype int2 5
jivedashboard columncount int4 10
jiveappview columnnumber int4 10 0
jivecomment commentid int8 19
jivecommentprop commentid int8 19
jivedocversioncmmt comments text 2147483647
jiveblogpost commentstatus int4 10
jivedocument commentstatus int4 10
jivecommunity communityid int8 19
jivecommunityprop communityid int8 19
jivegateway communityid int8 19
jiveptask completed int4 10
jivesystemjob completedon int8 19 0
jivemetering component varchar 255
jivepageviewconfig component varchar 255
jivelicenseconfirm confirmationdate int8 19
jivelicenseconfirm confirmationid int8 19
jivecnxtconnection connectionid int8 19
jiveacccontainer containerid int8 19
jiveactivity containerid int8 19
jiveanswer containerid int8 19
jiveblog containerid int8 19 (-2)
jivebrowsecnt containerid int8 19
jivebrowsecntr containerid int8 19
jivecontaineraprvr containerid int8 19
jivedashboard containerid int8 19
jivedocument containerid int8 19
jiveentlmntinherit containerid int8 19
jivefeatured containerid int8 19
jivefollow containerid int8 19
jiveformattedtext containerid int8 19
jivemessage containerid int8 19
jivepopularity containerid int8 19
jivequestion containerid int8 19
jivestatuslevelpnt containerid int8 19
jivestatuslevelpntsum containerid int8 19
jivetagcloud containerid int8 19
jivetagset containerid int8 19
jivethread containerid int8 19
jiveuserstatus containerid int8 19 (-1)
jivewidgetframe containerid int4 10
jiveacccontainer containertype int4 10
jiveactivity containertype int4 10
jiveanswer containertype int8 19
jiveblog containertype int4 10 17
jivebrowsecnt containertype int4 10
jivebrowsecntr containertype int4 10
jivecontaineraprvr containertype int4 10
jivedashboard containertype int4 10
jivedocument containertype int4 10
jiveentlmntinherit containertype int4 10
jivefeatured containertype int4 10
jivefollow containertype int4 10
jiveformattedtext containertype int4 10
jivemessage containertype int4 10
jivepopularity containertype int4 10
jivequestion containertype int8 19
jivestatuslevelpnt containertype int8 19
jivestatuslevelpntsum containertype int8 19
jivetagcloud containertype int4 10
jivetagset containertype int4 10
jivethread containertype int4 10
jiveuserstatus containertype int4 10 (-1)
jivebridgedcont contentid int8 19
jivecontent contentid int8 19
jivecontentmeta contentid int8 19
jivecontentprop contentid int8 19
jiveattachment contenttype varchar 100
jivebridgedcont contenttype int8 19
jivecontent contenttype int8 19
jivecontentmeta contenttype int4 10
jivecontentprop contenttype int8 19
jiveentitlement contenttype int4 10
jiveimage contenttype varchar 50
jiveextcontext contextid int8 19
jiveappaction contributionid varchar 1024
jiveanswer correctanswer int2 5
jiveacclaim creationdate int8 19
jiveacclaimvote creationdate int8 19
jiveactivity creationdate int8 19
jiveactivityhistry creationdate int8 19
jiveannounce creationdate int8 19 0
jiveapientitlement creationdate int8 19
jiveapp creationdate int8 19
jiveappaction creationdate int8 19
jiveappalert creationdate int8 19
jiveappalertack creationdate int8 19
jiveapperror creationdate int8 19
jiveappinstalert creationdate int8 19
jiveappview creationdate int8 19
jiveattachment creationdate int8 19
jiveban creationdate int8 19
jivebinmetadata creationdate int8 19
jivebintoken creationdate int8 19
jiveblog creationdate int8 19
jiveblogpost creationdate int8 19
jivebookmark creationdate int8 19
jivebridge creationdate int8 19
jivebridgedcontmsg creationdate int8 19
jivebrowsecnt creationdate int8 19
jivebrowsecntr creationdate int8 19
jivecnxtauthstyle creationdate int8 19
jivecnxtconnection creationdate int8 19
jivecnxtcredtype creationdate int8 19
jivecnxtendpoint creationdate int8 19
jivecnxtsvcheader creationdate int8 19
jivecnxtsvcowner creationdate int8 19
jivecnxtsvcprop creationdate int8 19
jivecnxttag creationdate int8 19
jivecomment creationdate int8 19
jivecommunity creationdate int8 19
jivecustompermlvl creationdate int8 19
jivedashboard creationdate int8 19
jivedevsettings creationdate int8 19
jivedocument creationdate int8 19
jivedocumentbody creationdate int8 19
jivedocversion creationdate int8 19
jivedocversioncmmt creationdate int8 19
jivedvrevartifact creationdate int8 19
jivedvrevision creationdate int8 19
jiveeptagjoin creationdate int8 19
jiveerror creationdate int8 19
jiveexternalurl creationdate int8 19
jivefeatured creationdate int8 19
jivefollow creationdate int8 19
jiveformattedtext creationdate int8 19
jiveformtoken creationdate int8 19
jivegroup creationdate int8 19
jivegroupuserhist creationdate int8 19
jivei18ntext creationdate int8 19
jiveimage creationdate int8 19
jiveinboxentry creationdate int8 19
jiveinstanceapp creationdate int8 19
jiveinvite creationdate int8 19
jivemarketoutmsg creationdate int8 19
jivemessage creationdate int8 19
jiveoauthclient creationdate int8 19
jiveoauthclientaccesstoken creationdate int8 19
jiveoauthpairing creationdate int8 19
jiveoauthstore creationdate int8 19
jiveoauthtoken creationdate int8 19
jiveobjecttag creationdate int8 19
jiveobjpermlvlext creationdate int8 19 0
jiveobjpermlvlmap creationdate int8 19 0
jiveobjpermlvlmsk creationdate int8 19 0
jiveobjtypemsk creationdate int8 19 0
jiveocbmetadata creationdate int8 19
jiveocbtoken creationdate int8 19
jiveosfileitem creationdate int8 19
jivepcheckpoint creationdate int8 19
jiveplugin creationdate int8 19
jivepoll creationdate int8 19
jivepopularity creationdate int8 19
jiveproject creationdate int8 19
jiveprojectstatus creationdate int8 19
jiveptask creationdate int8 19
jivequestion creationdate int8 19
jivesgroup creationdate int8 19
jivesgroupmember creationdate int8 19
jivestatics creationdate int8 19
jivestatuslevelpnt creationdate int8 19
jivestreamchannel creationdate int8 19
jivestreamentry creationdate int8 19
jivesystemjob creationdate int8 19
jivetag creationdate int8 19
jivetagset creationdate int8 19
jivethread creationdate int8 19
jiveuser creationdate int8 19
jiveusercontainer creationdate int8 19
jiveuserrel creationdate int8 19
jiveuserstatus creationdate int8 19
jivewikilink creationdate int8 19 0
jiveapprovalwrkflw creationtime int8 19
jivebookmark creatorid int8 19
jivebookmark creatortype int4 10
jivecnxtcredtype credentialstypeid int8 19
jivei18ntext custom int2 5
jiveappview dashboardid int8 19
jivedashboard dashboardid int8 19
jivequestprogress data text 2147483647
jivebinstore datasize int8 19
jivedatatype datatype varchar 20
jivedatatype datatypeid int8 19
jivefieldtype datatypeid int8 19
jivefieldoption defaultoption int4 10
jiveprofilefldopt defaultoption int2 5
jiveprofilefield defaultseclvlid int8 19 1001
jivedeletedobjects deleteddate int8 19
jiveocservicestats delta int8 19
jiveauditlog description varchar 1024
jivecustompermlvl description varchar 255
jiveratingtype description varchar 1000
jivearchivepolicy destcontainerid int4 10
jivearchivepolicy destcontainertype int8 19
jivemovedobjects destinationcontainerid int8 19
jivemovedobjects destinationcontainertype int4 10
jiveapp developmentapp int2 5 0
jivedevsettings devsettingsid int8 19
jivestatuslevelpntsum dirty int2 5
jivebridge disabled int2 5
jivewlayout disabled int4 10 0
jivestreamchannel displayid int4 10 1000
jivecommunity displayname varchar 255
jivedashboard displayname varchar 128
jivefield displayname varchar 100
jivefieldtype displayname varchar 100
jiveoauthpairing displayname varchar 255
jiveocbmetadata displayname varchar 255
jivesgroup displayname varchar 255
jivedvrevision documentclassid int4 10
jivedocument documentid varchar 255
jivedvrevision documentid int8 19
jiveofficecoauthors documentid int8 19
jivedoctypeelement documenttypeid int8 19
jivelabelelement documenttypeid int8 19
jivesectionelement documenttypeid int8 19
jiveattachmentdl downloadcomplete int2 5
jiveattachmentdl downloaddate int8 19
jivedraft draftid int8 19
jivedraftimage draftid int8 19
jivedraftprop draftid int8 19
jivedraft drafttype int4 10
jiveuserrelgraph drptchoiceallowed int2 5 0
jivepcheckpoint duedate int8 19
jiveproject duedatenull int4 10
jiveptask duedatenull int4 10
jiveidentitytable dummy bpchar 1
jivedocument editpolicy int4 10
jiveofficecoauthors editstartdate int8 19
jivedoctypeelement elementid int8 19
jivelabelelement elementid int8 19
jivesectionelement elementid int8 19
jivedoctypeelement elementindex int4 10
jivesectionelement elementindex int4 10
jivedocelementtype elementtypeid int8 19
jivedoctypeelement elementtypeid int8 19
jivesectionelement elementtypeid int8 19
jiveuser email varchar 100
jivewatchsettings emailfrequency int2 5
jiveuser emailvisible int4 10
jiveattachsettings enabled int2 5
jivecnxtconnection enabled int2 5
jivecnxtendpoint enabled int2 5
jivedocbodyconfig enabled int4 10
jiveprofileseclvl enabled int2 5 1
jivesearchengine enabled int4 10
jivestatlvlscen enabled int2 5
jiveuserrelgraph enabled int2 5 1
jivemetering encrypteddate varchar 64
jivemetering encryptedusageamt varchar 255
jivepoll enddate int8 19
jivecnxtendpoint endpointid int8 19
jiveeptagjoin endpointid int8 19
jivebridge engineid int8 19 (-1)
jivesearchengine engineid int8 19
jiveapientitlement entitlementid int8 19
jiveentitlement entitlementid int8 19
jiveentitlement entitlementmask int4 10
jiveapientitlement entitlementtype varchar 127
jiveinboxentry entryid int8 19
jiveinboxentryprop entryid int8 19
jiveinboxentry entrytype int4 10
jiveerror errorid int8 19
jivedvrevision evifrozen int4 10 0
jivewatch expirable int2 5
jivebintoken expirationdate int8 19
jivedocument expirationdate int8 19
jiveoauthclientaccesstoken expirationdate int8 19
jiveocbtoken expirationdate int8 19
jivepoll expiredate int8 19
jivegateway exportenabled int4 10
jiveobjpermlvlext extender int8 19 0
jiveobjpermlvlmap extender int8 19 0
jiveobjpermlvlmsk extender int8 19 0
jiveobjtypemsk extender int8 19 0
jiveuuidext externalid varchar 255
jiveexternalidentity externalidentityid int8 19
jiveuuidext externalidtype varchar 128
jivesearchengine externalsearchurl varchar 2000
jiveprofilefield extmanaged int2 5
jiveuser federated int4 10 0
jivefield fieldid int8 19
jivefieldoption fieldid int8 19
jivefieldvalue fieldid int8 19
jiveprofilefield fieldid int8 19
jiveprofilefldopt fieldid int8 19
jiveprofilefldsec fieldid int8 19
jiveuserprofile fieldid int8 19
jiveosappdata fieldname varchar 255
jiveprofilefield fieldtype int4 10
jivefield fieldtypeid int8 19
jivefieldfrmtprop fieldtypeid int8 19
jivefieldtype fieldtypeid int8 19
jivefieldvldtrprop fieldtypeid int8 19
jiveprofilefldopt fieldvalue varchar 255
jiveosfileitem fileitemid int8 19
jiveattachment filename varchar 255
jivedvrevision filename varchar 255
jiveimage filename varchar 255
jivestatics filename varchar 127
jiveattachment filesize int4 10
jivedvrevartifact filesize int4 10
jivedvrevision filesize int8 19
jiveimage filesize int4 10
jiveosfileitem filesize int8 19
jivefield filterable int2 5
jivecnxtcredtype format varchar 16
jivewidgetframe frameid int8 19
jivewidgetfrmprop frameid int8 19
jivewidgetframe frameindex int4 10
jiveosappdata gadgetid varchar 255
jivegateway gatewayid int8 19
jivegatewayprop gatewayid int8 19
jivegateway gatewaytype varchar 10
jivestreamchannel generatorid varchar 127
jivegrantedpermlvl grantedid int8 19
jivegrantedpermlvl grantedobjecttype int4 10
jiveuserrel graphid int8 19
jiveuserrelgraph graphid int8 19
jiveusrrelgrapr graphid int8 19
jiveusrrelgrntf graphid int8 19
jiveuserrelgraph graphtypeid int4 10 1
jivegroup groupid int8 19
jivegroupperm groupid int8 19
jivegroupprop groupid int8 19
jivegroupuser groupid int8 19
jivegroupuserhist groupid int8 19
jivesgroup groupid int8 19
jivesgroupmember groupid int8 19
jivesgroupprop groupid int8 19
jivestatuslevel groupid int8 19
jivesgroup grouptype int4 10
jivegroupuserhist groupuserid int8 19
jivecnxtsvcheader headerid int8 19
jivecnxtsvcheader headername varchar 255
jivecnxtsvcheader headervalue varchar 255
jiveanswer helpfulanswer int2 5
jivecnxtcredtype helpkey varchar 64
jiveactivityhistry historyid int8 19
jiveexternalurl host varchar 3500
jiveocservicestats httpmethod varchar 10
jivestatlvlscen i18nkey varchar 100
jivebookmark id int8 19
jivecontentmeta id int8 19
jivecontentmtprop id int8 19
jivedeletedobjects id int8 19
jiveexternalurl id int8 19
jiveid id int8 19
jivemarketoutmsg id int8 19
jivemovedobjects id int8 19
jivesession id varchar 100
jivewfcurrentstep id int8 19
jivewfcurrstepprev id int8 19
jivewfentry id int8 19
jivewfhistorystep id int8 19
jivewfhiststepprev id int8 19
jiveexternalidentity identityvalue varchar 255
jiveid idtype int4 10
jiveprofilefield idx int4 10
jiveprofilefldopt idx int4 10
jivepaletteprop image int2 5
jivedraftimage imageid int8 19
jiveimage imageid int8 19
jiveimageversion imageid int8 19
jivestatuslevel imagepath varchar 255
jiveuserimhandle imhandle varchar 100
jivegateway importenabled int4 10
jiveuserimhandle imtype int4 10
jiveinboxentry inboxtype int2 5
jivewatchsettings includepostcontent int2 5 1
jiveappinstalert instanceappid int8 19
jiveinstanceapp instanceappid int8 19
jiveinstapppref instanceappid int8 19
jiveoauthstore instanceappid int8 19
jivedvrevartifact instanceid varchar 255
jiveformattedtext instanceid int8 19
jiveattachversion internaldocid int8 19
jivedocbodyversion internaldocid int8 19
jivedoccollab internaldocid int8 19
jivedocument internaldocid int8 19
jivedocumentaudit internaldocid int8 19
jivedocumentprop internaldocid int8 19
jivedocversion internaldocid int8 19
jivedocversioncmmt internaldocid int8 19
jivefieldvalue internaldocid int8 19
jiveimageversion internaldocid int8 19
jiveinvite invitationid int8 19
jiveinviteprop invitationid int8 19
jivemetering isadjustment int2 5
jiveprofilefield isdefault int2 5
jiveprofilefield iseditable int2 5
jiveprofilefield isfilterable int2 5
jiveprofilefield islist int2 5 0
jiveprofilefield isrequired int2 5
jiveprofilefield issearchable int2 5
jiveprofilefield isvisibletoguests int2 5
jiveprofilefield isvisibletousers int2 5
jivesystemjob jobid varchar 255
jivesystemjobprop jobid varchar 255
jiveremotestore keyid int8 19
jivestreamaction label varchar 127
jivelabel labelid int8 19
jivelabelmap labelid int8 19
jivelabeltype labelid int8 19
jivecnxtcredtype labelkey varchar 64
jivedocversion language bpchar 2
jivebrowsecnt lastactivitydate int8 19
jivebrowsecntr lastactivitydate int8 19
jiveuser lastloggedin int8 19 0
jiveuser lastprofileupdate int8 19 0
jivepageviewconfig lastupdatets int8 19
jiveuserstatus latitude float8 17,17 (-1)
jivewlayout layoutid int8 19
jivewlayoutframe layoutid int8 19
jivecnxtendpoint lenient int2 5 0
jiveprofilefldsec levelid int8 19
jiveprofileseclvl levelid int8 19
jivecommunity lft int4 10
jivewikilink linkid int8 19 0
jivelinkobject linkkey varchar 255
jiveusrrellist listid int8 19
jiveusrrellistmap listid int8 19
jivermtbridgedcont localcontentid int8 19
jivermtbridgedcont localcontenttype int8 19
jiveappactiontext locale varchar 16
jivei18ntext locale varchar 100
jivelocalizedprop locale varchar 100
jiverenderedcontent locale varchar 100
jivestreamenttext locale varchar 16
jiveinstanceapp locallymanaged int2 5 1
jivebridgeoption localorigin int2 5 0
jiveuuid longid int8 19
jiveuserstatus longitude float8 17,17 (-1)
jivelicensereport manual int4 10
jivethememap maptype varchar 16
jivebookmark markedid int8 19
jivebookmark markedtype int4 10
jiveentitlementmsk mask int4 10
jiveobjpermlvlmsk mask int4 10
jiveobjtypemsk mask int4 10
jivepermlvlmsk mask int4 10
jivepermmask mask int4 10
jiveattachsettings maxnumber int4 10
jivestatuslevel maxpoints int4 10
jivesearchengine maxresultcount int4 10 20
jiveattachsettings maxsize int4 10
jivedocbodyconfig maxsize int4 10
jivefield maxsize int4 10
jivedocument meanrating int4 10
jivesgroupmember membershipid int8 19
jivesgroupmember membertype int4 10
jiveusermesgcount messagecount int4 10
jiveanswer messageid int8 19
jivemessage messageid int8 19
jivemessageprop messageid int8 19
jivestreamaction method varchar 32
jiveuserrelgraph mgrchoiceallowed int2 5 0
jiveosfileitem mimetype varchar 255
jiveannounce minorcreateedit int2 5 0
jiveblogpost minoredit int2 5 0
jivedocversion minorversion int2 5
jivestatuslevel minpoints int4 10
jivefieldtype modifiable int4 10
jiveacclaim modificationdate int8 19
jiveacclaimvote modificationdate int8 19
jiveannounce modificationdate int8 19 0
jiveapientitlement modificationdate int8 19
jiveapp modificationdate int8 19
jiveappaction modificationdate int8 19
jiveappalert modificationdate int8 19
jiveapperror modificationdate int8 19
jiveappinstalert modificationdate int8 19
jiveappview modificationdate int8 19
jiveattachment modificationdate int8 19
jivebinmetadata modificationdate int8 19
jivebintoken modificationdate int8 19
jiveblog modificationdate int8 19
jiveblogpost modificationdate int8 19
jivebookmark modificationdate int8 19
jivebrowsecnt modificationdate int8 19
jivebrowsecntr modificationdate int8 19
jivecnxtauthstyle modificationdate int8 19
jivecnxtconnection modificationdate int8 19
jivecnxtcredtype modificationdate int8 19
jivecnxtendpoint modificationdate int8 19
jivecnxtsvcheader modificationdate int8 19
jivecnxtsvcowner modificationdate int8 19
jivecnxtsvcprop modificationdate int8 19
jivecnxttag modificationdate int8 19
jivecomment modificationdate int8 19
jivecommunity modificationdate int8 19
jivecontentbackup modificationdate int8 19
jivecustompermlvl modificationdate int8 19
jivedashboard modificationdate int8 19
jivedevsettings modificationdate int8 19
jivedocversion modificationdate int8 19
jivedraft modificationdate int8 19
jivedvrevartifact modificationdate int8 19
jivedvrevision modificationdate int8 19
jivedvrevstatus modificationdate int8 19
jiveerror modificationdate int8 19
jiveexternalurl modificationdate int8 19
jivegroup modificationdate int8 19
jivegroupuserhist modificationdate int8 19
jivei18ntext modificationdate int8 19
jiveimage modificationdate int8 19
jiveinstanceapp modificationdate int8 19
jiveinvite modificationdate int8 19
jivemessage modificationdate int8 19
jiveoauthclient modificationdate int8 19
jiveoauthclientaccesstoken modificationdate int8 19
jiveoauthpairing modificationdate int8 19
jiveoauthtoken modificationdate int8 19
jiveocbmetadata modificationdate int8 19
jiveocbtoken modificationdate int8 19
jiveosfileitem modificationdate int8 19
jivepalette modificationdate int8 19
jivepaletteprop modificationdate int8 19
jivepcheckpoint modificationdate int8 19
jiveplugin modificationdate int8 19
jivepoll modificationdate int8 19
jivepresenter modificationdate int8 19
jiveproject modificationdate int8 19
jiveptask modificationdate int8 19
jivesgroup modificationdate int8 19
jivestatics modificationdate int8 19
jivestreamchannel modificationdate int8 19
jivestreamentry modificationdate int8 19
jivetagset modificationdate int8 19
jivethread modificationdate int8 19
jiveuser modificationdate int8 19
jiveusercontainer modificationdate int8 19
jiveuserrel modificationdate int8 19
jiveuserstatus modificationdate int8 19 0
jiveavatar modvalue int4 10
jivemovedobjects moveddate int8 19
jiveacclaimprop name varchar 100
jiveaccvoteprop name varchar 100
jiveannounceprop name varchar 100
jiveattachmentprop name varchar 100
jiveavatarprop name varchar 100
jivebinmetadata name varchar 255
jiveblog name varchar 255
jiveblogpostprop name varchar 100
jiveblogprop name varchar 100
jivebridge name varchar 255
jivebrowsecntr name varchar 255
jivecnxtauthstyle name varchar 255
jivecnxtcredtype name varchar 255
jivecnxtendpoint name varchar 255
jivecnxtsvcprop name varchar 255
jivecnxttag name varchar 255
jivecommentprop name varchar 100
jivecommunity name varchar 255
jivecommunityprop name varchar 100
jivecontentmtprop name varchar 100
jivedocelementtype name varchar 20
jivedoctype name varchar 100
jivedoctypeprop name varchar 100
jivedocumentprop name varchar 100
jivedraftprop name varchar 100
jiveeaeuserprop name varchar 100
jiveentitlementmsk name varchar 25
jiveextcontext name varchar 100
jiveexternallogin name varchar 255
jivefield name varchar 100
jivefieldfrmtprop name varchar 100
jivefieldtype name varchar 20
jivefieldvldtrprop name varchar 100
jivegatewayprop name varchar 100
jivegroup name varchar 100
jivegroupprop name varchar 100
jiveinboxentryprop name varchar 100
jiveinstapppref name varchar 128
jiveinviteprop name varchar 100
jivelabel name varchar 200
jivelocalizedprop name varchar 100
jivemessageprop name varchar 100
jiveoauthclient name varchar 100
jiveobjpermlvl name varchar 25
jiveocbmetadata name varchar 255
jiveosfileitem name varchar 255
jivepalette name varchar 100
jivepcheckpoint name varchar 255
jivepermmask name varchar 255
jiveplugin name varchar 100
jivepoll name varchar 255
jivepresenter name varchar 100
jiveprofilefield name varchar 255
jiveproject name varchar 255
jiveprojectprop name varchar 100
jiveproperty name varchar 255
jiveptaskprop name varchar 100
jivequestionprop name varchar 100
jivesgroup name varchar 255
jivesgroupprop name varchar 100
jivestatuslevel name varchar 255
jivestreamentprop name varchar 100
jivesystemjobprop name varchar 255
jivetagset name varchar 100
jivethreadprop name varchar 100
jivetypevldtrprop name varchar 100
jiveusercontnrprop name varchar 100
jiveuserprop name varchar 100
jiveuserrelgraph name varchar 255
jiveusrrellist name varchar 200
jiveversion name varchar 50
jivewidgetfrmprop name varchar 100
jiveprofileseclvl namekey varchar 128
jivebinstore namespace varchar 255
jiveuser namevisible int4 10
jiveauditlog node varchar 512
jivewatchsettings notifyactionqueue int2 5
jivewatchsettings notifydirectaction int2 5
jivewatchsettings notifyinboxnotific int2 5
jivewatchsettings notifymycomm int2 5
jiveoauthclientaccesstoken oauthclientaccesstokenid int8 19
jiveoauthclient oauthclientid int8 19
jiveoauthclientaccesstoken oauthclientid int8 19
jiveoauthpairing oauthpairingid int8 19
jiveoauthaccesslog oauthtokenid int8 19
jiveoauthpasscode oauthtokenid int8 19
jiveoauthtoken oauthtokenid int8 19
jivei18ntext objectattribute int4 10
jiveabuse objectid int8 19
jiveacclaim objectid int8 19
jiveactivity objectid int8 19
jivearchivepolicy objectid int4 10
jivebrowsecnt objectid int8 19
jivebrowsecntr objectid int8 19
jivecomment objectid int8 19
jivecontentbackup objectid int8 19
jivedeletedobjects objectid int8 19
jivedraft objectid int8 19
jiveentitlement objectid int8 19
jivefeatured objectid int8 19
jivegroupperm objectid int8 19
jivei18ntext objectid int8 19
jiveinvite objectid int8 19
jivelabelmap objectid int8 19
jivelinkobject objectid int8 19
jivemovedobjects objectid int8 19
jiveobjapiaccessor objectid int8 19
jiveobjecttag objectid int8 19
jiveobjecttagset objectid int8 19
jivepoll objectid int8 19
jivepopularity objectid int8 19
jiverating objectid int8 19
jivereadtracker objectid int8 19
jiverenderedcontent objectid int8 19
jivestatuslevelpnt objectid int8 19
jiveuserperm objectid int8 19
jiveviewcount objectid int8 19
jivewatch objectid int8 19
jivewikilink objectid int8 19
jiveabuse objecttype int8 19
jiveacclaim objecttype int4 10
jiveactivity objecttype int4 10
jiveannounce objecttype int4 10
jivearchivepolicy objecttype int8 19
jiveattachment objecttype int4 10
jivebrowsecnt objecttype int4 10
jivebrowsecntr objecttype int4 10
jivecomment objecttype int4 10
jivecontentbackup objecttype int4 10
jivedeletedobjects objecttype int4 10
jiveentitlement objecttype int4 10
jivefeatured objecttype int4 10
jivegroupperm objecttype int4 10
jivei18ntext objecttype int4 10
jiveimage objecttype int4 10
jiveinvite objecttype int4 10
jivelabelmap objecttype int4 10
jivelabeltype objecttype int4 10
jivelinkobject objecttype int4 10
jivemovedobjects objecttype int4 10
jiveobjapiaccessor objecttype int4 10
jiveobjecttag objecttype int4 10
jiveobjecttagset objecttype int4 10
jivepoll objecttype int4 10
jivepopularity objecttype int4 10
jiverating objecttype int4 10
jivereadtracker objecttype int4 10
jiverenderedcontent objecttype int4 10
jivestatuslevelpnt objecttype int4 10
jiveuserperm objecttype int4 10
jiveviewcount objecttype int4 10
jivewatch objecttype int4 10
jivewikilink objecttype int4 10
jiverenderedcontent objectversion int4 10
jiveapprovalwrkflw objid int8 19
jivedefobjpermlvl objpermlevelid int8 19
jiveobjpermlvl objpermlevelid int8 19
jiveobjpermlvlext objpermlevelid int8 19
jiveobjpermlvlmap objpermlevelid int8 19
jiveobjpermlvlmsk objpermlevelid int8 19
jiveobjtypemsk objtype int8 19
jivefieldoption optionid int8 19
jivepolloption optionid int8 19
jivepollvote optionid int8 19
jivefieldoption optionindex int4 10
jivepolloption optionindex int4 10
jivepolloption optiontext varchar 3500
jivefieldoption optionvalue varchar 255
jivebridgedcontmsg orderindex int4 10
jivedashboard orderindex int4 10
jiveexternallogin ordering int4 10
jivearchivepolicy orgcontainerid int4 10
jivearchivepolicy orgcontainertype int8 19
jivebridgedcont origcontentid int8 19
jivebridgedcontmsg origcontentid int8 19
jivebridgedcont origcontenttype int8 19
jivebridgedcontmsg origcontenttype int8 19
jivedvrevision origin int4 10
jivebridgedcont origsubject varchar 1000
jivebridgedcont origtags varchar 3500
jivebookmark ownerid int8 19
jivecnxtsvcowner ownerid int8 19
jivelabel ownerid int8 19
jivebookmark ownertype int4 10
jivedvrevartifact page int4 10
jivedvrevision pagecount int4 10 0
jiveoauthpairing pairingsubtypeid varchar 48
jivepalette paletteid int8 19
jivepaletteprop paletteid int8 19
jivecontentmeta parentid int8 19
jivesectionelement parentid int8 19
jiveproject parentobjectid int8 19
jiveptask parentobjectid int8 19
jivewidgetframe parentobjectid int8 19
jivewlayoutframe parentobjectid int8 19
jiveproject parentobjecttype int4 10
jiveptask parentobjecttype int4 10
jivewidgetframe parentobjecttype int4 10
jivewlayoutframe parentobjecttype int4 10
jiveptask parenttaskid int8 19 0
jivecontentmeta parenttype int4 10
jiveoauthpasscode passcodeencoded varchar 128
jiveoauthpasscode passcodefailedattempts int4 10 0
jiveuser passwordhash varchar 64
jiveuserrelgraph peerchoiceallowed int2 5 0
jivegroupperm permission int4 10
jiveuserperm permission int4 10
jivegroupperm permissiontype int4 10
jiveuserperm permissiontype int4 10
jivecustompermlvl permlevelid int8 19
jivegrantedpermlvl permlevelid int8 19
jiveobjpermlvlmap permlevelid int8 19
jivepermlevel permlevelid int8 19
jivepermlvlmsk permlevelid int8 19
jivestatics placeobjectid int8 19
jivestatics placeobjecttype int4 10
jivemetering plaindate int8 19
jiveplugin pluginid int8 19
jivepluginprop pluginname varchar 100
jivestatuslevelpnt pointid int8 19
jivestatlvlscen points int8 19
jivestatuslevelpnt points int8 19
jivepoll pollid int8 19
jivepolloption pollid int8 19
jivepoll pollmode int8 19
jivepopularity popularityid int8 19
jivepresenter presenterid int8 19
jivewfcurrstepprev previousid int8 19
jivewfhiststepprev previousid int8 19
jiveuserprofile primaryval int2 5
jivearchivepolicy processingdate int8 19
jivepcheckpoint projectid int8 19
jiveproject projectid int8 19
jiveprojectprop projectid int8 19
jiveprojectstatus projectid int8 19
jivecnxtsvcprop propertyid int8 19
jivepaletteprop propkey varchar 100
jivecontentprop propname varchar 255
jivepluginprop propname varchar 100
jiveacclaimprop propvalue varchar 3500
jiveaccvoteprop propvalue varchar 3500
jiveannounceprop propvalue varchar 3500
jiveattachmentprop propvalue varchar 3500
jiveavatarprop propvalue varchar 3500
jiveblogpostprop propvalue varchar 3500
jiveblogprop propvalue varchar 3500
jivecommentprop propvalue varchar 3500
jivecommunityprop propvalue varchar 3500
jivecontentmtprop propvalue varchar 3500
jivecontentprop propvalue text 2147483647
jivedoctypeprop propvalue varchar 3500
jivedocumentprop propvalue varchar 3500
jivedraftprop propvalue varchar 3500
jiveeaeuserprop propvalue varchar 3500
jivefieldfrmtprop propvalue varchar 3500
jivefieldvldtrprop propvalue varchar 3500
jivegatewayprop propvalue varchar 3500
jivegroupprop propvalue varchar 3500
jiveinboxentryprop propvalue varchar 3500
jiveinstapppref propvalue text 2147483647
jiveinviteprop propvalue varchar 3500
jivelocalizedprop propvalue text 2147483647
jivemessageprop propvalue varchar 3500
jivepaletteprop propvalue varchar 3500
jivepluginprop propvalue varchar 3500
jiveprojectprop propvalue varchar 3500
jiveproperty propvalue varchar 3500
jiveptaskprop propvalue varchar 3500
jivequestionprop propvalue varchar 3500
jivesgroupprop propvalue varchar 3500
jivestreamentprop propvalue varchar 3500
jivesystemjobprop propvalue varchar 3500
jivethreadprop propvalue varchar 3500
jivetypevldtrprop propvalue varchar 3500
jiveusercontnrprop propvalue varchar 3500
jiveuserprop propvalue varchar 3500
jivewidgetfrmprop propvalue text 2147483647
jiveexternalurl protocol varchar 10
jiveoauthpairing providernamehash int4 10
jiveblogpost publishdate int8 19
jivewidgetframe published int4 10
jivewlayoutframe published int4 10 0
jivequestprogress questid int8 19
jivequestprogress questprogressid int8 19
jiveapprovalwrkflw queuedtype int2 5
jivedocument readcount int4 10
jivereadtracker readdate int8 19
jivewatchsettings receiveemails int2 5
jivewatchsettings receivehtmlemails int2 5 1
jivedocument recommended int2 5
jivedvrevision reconciled int4 10 1
jivedocversion recordid int8 19
jivebinstore recordtype int4 10
jiveacccontainer recursive int4 10
jivereference referenceid int8 19
jivereference refererobjectid int8 19
jivereference refererobjecttype int2 5
jiveuserrelgraph reflexive int2 5 1
jivereference refobjectid int8 19
jivereference refobjecttype int2 5
jiveapp refreshcompleted int8 19 (-1)
jiveapp refreshrequested int8 19 (-1)
jiveapp refreshstarted int8 19 (-1)
jiveapp refreshstate varchar 5 'never'::character varying
jiveprofilefield regidx int4 10 (-1)
jiveapprovalwrkflw rejected int2 5
jiveuserrel relateduserid int8 19
jiveuserrel relationshipid int8 19
jiveusrrellistmap relationshipid int8 19
jiveuserrel relnshiptypeid int4 10 2
jivebridgeuser remoteuserid int8 19
jivebridgeuser remoteusername varchar 100
jivelicensereport reportbody text 2147483647
jiveabuse reportdate int8 19
jivelicensereport reportid int8 19
jivefield required int2 5
jivequestion resolutionstate int4 10
jivemetering resourcetype varchar 255
jivedvrevartifact revisionid int8 19
jivedvrevision revisionid int8 19
jivedvrevstatus revisionid int8 19
jivedvrevision revisionnumber int4 10
jivemessage rewardpoints int4 10
jivethread rewardpoints int4 10
jivecommunity rgt int4 10
jivermtbridgedcont rmtbridgedcontid int8 19
jivermtbridgedcont rmtcontentid int8 19
jivermtbridgedcont rmtcontenttype int8 19
jivebridgedcont rootmessageid int8 19
jivethread rootmessageid int8 19
jivethreadlatest rootmessageuserid int8 19
jiveappview rownumber int4 10 0
jivesystemjob rundate int8 19
jivestatlvlscen scenarioid int8 19
jiveacclaim score numeric 131089 0
jivepopularity score int4 10
jiverating score int4 10
jiveratingtype score int4 10
jiveacclaim scoredisplay numeric 131089 0
jivefield searchable int2 5
jivesearchengine searchurl varchar 2000
jivestreamaction seq int2 5
jivecnxtconnection serviceid int8 19
jivecnxtsvcheader serviceid int8 19
jivecnxtsvcowner serviceid int8 19
jivecnxtsvcprop serviceid int8 19
jiveoauthstore servicename varchar 64
jiveocservicestats servicename varchar 255
jivesearchengine shortname varchar 255
jiveannounce sortkey int4 10 0
jivemovedobjects sourcecontainerid int8 19
jivemovedobjects sourcecontainertype int4 10
jiveapperror sourcetype int8 19
jiveerror sourcetype int8 19
jiveannounce startdate int8 19
jivepoll startdate int8 19
jiveproject startdate int8 19
jivesystemjob startedon int8 19 0
jivebridgeoption state int4 10 0
jivedocversion state varchar 20
jiveinboxentry state int2 5
jiveinvite state int4 10
jiveuserrel state varchar 20 'pending_approval'::character varying
jivestatics staticid int8 19
jiveannounce status int4 10
jivearchivepolicy status int4 10
jiveblog status int4 10
jiveblogpost status int4 10
jivebookmark status int4 10
jivebrowsecnt status int4 10
jivebrowsecntr status int4 10
jivecomment status int4 10
jivecommunity status int4 10
jivedocversion status int4 10
jiveexternalurl status int4 10
jivemessage status int4 10
jivepoll status int4 10
jiveproject status int4 10
jivesgroup status int4 10
jivesystemjob status int4 10
jivethread status int4 10
jiveuser status int4 10 6
jiveusercontainer status int4 10
jiveuserstatus status int4 10 2
jiveprojectstatus statusid int8 19
jivestatuslevel statuslevelid int8 19
jiveprojectstatus statustype int4 10
jiveuserstatus statustype int4 10 0
jivedvrevstatus step int4 10 0
jiveremotestore storeid int8 19
jiveremotestore storekey varchar 64
jiveprofileseclvl strategyname varchar 128
jivestreamchannel streamchannelid int8 19
jivestreamentry streamchannelid int8 19
jivestreamaction streamentryid int8 19
jivestreamapprover streamentryid int8 19
jivestreamentprop streamentryid int8 19
jivestreamentry streamentryid int8 19
jivestreamenttext streamentryid int8 19
jiveannounce subject varchar 255
jiveptask subject varchar 3500
jiveuserroster subuserid int8 19
jivepermlevel system int2 5 0
jivetagcloud tagcount int4 10
jivetagcloud taggabletype int8 19
jivecnxttag tagid int8 19
jiveeptagjoin tagid int8 19
jiveobjecttag tagid int8 19
jivetag tagid int8 19
jivetagcloud tagid int8 19
jivetagsetmap tagid int8 19
jivetag tagname varchar 100
jiveobjecttagset tagsetid int8 19
jivetagset tagsetid int8 19
jivetagsetmap tagsetid int8 19
jivewikilink targetlinktype int4 10
jivegrantedpermlvl targetobjectid int8 19
jiveinboxentry targetobjectid int8 19
jivegrantedpermlvl targetobjecttype int4 10
jiveinboxentry targetobjecttype int4 10
jiveptask taskid int8 19
jiveptaskprop taskid int8 19
jivei18ntext text varchar 2000
jivei18ntext textid int8 19
jivethememap theme varchar 32
jiveanswer threadid int8 19
jivemessage threadid int8 19
jivequestion threadid int8 19
jivequestionprop threadid int8 19
jivethread threadid int8 19
jivethreadlatest threadid int8 19
jivethreadprop threadid int8 19
jiveauditlog timestamp int8 19
jiveremotestore timestamp int8 19
jivedocversion title varchar 255
jivebintoken token varchar 255
jivecredential token bytea 2147483647
jiveocbtoken token varchar 255
jiveemailtoken tokendate int8 19
jiveformtoken tokenkey varchar 255
jiveoauthstore tokenname varchar 64
jiveoauthstore tokensecret varchar 1024
jiveemailtoken tokenvalue int4 10
jiveformtoken tokenvalue varchar 255
jiveoauthstore tokenvalue varchar 1024
jiveocservicestats trackeddate int8 19
jivebridgeoption type int4 10
jivecredential type int4 10
jiveextcontext type int2 5
jiveexternalidentity type int4 10
jiveexternallogin type int4 10
jivestreamaction type varchar 32
jiveapprovalwrkflw typeid int8 19
jiveattachsettings typeid int8 19
jiveattachtypes typeid int8 19
jivedocbodyconfig typeid int8 19
jivedocbodytypes typeid int8 19
jivedoctype typeid int8 19
jivedoctypeprop typeid int8 19
jivedocument typeid int8 19
jiveobjecttype typeid int4 10
jivetypevldtrprop typeid int8 19
jivedoctype typeindex int4 10
jivewatchsettings upgraded int2 5 1
jivebintoken url varchar 2000
jivebridge url varchar 255
jivebridgedcont url varchar 255
jivecnxtendpoint url varchar 2048
jiveocbtoken url varchar 255
jivermtbridgedcont url varchar 255
jiveusercontainer usercontainerid int8 19
jiveusercontnrprop usercontainerid int8 19
jiveuser userenabled int4 10
jiveabuse userid int8 19
jiveactivityhistry userid int8 19
jiveannounce userid int8 19
jiveapientitlement userid int8 19
jiveappalertack userid int8 19
jiveapprovalwrkflw userid int8 19
jivearchivepolicy userid int8 19
jiveauditlog userid int8 19
jiveavataruser userid int8 19
jivebinmetadata userid int8 19
jiveblogpost userid int8 19
jivebridge userid int8 19
jivebridgedcontmsg userid int8 19
jivebridgeuser userid int8 19
jivebrowsefol userid int8 19
jivebrowseprtd userid int8 19
jivecnxtconnection userid int8 19
jivecnxtsvcowner userid int8 19
jivecontaineraprvr userid int8 19
jivecredential userid int8 19
jivedashboard userid int8 19
jivedevsettings userid int8 19
jivedoccollab userid int8 19
jivedocument userid int8 19
jivedocversion userid int8 19
jivedocversioncmmt userid int8 19
jivedvrevision userid int8 19
jiveeaeuserprop userid int8 19
jiveemailtoken userid int8 19
jiveexternalidentity userid int8 19
jivefollow userid int8 19
jivegroupuser userid int8 19
jivegroupuserhist userid int8 19
jiveinboxentry userid int8 19
jiveinstanceapp userid int8 19
jiveoauthpairing userid int8 19
jiveoauthstore userid int8 19
jiveoauthtoken userid int8 19
jiveocbmetadata userid int8 19
jiveofficecoauthors userid int8 19
jiveosappdata userid int8 19
jiveosfileitem userid int8 19
jiveproject userid int8 19
jiveprojectstatus userid int8 19
jivequestion userid int8 19
jivequestprogress userid int8 19
jivereadtracker userid int8 19
jivesgroup userid int8 19
jivesgroupmember userid int8 19
jivestatics userid int8 19
jivestatuslevelpnt userid int8 19
jivestatuslevelpntsum userid int8 19
jivestreamapprover userid int8 19
jivestreamentry userid int8 19
jivesystemjob userid int8 19
jiveuser userid int8 19
jiveuserannprop userid int8 19
jiveusercontainer userid int8 19
jiveuserimhandle userid int8 19
jiveusermesgcount userid int8 19
jiveuserperm userid int8 19
jiveuserprofile userid int8 19
jiveuserprop userid int8 19
jiveuserrel userid int8 19
jiveuserroster userid int8 19
jiveuserstatus userid int8 19
jiveusrrelgrapr userid int8 19
jiveusrrelgrntf userid int8 19
jiveusrrellist userid int8 19
jivewatch userid int8 19
jivewatchsettings userid int8 19
jiveuser username varchar 100
jiveuserprofile userprofileid int8 19
jiveuserstatus userstatusid int8 19
jiveuser usertype int4 10 0
jivebridgedcont uuid varchar 128
jivebridgeuser uuid varchar 128
jivelicenseconfirm uuid varchar 100
jivelicensereport uuid varchar 100
jivermtbridgedcont uuid varchar 128
jiveuuid uuid varchar 128
jiveuuidext uuid varchar 128
jivesession valid bpchar 1
jivecnxtsvcprop value varchar 255
jiveremotestore value bytea 2147483647
jiverenderedcontent value text 2147483647
jivedocversioncmmt vcommentid int8 19
jivebintoken verb varchar 255
jiveocbtoken verb varchar 4
jivestreamentry verb varchar 128
jiveoauthstore version int2 5
jiverenderedcontentversion version int8 19
jivetermsandcond version int4 10
jiveversion version int4 10
jiveattachversion versionid int4 10
jivecontentbackup versionid int4 10
jivedocbodyversion versionid int4 10
jivedocument versionid int4 10
jivedocumentaudit versionid int4 10
jivedocumentprop versionid int2 5
jivedocversion versionid int4 10
jivedocversioncmmt versionid int4 10
jivefieldvalue versionid int4 10
jiveimageversion versionid int4 10
jiveacclaim visibility int4 10 1
jivearchivepolicy visibility int4 10
jivefield visible int2 5
jiveuser visible int4 10 1
jivepollvote votedate int8 19
jiveacclaimvote voteid int8 19
jiveaccvoteprop voteid int8 19
jiveacclaimvote voterid int8 19
jiveacclaimvote votevalue int4 10 0
jivewatch watchtype int4 10
jivewidget widgetid int8 19
jivewidgetframe widgetid int8 19
jiveapprovalwrkflw workflowid int8 19