Jive v6 Core | Generated by SchemaSpy |
| |||||||
|
sbs6a.public contains 1585 columns - click on heading to sort:
Table | Column | Type | Size | Nulls | Auto | Default | Comments |
---|---|---|---|---|---|---|---|
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 | ||||
jiveoauthclientaccesstoken | accesstoken | varchar | 127 | √ | null | ||
jiveoauthtoken | accesstoken | varchar | 127 | √ | null | ||
jiveoauthtoken | accesstokenexp | int8 | 19 | √ | null | ||
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 | ||||
jivewfcurrentstep | actionid | int2 | 5 | √ | null | ||
jivewfhistorystep | actionid | int4 | 10 | √ | null | ||
jiveoauthpairing | activationdate | int8 | 19 | √ | null | ||
jivebridgedcont | active | int4 | 10 | ||||
jivestreamentry | activityfaviconurl | varchar | 1024 | √ | null | ||
jiveactivity | activityid | int8 | 19 | ||||
jivestreamentry | activityid | varchar | 3500 | √ | null | ||
jivestreamentry | activityidmd5 | varchar | 127 | √ | null | ||
jivestreamentry | activityspec | varchar | 32 | √ | null | ||
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 | ||||
jiveattachtypes | allowedtype | varchar | 50 | √ | null | ||
jivedocbodytypes | allowedtype | varchar | 50 | √ | null | ||
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 | ||||
jiveapperror | appid | int8 | 19 | √ | null | ||
jiveinstanceapp | appid | int8 | 19 | ||||
jiveosfileitem | appid | varchar | 255 | ||||
jiveappinstalert | appinstalertid | int8 | 19 | ||||
jivebinmetadata | appinstanceid | int8 | 19 | √ | null | ||
jivecnxtconnection | appinstanceid | int8 | 19 | ||||
jiveinstanceapp | appinstanceuuid | varchar | 128 | ||||
jiveapp | apppath | varchar | 127 | √ | null | ||
jiveuserrelgraph | approvalsenabled | int2 | 5 | 0 | |||
jiveapprovalwrkflw | approvaltime | int8 | 19 | √ | null | ||
jiveapprovalwrkflw | approved | int2 | 5 | ||||
jiveinstanceapp | appurl | varchar | 1024 | ||||
jiveinstanceapp | appurlmd5 | varchar | 127 | ||||
jiveapp | appuuid | varchar | 127 | ||||
jiveocservicestats | appuuid | varchar | 127 | ||||
jiveappaction | appview | varchar | 255 | √ | null | ||
jiveappview | appviewid | int8 | 19 | ||||
jivecredential | artifactid | int8 | 19 | ||||
jivedvrevartifact | artifacttype | varchar | 20 | ||||
jiveptask | assignorid | int8 | 19 | √ | null | ||
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 | banneduserid | int8 | 19 | √ | null | ||
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 | ||||
jiveblogpost | body | text | 2147483647 | √ | null | ||
jivebridgedcontmsg | body | text | 2147483647 | ||||
jivecomment | body | text | 2147483647 | ||||
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 | ||
jivedocbodyversion | bodyid | int8 | 19 | ||||
jivedocumentbody | bodyid | int8 | 19 | ||||
jivedocumentbody | bodytext | text | 2147483647 | √ | null | ||
jivebridgedcont | bridgedcontid | int8 | 19 | ||||
jivebridgedcontmsg | bridgedcontid | int8 | 19 | ||||
jivermtbridgedcont | bridgedcontid | int8 | 19 | ||||
jivebridgedcontmsg | bridgedcontmsgid | int8 | 19 | ||||
jivebridge | bridgeid | int8 | 19 | ||||
jivebridgeoption | bridgeid | int8 | 19 | ||||
jivewidget | bridgeid | int8 | 19 | √ | null | ||
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 | ||||
jivewfcurrentstep | caller | varchar | 100 | √ | null | ||
jivewfhistorystep | caller | varchar | 100 | √ | null | ||
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 | ||||
jiveoauthtoken | clientsecret | varchar | 127 | √ | null | ||
jiveblog | cmauthentication | int2 | 5 | √ | null | ||
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 | ||||
jiveabuse | comments | varchar | 255 | √ | null | ||
jiveban | comments | varchar | 50 | √ | null | ||
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 | |||
jivequestprogress | completiondate | int8 | 19 | √ | null | ||
jivemetering | component | varchar | 255 | ||||
jivepageviewconfig | component | varchar | 255 | ||||
jivepageviewconfig | configxml | text | 2147483647 | √ | null | ||
jivelicenseconfirm | confirmationbody | text | 2147483647 | √ | null | ||
jivelicenseconfirm | confirmationbodye | text | 2147483647 | √ | null | ||
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 | ||||
jivecontent | containerid | int8 | 19 | √ | null | ||
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 | ||||
jivecontent | containertype | int8 | 19 | √ | null | ||
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) | |||
jivebinmetadata | contentencoding | varchar | 255 | √ | null | ||
jivebridgedcont | contentid | int8 | 19 | ||||
jivecontent | contentid | int8 | 19 | ||||
jivecontentmeta | contentid | int8 | 19 | ||||
jivecontentprop | contentid | int8 | 19 | ||||
jivebinmetadata | contentlanguage | varchar | 255 | √ | null | ||
jivebinmetadata | contentlength | int8 | 19 | √ | null | ||
jivebinmetadata | contentlocation | varchar | 2000 | √ | null | ||
jivebinmetadata | contentmd5 | varchar | 255 | √ | null | ||
jiveattachment | contenttype | varchar | 100 | ||||
jivebinmetadata | contenttype | varchar | 255 | √ | null | ||
jivebridgedcont | contenttype | int8 | 19 | ||||
jivecontent | contenttype | int8 | 19 | ||||
jivecontentmeta | contenttype | int4 | 10 | ||||
jivecontentprop | contenttype | int8 | 19 | ||||
jivedocumentbody | contenttype | varchar | 100 | √ | null | ||
jivedvrevartifact | contenttype | varchar | 100 | √ | null | ||
jiveentitlement | contenttype | int4 | 10 | ||||
jiveimage | contenttype | varchar | 50 | ||||
jiveextcontext | contextid | int8 | 19 | ||||
jiveoauthstore | contextid | int8 | 19 | √ | null | ||
jiveappaction | contributionid | varchar | 1024 | ||||
jiveanswer | correctanswer | int2 | 5 | ||||
jiveactivityhistry | createcount | int4 | 10 | √ | null | ||
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 | ||||
jivecontent | creationdate | int8 | 19 | √ | null | ||
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 | ||||
jiveentitlement | creationdate | int8 | 19 | √ | null | ||
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 | ||||
jiverating | creationdate | int8 | 19 | √ | null | ||
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 | ||||
jivecustompermlvl | creatorid | int8 | 19 | √ | null | ||
jiveappalert | creatorname | varchar | 1024 | √ | null | ||
jiveappinstalert | creatorname | varchar | 1024 | √ | null | ||
jivebookmark | creatortype | int4 | 10 | ||||
jiveappalert | creatoruserid | int8 | 19 | √ | null | ||
jiveappinstalert | creatoruserid | int8 | 19 | √ | null | ||
jivecnxtcredtype | credentialstypeid | int8 | 19 | ||||
jivecnxtauthstyle | credentialstypes | varchar | 255 | √ | null | ||
jivei18ntext | custom | int2 | 5 | ||||
jiveappview | dashboardid | int8 | 19 | ||||
jivedashboard | dashboardid | int8 | 19 | ||||
jiveplugin | data | bytea | 2147483647 | √ | null | ||
jivequestprogress | data | text | 2147483647 | ||||
jivesession | data | bytea | 2147483647 | √ | null | ||
jivebinstore | datasize | int8 | 19 | ||||
jivedatatype | datatype | varchar | 20 | ||||
jivedatatype | datatypeid | int8 | 19 | ||||
jivefieldtype | datatypeid | int8 | 19 | ||||
jiveospropentry | datavalue | bytea | 2147483647 | √ | null | ||
jiveospropentry | datevalue | int8 | 19 | √ | null | ||
jivefieldoption | defaultoption | int4 | 10 | ||||
jiveprofilefldopt | defaultoption | int2 | 5 | ||||
jiveprofilefield | defaultseclvlid | int8 | 19 | 1001 | |||
jivefield | defvalue | varchar | 255 | √ | null | ||
jivedeletedobjects | deleteddate | int8 | 19 | ||||
jiveocservicestats | delta | int8 | 19 | ||||
jiveauditlog | description | varchar | 1024 | ||||
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 | ||
jivecustompermlvl | description | varchar | 255 | ||||
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 | ||
jiveratingtype | description | varchar | 1000 | ||||
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 | ||
jivearchivepolicy | destcontainerid | int4 | 10 | ||||
jivearchivepolicy | destcontainertype | int8 | 19 | ||||
jivemovedobjects | destinationcontainerid | int8 | 19 | ||||
jivemovedobjects | destinationcontainertype | int4 | 10 | ||||
jiveauditlog | details | varchar | 2048 | √ | null | ||
jiveapp | developmentapp | int2 | 5 | 0 | |||
jivedevsettings | devsettingsid | int8 | 19 | ||||
jivestatuslevelpntsum | dirty | int2 | 5 | ||||
jivegateway | disablecutoffdate | int4 | 10 | √ | null | ||
jivebridge | disabled | int2 | 5 | ||||
jivewlayout | disabled | int4 | 10 | 0 | |||
jiveattachtypes | disallowedtype | varchar | 50 | √ | null | ||
jivedocbodytypes | disallowedtype | varchar | 50 | √ | null | ||
jivestreamchannel | displayid | int4 | 10 | 1000 | |||
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 | ||
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 | ||||
jivecnxtendpoint | documentationurl | varchar | 2048 | √ | null | ||
jivedvrevision | documentclassid | int4 | 10 | ||||
jiveattachment | documentid | varchar | 255 | √ | null | ||
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 | duedate | int8 | 19 | √ | null | ||
jiveptask | duedate | int8 | 19 | √ | null | ||
jivewfcurrentstep | duedate | timestamp | 29,6 | √ | null | ||
jivewfhistorystep | duedate | timestamp | 29,6 | √ | null | ||
jiveproject | duedatenull | int4 | 10 | ||||
jiveptask | duedatenull | int4 | 10 | ||||
jiveidentitytable | dummy | bpchar | 1 | ||||
jivedocument | editpolicy | int4 | 10 | ||||
jiveofficecoauthors | editstartdate | int8 | 19 | ||||
jiveappalert | effectivedate | int8 | 19 | √ | null | ||
jiveappinstalert | effectivedate | int8 | 19 | √ | null | ||
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 | ||||
jivecomment | varchar | 100 | √ | null | |||
jiveinvite | varchar | 100 | √ | null | |||
jiveuser | 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 | ||||
jiveannounce | enddate | int8 | 19 | √ | null | ||
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 | ||||
jivewfcurrentstep | entryid | int8 | 19 | √ | null | ||
jivewfhistorystep | entryid | int8 | 19 | √ | null | ||
jiveinboxentry | entrytype | int4 | 10 | ||||
jiveerror | errorid | int8 | 19 | ||||
jivedvrevision | evidocid | varchar | 50 | √ | null | ||
jivedvrevision | evifrozen | int4 | 10 | 0 | |||
jivedvrevision | eviprevversionid | varchar | 50 | √ | null | ||
jivedvrevision | eviversionid | varchar | 50 | √ | null | ||
jivewatch | expirable | int2 | 5 | ||||
jiveoauthstore | expiration | int8 | 19 | √ | null | ||
jiveban | expirationdate | int8 | 19 | √ | null | ||
jivebintoken | expirationdate | int8 | 19 | ||||
jivedocument | expirationdate | int8 | 19 | ||||
jiveoauthclientaccesstoken | expirationdate | int8 | 19 | ||||
jiveoauthpairing | expirationdate | int8 | 19 | √ | null | ||
jiveoauthtoken | expirationdate | int8 | 19 | √ | null | ||
jiveocbtoken | expirationdate | int8 | 19 | ||||
jivepoll | expiredate | int8 | 19 | ||||
jivesession | expires | int8 | 19 | √ | null | ||
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 | ||||
jiveprofilefield | extmapping | varchar | 2048 | √ | null | ||
jivegroup | federated | int2 | 5 | √ | null | ||
jiveuser | federated | int4 | 10 | 0 | |||
jiveblog | feedenabled | int2 | 5 | √ | null | ||
jiveblog | feedfullcontent | int2 | 5 | √ | null | ||
jivedocumentaudit | fieldid | int8 | 19 | √ | null | ||
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 | ||||
jiveosappdata | fieldsize | int4 | 10 | √ | null | ||
jiveosappdata | fieldtype | varchar | 255 | √ | null | ||
jiveprofilefield | fieldtype | int4 | 10 | ||||
jivefield | fieldtypeid | int8 | 19 | ||||
jivefieldfrmtprop | fieldtypeid | int8 | 19 | ||||
jivefieldtype | fieldtypeid | int8 | 19 | ||||
jivefieldvldtrprop | fieldtypeid | int8 | 19 | ||||
jiveosappdata | fieldvalue | text | 2147483647 | √ | null | ||
jiveprofilefldopt | fieldvalue | varchar | 255 | ||||
jiveosfileitem | fileitemid | int8 | 19 | ||||
jiveattachment | filename | varchar | 255 | ||||
jivedocumentbody | filename | varchar | 255 | √ | null | ||
jivedvrevartifact | filename | varchar | 255 | √ | null | ||
jivedvrevision | filename | varchar | 255 | ||||
jiveimage | filename | varchar | 255 | ||||
jivestatics | filename | varchar | 127 | ||||
jiveattachment | filesize | int4 | 10 | ||||
jivedocumentbody | filesize | int4 | 10 | √ | null | ||
jivedvrevartifact | filesize | int4 | 10 | ||||
jivedvrevision | filesize | int8 | 19 | ||||
jiveimage | filesize | int4 | 10 | ||||
jiveocbmetadata | filesize | int8 | 19 | √ | null | ||
jiveosfileitem | filesize | int8 | 19 | ||||
jivefield | filterable | int2 | 5 | ||||
jivewfcurrentstep | finishdate | timestamp | 29,6 | √ | null | ||
jivewfhistorystep | finishdate | timestamp | 29,6 | √ | null | ||
jiveuser | firstname | varchar | 100 | √ | null | ||
jiveospropentry | floatvalue | float8 | 17,17 | √ | null | ||
jivecnxtcredtype | format | varchar | 16 | ||||
jivefieldtype | formatter | varchar | 255 | √ | null | ||
jivewidgetframe | frameid | int8 | 19 | ||||
jivewidgetfrmprop | frameid | int8 | 19 | ||||
jivewidgetframe | frameindex | int4 | 10 | ||||
jivedoctypeelement | frowversion | int8 | 19 | √ | null | ||
jivefield | frowversion | int8 | 19 | √ | null | ||
jiveapp | gadgethash | varchar | 127 | √ | null | ||
jiveosappdata | gadgetid | varchar | 255 | ||||
jivegateway | gatewayid | int8 | 19 | ||||
jivegatewayprop | gatewayid | int8 | 19 | ||||
jivegateway | gatewaytype | varchar | 10 | ||||
jivestreamchannel | generatorid | varchar | 127 | ||||
jiveospropentry | globalkey | varchar | 150 | √ | null | ||
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 | |||
jiveentitlement | groupid | int8 | 19 | √ | null | ||
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 | ||||
jivepollvote | guestid | varchar | 255 | √ | null | ||
jivedvrevision | hashbytes | varchar | 255 | √ | null | ||
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 | ||||
jiveappaction | iconurl | varchar | 2048 | √ | null | ||
jivecnxtendpoint | iconurl | varchar | 2048 | √ | null | ||
jivesearchengine | iconurl | varchar | 2000 | √ | null | ||
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 | |||
jiveappview | initialheights | varchar | 127 | √ | null | ||
jiveappinstalert | instanceappid | int8 | 19 | ||||
jiveappview | instanceappid | int8 | 19 | √ | null | ||
jiveinstanceapp | instanceappid | int8 | 19 | ||||
jiveinstapppref | instanceappid | int8 | 19 | ||||
jiveoauthstore | instanceappid | int8 | 19 | ||||
jiveocbmetadata | instanceappid | int8 | 19 | √ | null | ||
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 | ||||
jiveapp | internalname | varchar | 255 | √ | null | ||
jiveinvite | invitationid | int8 | 19 | ||||
jiveinviteprop | invitationid | int8 | 19 | ||||
jiveinvite | inviterid | int8 | 19 | √ | null | ||
jivecomment | ip | varchar | 15 | √ | null | ||
jiveban | ipaddress | varchar | 15 | √ | null | ||
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 | ||||
jiveospropentry | itemkey | varchar | 150 | √ | null | ||
jiveospropentry | itemtype | int4 | 10 | √ | null | ||
jivesystemjob | jobid | varchar | 255 | ||||
jivesystemjobprop | jobid | varchar | 255 | ||||
jiveremotestore | keyid | int8 | 19 | ||||
jivestreamaction | label | varchar | 127 | ||||
jiveuserrelgraph | labeldirrpt | varchar | 40 | √ | null | ||
jivelabel | labelid | int8 | 19 | ||||
jivelabelmap | labelid | int8 | 19 | ||||
jivelabeltype | labelid | int8 | 19 | ||||
jivecnxtcredtype | labelkey | varchar | 64 | ||||
jiveuserrelgraph | labelmanager | varchar | 40 | √ | null | ||
jiveuserrelgraph | labelpeer | varchar | 40 | √ | null | ||
jiveusrrellist | labelstyle | varchar | 200 | √ | null | ||
jivedocversion | language | bpchar | 2 | ||||
jivestatuslevel | largeimagepath | varchar | 255 | √ | null | ||
jiveoauthaccesslog | lastaccess | int8 | 19 | √ | null | ||
jivesession | lastaccess | int8 | 19 | √ | null | ||
jivebrowsecnt | lastactivitydate | int8 | 19 | ||||
jivebrowsecntr | lastactivitydate | int8 | 19 | ||||
jiveuser | lastloggedin | int8 | 19 | 0 | |||
jiveuser | lastname | varchar | 100 | √ | null | ||
jiveuser | lastprofileupdate | int8 | 19 | 0 | |||
jiveofficecoauthors | lastupdatedate | int8 | 19 | √ | null | ||
jivemetering | lastupdatets | int8 | 19 | √ | null | ||
jivepageviewconfig | lastupdatets | int8 | 19 | ||||
jiveproject | lateststatusid | int8 | 19 | √ | null | ||
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 | ||||
jiveuserprofile | levelid | int8 | 19 | √ | null | ||
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 | ||||
jivecommunity | localecode | varchar | 32 | √ | null | ||
jiveinstanceapp | locallymanaged | int2 | 5 | 1 | |||
jivebridgeoption | localorigin | int2 | 5 | 0 | |||
jiveuuid | longid | int8 | 19 | ||||
jiveuserstatus | longitude | float8 | 17,17 | (-1) | |||
jiveobjpermlvl | lvltype | varchar | 25 | √ | null | ||
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 | ||||
jivesession | maxinactive | int4 | 10 | √ | null | ||
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 | ||||
jivedvrevstatus | message | varchar | 3500 | √ | null | ||
jiveerror | message | varchar | 1024 | √ | null | ||
jivemarketoutmsg | message | varchar | 3500 | √ | null | ||
jivethreadlatest | messagecount | int4 | 10 | √ | null | ||
jiveusermesgcount | messagecount | int4 | 10 | ||||
jiveanswer | messageid | int8 | 19 | ||||
jivemessage | messageid | int8 | 19 | ||||
jivemessageprop | messageid | int8 | 19 | ||||
jivethreadlatest | messageid | int8 | 19 | √ | null | ||
jivedvrevision | metadata | varchar | 3500 | √ | null | ||
jivestreamaction | method | varchar | 32 | ||||
jiveuserrelgraph | mgrchoiceallowed | int2 | 5 | 0 | |||
jiveexternalurl | mimetype | varchar | 100 | √ | null | ||
jiveocbmetadata | mimetype | varchar | 255 | √ | null | ||
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 | ||||
jivecontent | modificationdate | int8 | 19 | √ | null | ||
jivecontentbackup | modificationdate | int8 | 19 | ||||
jivecontentprop | modificationdate | int8 | 19 | √ | null | ||
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 | ||||
jiveentitlement | modificationdate | int8 | 19 | √ | null | ||
jiveerror | modificationdate | int8 | 19 | ||||
jiveexternalurl | modificationdate | int8 | 19 | ||||
jivegroup | modificationdate | int8 | 19 | ||||
jivegroupuserhist | modificationdate | int8 | 19 | ||||
jivei18ntext | modificationdate | int8 | 19 | ||||
jiveimage | modificationdate | int8 | 19 | ||||
jiveinboxentry | modificationdate | int8 | 19 | √ | null | ||
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 | ||||
jiverating | modificationdate | int8 | 19 | √ | null | ||
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 | ||||
jivecomment | name | varchar | 100 | √ | null | ||
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 | ||||
jivepermlevel | name | varchar | 25 | √ | null | ||
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 | ||||
jiveuser | name | varchar | 100 | √ | null | ||
jiveusercontnrprop | name | varchar | 100 | ||||
jiveuserprop | name | varchar | 100 | ||||
jiveuserrelgraph | name | varchar | 255 | ||||
jiveusrrellist | name | varchar | 200 | ||||
jiveversion | name | varchar | 50 | ||||
jivewfentry | name | varchar | 20 | √ | null | ||
jivewidgetfrmprop | name | varchar | 100 | ||||
jiveprofileseclvl | namekey | varchar | 128 | ||||
jivebinstore | namespace | varchar | 255 | ||||
jiveuser | namevisible | int4 | 10 | ||||
jiveauditlog | node | varchar | 512 | ||||
jivesystemjob | nodeid | varchar | 512 | √ | null | ||
jiveappalert | notes | varchar | 1024 | √ | null | ||
jiveappinstalert | notes | varchar | 1024 | √ | null | ||
jivebookmark | notes | varchar | 3500 | √ | null | ||
jivewatchsettings | notifyactionqueue | int2 | 5 | ||||
jivewatchsettings | notifydirectaction | int2 | 5 | ||||
jivewatchsettings | notifyinboxnotific | int2 | 5 | ||||
jivewatchsettings | notifymycomm | int2 | 5 | ||||
jiveospropentry | numbervalue | int8 | 19 | √ | null | ||
jivefieldvalue | numvalue | int8 | 19 | √ | null | ||
jivethememap | numvalue | int8 | 19 | √ | null | ||
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 | ||||
jiveannounce | objectid | int8 | 19 | √ | null | ||
jivearchivepolicy | objectid | int4 | 10 | ||||
jiveattachment | objectid | int8 | 19 | √ | null | ||
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 | ||||
jiveimage | objectid | int8 | 19 | √ | null | ||
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 | ||||
jivestreamentry | objectid | int8 | 19 | √ | null | ||
jiveuserperm | objectid | int8 | 19 | ||||
jiveuuid | objectid | int8 | 19 | √ | null | ||
jiveviewcount | objectid | int8 | 19 | ||||
jivewatch | objectid | int8 | 19 | ||||
jivewikilink | objectid | int8 | 19 | ||||
jivestreamentry | objectmediatype | varchar | 32 | √ | null | ||
jivestreamentry | objecttitle | varchar | 1024 | √ | null | ||
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 | ||||
jivedraft | objecttype | int4 | 10 | √ | null | ||
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 | ||||
jivestreamentry | objecttype | int4 | 10 | √ | null | ||
jiveuserperm | objecttype | int4 | 10 | ||||
jiveuuid | objecttype | int4 | 10 | √ | null | ||
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 | ||||
jivedefobjpermlvl | objtype | int8 | 19 | √ | null | ||
jiveobjpermlvl | objtype | int8 | 19 | √ | null | ||
jiveobjtypemsk | objtype | int8 | 19 | ||||
jivepermlvlmsk | objtype | int8 | 19 | √ | null | ||
jivedocumentaudit | oldvalue | text | 2147483647 | √ | null | ||
jiveoauthpairing | onetimecode | varchar | 24 | √ | null | ||
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 | ||||
jivewfcurrentstep | owner | varchar | 100 | √ | null | ||
jivewfhistorystep | owner | varchar | 100 | √ | null | ||
jiveavatar | ownerid | int8 | 19 | √ | null | ||
jivebookmark | ownerid | int8 | 19 | ||||
jivecnxtsvcowner | ownerid | int8 | 19 | ||||
jivelabel | ownerid | int8 | 19 | ||||
jiveptask | ownerid | int8 | 19 | √ | null | ||
jivebookmark | ownertype | int4 | 10 | ||||
jivedvrevision | packageid | int8 | 19 | √ | null | ||
jivedvrevartifact | page | int4 | 10 | ||||
jivedvrevision | pagecount | int4 | 10 | 0 | |||
jiveoauthpairing | pairingsubtypeid | varchar | 48 | ||||
jivepalette | paletteid | int8 | 19 | ||||
jivepaletteprop | paletteid | int8 | 19 | ||||
jivecomment | parentcommentid | int8 | 19 | √ | null | ||
jivebinmetadata | parentid | int8 | 19 | √ | null | ||
jivecontentmeta | parentid | int8 | 19 | ||||
jivesectionelement | parentid | int8 | 19 | ||||
jivemessage | parentmessageid | int8 | 19 | √ | null | ||
jivecomment | parentobjectid | int8 | 19 | √ | null | ||
jiveproject | parentobjectid | int8 | 19 | ||||
jiveptask | parentobjectid | int8 | 19 | ||||
jivewidgetframe | parentobjectid | int8 | 19 | ||||
jivewlayoutframe | parentobjectid | int8 | 19 | ||||
jivecomment | parentobjecttype | int4 | 10 | √ | null | ||
jiveproject | parentobjecttype | int4 | 10 | ||||
jiveptask | parentobjecttype | int4 | 10 | ||||
jivewidgetframe | parentobjecttype | int4 | 10 | ||||
jivewlayoutframe | parentobjecttype | int4 | 10 | ||||
jiveptask | parenttaskid | int8 | 19 | 0 | |||
jivebinmetadata | parenttype | int4 | 10 | √ | null | ||
jivecontentmeta | parenttype | int4 | 10 | ||||
jiveoauthpasscode | passcodeencoded | varchar | 128 | ||||
jiveoauthpasscode | passcodeexpiration | int8 | 19 | √ | null | ||
jiveoauthpasscode | passcodefailedattempts | int4 | 10 | 0 | |||
jivesearchengine | password | varchar | 40 | √ | null | ||
jiveuser | passwordhash | varchar | 64 | ||||
jiveappaction | path | varchar | 2048 | √ | null | ||
jiveexternalurl | path | varchar | 3500 | √ | null | ||
jiveuserrelgraph | peerchoiceallowed | int2 | 5 | 0 | |||
jiveblogpost | permalink | varchar | 255 | √ | null | ||
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 | ||||
jiveblog | pingoverride | int2 | 5 | √ | null | ||
jiveblog | pingservices | text | 2147483647 | √ | null | ||
jivestatics | placeobjectid | int8 | 19 | ||||
jivestatics | placeobjecttype | int4 | 10 | ||||
jivemetering | plaindate | int8 | 19 | ||||
jiveplugin | pluginid | int8 | 19 | ||||
jivepluginprop | pluginname | varchar | 100 | ||||
jivestatuslevelpnt | pointid | int8 | 19 | ||||
jivestatuslevelpntsum | pointlevel | int8 | 19 | √ | null | ||
jivestatlvlscen | points | int8 | 19 | ||||
jivestatuslevelpnt | points | int8 | 19 | ||||
jivepoll | pollid | int8 | 19 | ||||
jivepolloption | pollid | int8 | 19 | ||||
jivepoll | pollmode | int8 | 19 | ||||
jivepopularity | popularityid | int8 | 19 | ||||
jiveexternalurl | port | int4 | 10 | √ | null | ||
jivedoctype | presenterid | int8 | 19 | √ | null | ||
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 | |||
jiveexternalurl | query | varchar | 3500 | √ | null | ||
jivesearchengine | querytestterm | varchar | 40 | √ | 'test'::character varying | ||
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 | ||||
jiveexternalurl | ref | varchar | 3500 | √ | null | ||
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 | |||
jiveoauthtoken | refreshtoken | varchar | 127 | √ | null | ||
jiveprofilefield | regidx | int4 | 10 | (-1) | |||
jiveapprovalwrkflw | rejected | int2 | 5 | ||||
jiveuserrel | relateduserid | int8 | 19 | ||||
jiveuserrel | relationshipid | int8 | 19 | ||||
jiveusrrellistmap | relationshipid | int8 | 19 | ||||
jivestreamentry | releasekeysha1 | varchar | 40 | √ | null | ||
jiveuserrel | relnshiptypeid | int4 | 10 | 2 | |||
jivelicenseconfirm | remoteconfirmid | int8 | 19 | √ | null | ||
jivebridgeuser | remoteuserid | int8 | 19 | ||||
jivebridgeuser | remoteusername | varchar | 100 | ||||
jivewidget | remotewidgetid | int8 | 19 | √ | null | ||
jivelicensereport | reportbody | text | 2147483647 | ||||
jivelicensereport | reportbodye | text | 2147483647 | √ | null | ||
jiveabuse | reportdate | int8 | 19 | ||||
jivelicensereport | reportdate | int8 | 19 | √ | null | ||
jivelicensereport | reporter | varchar | 100 | √ | null | ||
jivelicenseconfirm | reportid | int8 | 19 | √ | null | ||
jivelicensereport | reportid | int8 | 19 | ||||
jiveapprovalwrkflw | requestmessage | varchar | 255 | √ | null | ||
jiveinboxentry | requestmessage | varchar | 255 | √ | null | ||
jivefield | required | int2 | 5 | ||||
jivequestion | resolutiondate | int8 | 19 | √ | null | ||
jivequestion | resolutionstate | int4 | 10 | ||||
jiveabuse | resolved | int2 | 5 | √ | null | ||
jivemetering | resourcetype | varchar | 255 | ||||
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 | ||
jivedvrevartifact | revisionid | int8 | 19 | ||||
jivedvrevision | revisionid | int8 | 19 | ||||
jivedvrevstatus | revisionid | int8 | 19 | ||||
jivedvrevision | revisionnumber | int4 | 10 | ||||
jiveinvite | revokedate | int8 | 19 | √ | null | ||
jiveinvite | revokerid | int8 | 19 | √ | null | ||
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 | searchcontenttype | varchar | 100 | √ | null | ||
jivesearchengine | searchhttpmethod | varchar | 10 | √ | 'GET'::character varying | ||
jivesearchengine | searchurl | varchar | 2000 | ||||
jiveinvite | sentdate | int8 | 19 | √ | null | ||
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 | |||
jiveapperror | source | varchar | 1024 | √ | null | ||
jiveerror | source | varchar | 1024 | √ | null | ||
jivemovedobjects | sourcecontainerid | int8 | 19 | ||||
jivemovedobjects | sourcecontainertype | int4 | 10 | ||||
jiveapperror | sourcedescription | varchar | 1024 | √ | null | ||
jiveapperror | sourcetype | int8 | 19 | ||||
jiveerror | sourcetype | int8 | 19 | ||||
jiveerror | srcobjid | int8 | 19 | √ | null | ||
jiveerror | srcobjtype | int8 | 19 | √ | null | ||
jiveannounce | startdate | int8 | 19 | ||||
jivepoll | startdate | int8 | 19 | ||||
jiveproject | startdate | int8 | 19 | ||||
jivewfcurrentstep | startdate | timestamp | 29,6 | √ | null | ||
jivewfhistorystep | startdate | timestamp | 29,6 | √ | null | ||
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 | |||
jivewfentry | state | int4 | 10 | √ | null | ||
jivestatics | staticid | int8 | 19 | ||||
jiveannounce | status | int4 | 10 | ||||
jiveapperror | status | int8 | 19 | √ | null | ||
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 | ||||
jivecontent | status | int4 | 10 | √ | null | ||
jivedocversion | status | int4 | 10 | ||||
jiveerror | status | int8 | 19 | √ | null | ||
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 | |||
jivewfcurrentstep | status | varchar | 20 | √ | null | ||
jivewfhistorystep | status | varchar | 20 | √ | null | ||
jiveprojectstatus | statusdesc | varchar | 255 | √ | null | ||
jiveprojectstatus | statusid | int8 | 19 | ||||
jivestatuslevel | statuslevelid | int8 | 19 | ||||
jiveprojectstatus | statustype | int4 | 10 | ||||
jiveuserstatus | statustype | int4 | 10 | 0 | |||
jivedvrevstatus | step | int4 | 10 | 0 | |||
jivewfcurrentstep | stepid | int2 | 5 | √ | null | ||
jivewfhistorystep | stepid | int4 | 10 | √ | null | ||
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 | ||||
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 | ||
jiveannounce | subject | varchar | 255 | ||||
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 | ||
jiveptask | subject | varchar | 3500 | ||||
jiveannounce | subjecturl | varchar | 255 | √ | null | ||
jiveerror | subjobjid | int8 | 19 | √ | null | ||
jiveerror | subjobjtype | int8 | 19 | √ | null | ||
jiveuserroster | subuserid | int8 | 19 | ||||
jivedocversion | summary | text | 2147483647 | √ | null | ||
jivestreamentry | summary | varchar | 3500 | √ | null | ||
jiveapp | syslicenseurlmd5 | varchar | 127 | √ | null | ||
jivepermlevel | system | int2 | 5 | 0 | |||
jiveapp | systemlicenseurl | varchar | 1024 | √ | null | ||
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 | targetanchortext | varchar | 3500 | √ | null | ||
jivewikilink | targetattachmentid | int8 | 19 | √ | null | ||
jivewikilink | targetdescription | varchar | 3500 | √ | null | ||
jivestreamentry | targetid | int8 | 19 | √ | null | ||
jivewikilink | targetlinktype | int4 | 10 | ||||
jivegrantedpermlvl | targetobjectid | int8 | 19 | ||||
jiveinboxentry | targetobjectid | int8 | 19 | ||||
jivewikilink | targetobjectid | int8 | 19 | √ | null | ||
jivegrantedpermlvl | targetobjecttype | int4 | 10 | ||||
jiveinboxentry | targetobjecttype | int4 | 10 | ||||
jivewikilink | targetobjecttype | int4 | 10 | √ | null | ||
jivewikilink | targettext | varchar | 3500 | √ | null | ||
jivestreamentry | targettype | int4 | 10 | √ | null | ||
jivewikilink | targeturl | varchar | 3500 | √ | null | ||
jiveptask | taskid | int8 | 19 | ||||
jiveptaskprop | taskid | int8 | 19 | ||||
jivepresenter | template | text | 2147483647 | √ | null | ||
jiveoauthpairing | temppasscodeencoded | varchar | 32 | √ | null | ||
jiveappactiontext | text | text | 2147483647 | √ | null | ||
jivei18ntext | text | varchar | 2000 | ||||
jivestreamenttext | text | text | 2147483647 | √ | null | ||
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 | ||||
jiveappview | title | varchar | 128 | √ | null | ||
jivedocversion | title | varchar | 255 | ||||
jiveexternalurl | title | varchar | 1000 | √ | null | ||
jivestreamentry | title | varchar | 420 | √ | null | ||
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 | ||||
jiveofficecoauthors | ttl | int8 | 19 | √ | null | ||
jivebridgeoption | type | int4 | 10 | ||||
jivecredential | type | int4 | 10 | ||||
jiveextcontext | type | int2 | 5 | ||||
jiveexternalidentity | type | int4 | 10 | ||||
jiveexternallogin | type | int4 | 10 | ||||
jivestreamaction | type | varchar | 32 | ||||
jivewidget | type | varchar | 255 | √ | null | ||
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 | ||||
jivestreamentry | unmappedvalues | text | 2147483647 | √ | null | ||
jivewatchsettings | upgraded | int2 | 5 | 1 | |||
jivebintoken | url | varchar | 2000 | ||||
jivebridge | url | varchar | 255 | ||||
jivebridgedcont | url | varchar | 255 | ||||
jivecnxtendpoint | url | varchar | 2048 | ||||
jivecomment | url | varchar | 255 | √ | null | ||
jiveexternallogin | url | varchar | 255 | √ | null | ||
jiveocbtoken | url | varchar | 255 | ||||
jivermtbridgedcont | url | varchar | 255 | ||||
jivestreamaction | url | varchar | 3500 | √ | null | ||
jiveusercontainer | usercontainerid | int8 | 19 | ||||
jiveusercontnrprop | usercontainerid | int8 | 19 | ||||
jiveuser | userenabled | int4 | 10 | ||||
jiveabuse | userid | int8 | 19 | ||||
jiveactivity | userid | int8 | 19 | √ | null | ||
jiveactivityhistry | userid | int8 | 19 | ||||
jiveannounce | userid | int8 | 19 | ||||
jiveanswer | userid | int8 | 19 | √ | null | ||
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 | ||||
jivecomment | userid | int8 | 19 | √ | null | ||
jivecontaineraprvr | userid | int8 | 19 | ||||
jivecontent | userid | int8 | 19 | √ | null | ||
jivecredential | userid | int8 | 19 | ||||
jivedashboard | userid | int8 | 19 | ||||
jivedevsettings | userid | int8 | 19 | ||||
jivedoccollab | userid | int8 | 19 | ||||
jivedocument | userid | int8 | 19 | ||||
jivedocumentaudit | userid | int8 | 19 | √ | null | ||
jivedocversion | userid | int8 | 19 | ||||
jivedocversioncmmt | userid | int8 | 19 | ||||
jivedraft | userid | int8 | 19 | √ | null | ||
jivedvrevision | userid | int8 | 19 | ||||
jiveeaeuserprop | userid | int8 | 19 | ||||
jiveemailtoken | userid | int8 | 19 | ||||
jiveentitlement | userid | int8 | 19 | √ | null | ||
jiveexternalidentity | userid | int8 | 19 | ||||
jivefollow | userid | int8 | 19 | ||||
jivegroupuser | userid | int8 | 19 | ||||
jivegroupuserhist | userid | int8 | 19 | ||||
jiveinboxentry | userid | int8 | 19 | ||||
jiveinstanceapp | userid | int8 | 19 | ||||
jiveinvite | userid | int8 | 19 | √ | null | ||
jivemessage | userid | int8 | 19 | √ | null | ||
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 | ||||
jivepoll | userid | int8 | 19 | √ | null | ||
jivepollvote | userid | int8 | 19 | √ | null | ||
jiveproject | userid | int8 | 19 | ||||
jiveprojectstatus | userid | int8 | 19 | ||||
jiveptask | userid | int8 | 19 | √ | null | ||
jivequestion | userid | int8 | 19 | ||||
jivequestprogress | userid | int8 | 19 | ||||
jiverating | userid | int8 | 19 | √ | null | ||
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 | ||||
jivesearchengine | username | varchar | 40 | √ | null | ||
jiveuser | username | varchar | 100 | ||||
jiveuserprofile | userprofileid | int8 | 19 | ||||
jiveuserstatus | userstatusid | int8 | 19 | ||||
jiveuserstatus | userstatustext | text | 2147483647 | √ | null | ||
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 | ||||
jivedoctype | validator | varchar | 255 | √ | null | ||
jivefieldtype | validator | varchar | 255 | √ | null | ||
jivecnxtsvcprop | value | varchar | 255 | ||||
jivelabelelement | value | varchar | 255 | √ | null | ||
jiveremotestore | value | bytea | 2147483647 | ||||
jiverenderedcontent | value | text | 2147483647 | ||||
jiveuserprofile | value | varchar | 3500 | √ | null | ||
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 | ||||
jiveuuid | version | int4 | 10 | √ | null | ||
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 | ||||
jiveactivityhistry | viewcount | int4 | 10 | √ | null | ||
jiveviewcount | viewcount | int8 | 19 | √ | 0 | ||
jiveappaction | viewtarget | varchar | 255 | √ | null | ||
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 | ||||
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 |