SchemaSpy - db_700clean.public

Legend:

Primary key columns

Columns with indexes

db_700clean.public contains 2001 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Default
jiveabuse	abuseid	int8	19
jiveabuse	abusetype	int8	19
jiveapiaccessor	accessorid	int8	19
jiveapientitlement	accessorid	int8	19
jiveobjapiaccessor	accessorid	int8	19
jiveapiaccessor	accessortype	int4	10
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
jivetilestreamentry	actiondescription	varchar	255	√	null
jiveappaction	actionid	int8	19
jiveappactiontext	actionid	int8	19
jivewfcurrentstep	actionid	int2	5	√	null
jivewfhistorystep	actionid	int4	10	√	null
jivetilestreamentry	actionname	varchar	127
jivetile	actionurl	varchar	1024	√	null
jiveoauthpairing	activationdate	int8	19	√	null
jivebridgedcont	active	int4	10
jiveimage	active	int2	5		1
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
jiveextensionalert	alerttype	varchar	64
jivecnxtconnection	alias	varchar	255
jivei18ntext	aliaskey	varchar	2000	√	null
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
jiveexpertisetag	approved	int2	5		0
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
jiveextprops	associatedid	int8	19
jiveextprops	associatedtype	int4	10
jiveattachment	attachmentid	int8	19
jiveattachmentdl	attachmentid	int8	19
jiveattachmentprop	attachmentid	int8	19
jiveattachversion	attachmentid	int8	19
jiveappactiontext	attribute	int4	10
jivestreamenttext	attribute	int4	10
jivetilestreamentry	attributionemail	varchar	127	√	null
jivetilestreamentry	attributionname	varchar	127	√	null
jiveauditlog	auditmessageid	int8	19
jivesearchengine	authenticated	int2	5		0
jiveextension	authordata	varchar	255
jivebrowsecnt	authorid	int8	19
jivecnxtauthstyle	authstyleid	int8	19
jivecnxtendpoint	authstyleid	int8	19
jiveavatar	avatarid	int8	19
jiveavatarprop	avatarid	int8	19
jiveavataruser	avatarid	int8	19
jiveavataruser	avataruserid	int8	19
jivetiletemplate	backgroundimageurl	varchar	1024	√	null
jiveban	banid	int8	19
jiveban	banlevel	int4	10
jiveban	banneduserid	int8	19	√	null
jiveban	bantype	int4	10
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
jivetiletemplate	blurb	varchar	400	√	null
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
jivertccollabinteraction	body	text	2147483647
jiveslide	body	text	2147483647
jivestreamentry	body	varchar	1024	√	null
jivetermsandcond	body	text	2147483647	√	null
jivetilestreamentry	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
jivewebhook	bugdetail	varchar	3500	√	null
jivewebhook	buggy	int2	5
jivewebhook	buggydate	int8	19	√	null
jiveextensioni18n	bundle	text	2147483647	√	null
jivetilei18n	bundle	text	2147483647	√	null
jivedevsettings	cacheon	int2	5
jiverenderedcontent	cacheversion	int8	19
jivestatuslevelpntsum	calculationdate	int8	19
jivewfcurrentstep	caller	varchar	100	√	null
jivewfhistorystep	caller	varchar	100	√	null
jiveinboxcategory	categoryid	int8	19
jiveinboxentry	categoryid	int8	19		(-1)
jivetemplatecategory	categoryid	int8	19
jivetemplatecategorydef	categoryid	int8	19
jivetilecategory	categoryid	int8	19
jivetilecategorydef	categoryid	int8	19
jivestreamchannel	channelsigmd5	varchar	127
jivestreamchannel	channelsignature	varchar	3500
jivepcheckpoint	checkpointid	int8	19
jiveoutcome	childobjectid	int8	19		(-1)
jiveoutcome	childobjecttype	int4	10		(-1)
jivewidget	classname	varchar	255
jivewlayout	classname	varchar	255
jiveextprops	clientid	varchar	1024	√	null
jiveoauth2client	clientid	varchar	128
jiveoauthtoken	clientid	varchar	64
jiveprivateprops	clientid	varchar	1024	√	null
jivestoragedefinition	clientid	varchar	1024
jivetile	clientid	varchar	1024	√	null
jiveoauth2client	clientsecret	varchar	128
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
jivertccollaborationstate	collabconsistencystatusid	int2	5
jivertccollabinteraction	collaborationid	int8	19
jivertccollaboration	collaborationid	int8	19
jivertccollaborationstate	collaborationid	int8	19
jivertccollaborationuser	collaborationid	int8	19
jivertcinteractionidmap	collaborationid	int8	19
jivertcinteractionperiod	collaborationid	int8	19
jivedoccollab	collaboratortype	int2	5
jivedashboard	columncount	int4	10
jiveappview	columnnumber	int4	10		0
jivecomment	commentid	int8	19
jivecommentprop	commentid	int8	19
jiveextcomments	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
jiveqcompletion	completiondate	int8	19
jiveqstepprog	completiondate	int8	19	√	null
jivemetering	component	varchar	255
jivepageviewconfig	component	varchar	255
jivetileinstance	config	text	2147483647	√	null
jivestoragedefinition	configcontainerurl	varchar	2048	√	null
jivestoragedefinition	configinstanceurl	varchar	2048	√	null
jivetile	configurationurl	varchar	1024	√	null
jivepageviewconfig	configxml	text	2147483647	√	null
jivecnxtconnection	connectionid	int8	19
jivewebhook	connectiontimeout	int4	10	√	null
jivestoragecontainer	containerconfig	text	2147483647	√	null
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
jivecarouselcontainer	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
jiveoutcome	containerid	int8	19
jivepopularity	containerid	int8	19
jivequestion	containerid	int8	19
jivertccollaboration	containerid	int8	19
jiveslide	containerid	int8	19
jivestatuslevelpnt	containerid	int8	19
jivestatuslevelpntsum	containerid	int8	19
jivetagcloud	containerid	int8	19
jivetagset	containerid	int8	19
jivethread	containerid	int8	19
jivetilestreamentry	containerid	int8	19
jiveuserstatus	containerid	int8	19		(-1)
jivewebhook	containerid	int8	19
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
jiveoutcome	containertype	int4	10
jivepopularity	containertype	int4	10
jivequestion	containertype	int8	19
jivertccollaboration	containertype	int4	10
jiveslide	containertype	int4	10
jivestatuslevelpnt	containertype	int8	19
jivestatuslevelpntsum	containertype	int8	19
jivetagcloud	containertype	int4	10
jivetagset	containertype	int4	10
jivethread	containertype	int4	10
jivetilestreamentry	containertype	int4	10
jiveuserstatus	containertype	int4	10		(-1)
jivewebhook	containertype	int4	10
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
jivetiletemplate	contenttypes	varchar	1500	√	null
jivetilestreamentry	context	text	2147483647	√	null
jiveextensionalert	contextdata	text	2147483647	√	null
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
jivecarouselcontainer	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
jiveexpertisetag	creationdate	int8	19
jiveexportrequest	creationdate	int8	19
jiveextcomments	creationdate	int8	19
jiveextension	creationdate	int8	19
jiveextensionalert	creationdate	int8	19
jiveexternalurl	creationdate	int8	19
jiveextprops	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
jiveidmembership	creationdate	int8	19
jiveimage	creationdate	int8	19
jiveinboxcategory	creationdate	int8	19
jiveinboxentry	creationdate	int8	19
jiveinstanceapp	creationdate	int8	19
jiveinvite	creationdate	int8	19
jivemarketoutmsg	creationdate	int8	19
jivemessage	creationdate	int8	19
jiveoauth2client	creationdate	int8	19
jiveoauth2code	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
jiveoutcome	creationdate	int8	19
jivepcheckpoint	creationdate	int8	19
jiveplugin	creationdate	int8	19
jivepoll	creationdate	int8	19
jivepopularity	creationdate	int8	19
jiveprivateprops	creationdate	int8	19
jiveproject	creationdate	int8	19
jiveprojectstatus	creationdate	int8	19
jiveptask	creationdate	int8	19
jiveqstepprog	creationdate	int8	19	√	null
jivequestion	creationdate	int8	19
jiverating	creationdate	int8	19	√	null
jivertccollabinteraction	creationdate	int8	19
jivertccollaboration	creationdate	int8	19
jivertccollaborationstate	creationdate	int8	19
jivertcinteractionperiod	creationdate	int8	19
jivesgroup	creationdate	int8	19
jivesgroupmember	creationdate	int8	19
jiveslide	creationdate	int8	19
jivestatics	creationdate	int8	19
jivestatuslevelpnt	creationdate	int8	19
jivestoragecontainer	creationdate	int8	19
jivestoragedefinition	creationdate	int8	19
jivestorageinstance	creationdate	int8	19
jivestreamchannel	creationdate	int8	19
jivestreamentry	creationdate	int8	19
jivetag	creationdate	int8	19
jivetagset	creationdate	int8	19
jivetemplatecategorydef	creationdate	int8	19
jivethread	creationdate	int8	19
jivetile	creationdate	int8	19
jivetilecategorydef	creationdate	int8	19
jivetileinstance	creationdate	int8	19
jivetilestreamentry	creationdate	int8	19
jivetiletemplate	creationdate	int8	19
jiveuser	creationdate	int8	19
jiveusercontainer	creationdate	int8	19
jiveuserrel	creationdate	int8	19
jiveusersecretkey	creationdate	int8	19
jiveuserstatus	creationdate	int8	19
jivewebhook	creationdate	int8	19
jivewebhooklocks	creationdate	int8	19
jivewebhookqueue	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
jivesession	data	bytea	2147483647	√	null
jivetile	dataproviderkey	varchar	127		'external'::character varying
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
jivei18ntext	defaulttext	varchar	2000	√	null
jiveextension	definition	text	2147483647	√	null
jivestoragedefinition	definitionid	int8	19
jivestoragedefresource	definitionid	int8	19
jivestorageinstance	definitionid	int8	19
jivefield	defvalue	varchar	255	√	null
jivetileinstgone	deletiondate	int8	19
jiveocservicestats	delta	int8	19
jivedemoreco	demorecoid	int8	19
jiveextension	deploydate	int8	19	√	null
jiveextension	deployerid	int8	19	√	null
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
jiveextension	description	varchar	255
jivefield	description	varchar	1000	√	null
jivefieldtype	description	varchar	1000	√	null
jivegroup	description	varchar	1000	√	null
jiveinboxcategory	description	varchar	1000
jivemessagequeue	description	varchar	255	√	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
jivestoragedefinition	description	varchar	4000	√	null
jivetagset	description	varchar	1000	√	null
jivetemplatecategorydef	description	varchar	1000
jivetile	description	varchar	4000	√	null
jivetilecategorydef	description	varchar	1000
jivetiletemplate	description	varchar	4000	√	null
jivesearchengine	descriptorurl	varchar	2000	√	null
jivearchivepolicy	destcontainerid	int4	10
jivearchivepolicy	destcontainertype	int8	19
jiveauditlog	details	varchar	2048	√	null
jivemessagequeue	details	bytea	2147483647
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
jivestoragedefinition	displayname	varchar	1027
jivestorageinstance	displayname	varchar	1027
jivetile	displayname	varchar	255	√	null
jivetiletemplate	displayname	varchar	255	√	null
jivedirsyncuser	dn	varchar	4000
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
jivertcinteractionperiod	earliestinteractiondate	int8	19
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	email	varchar	100	√	null
jiveinvite	email	varchar	100	√	null
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
jiveplugin	enabled	int4	10		1
jiveprofileseclvl	enabled	int2	5		1
jivesearchengine	enabled	int4	10
jivestatlvlscen	enabled	int2	5
jivestorageinsconfig	enabled	int2	5
jiveuserrelgraph	enabled	int2	5		1
jivewebhook	enabled	int2	5
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
jivetaskhistory	endtime	int8	19
jivetaskhistory_1	endtime	int8	19
jivetaskhistory_2	endtime	int8	19
jivetasklateststatus	endtime	int8	19	√	null
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
jivestoragemember	entityid	int8	19
jivestoragemember	entitytype	int4	10
jiveinboxentry	entryid	int8	19
jiveinboxentryprop	entryid	int8	19
jivewebhookqueue	entryid	int8	19
jivewfcurrentstep	entryid	int8	19	√	null
jivewfhistorystep	entryid	int8	19	√	null
jiveinboxentry	entrytype	int4	10
jiveexportrequest	error	varchar	4000	√	null
jiveerror	errorid	int8	19
jivestorageattachment	espattid	varchar	128	√	null
jivestoragecomment	espcommentid	varchar	128	√	null
jivestoragefile	espfileid	varchar	128	√	null
jivestoragefileversion	espfileversionid	varchar	128	√	null
jivestoragemember	espid	varchar	128	√	null
jivestoragepreview	esppreviewid	varchar	128	√	null
jivetaskqueue	exectime	int8	19
jivetaskhistory	executionerror	text	2147483647	√	null
jivetaskhistory_1	executionerror	text	2147483647	√	null
jivetaskhistory_2	executionerror	text	2147483647	√	null
jivetaskhistory	executionid	int8	19
jivetaskhistory_1	executionid	int8	19
jivetaskhistory_2	executionid	int8	19
jivetaskhistory	executor	varchar	255
jivetaskhistory_1	executor	varchar	255
jivetaskhistory_2	executor	varchar	255
jivetasklateststatus	executor	varchar	255	√	null
jiveexpertisetag	expertisetagid	int8	19
jivewatch	expirable	int2	5
jiveoauthstore	expiration	int8	19	√	null
jiveban	expirationdate	int8	19	√	null
jivebintoken	expirationdate	int8	19
jivedocument	expirationdate	int8	19
jiveoauth2code	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
jivestorageattachment	exstorageattid	int8	19
jivestoragecomment	exstoragecommentid	int8	19
jivestorageattachment	exstoragecontainerid	int8	19
jivestoragecontainer	exstoragecontainerid	int8	19
jivestoragefile	exstoragecontainerid	int8	19
jivestoragemember	exstoragecontainerid	int8	19
jivestoragepreview	exstoragecontainerid	int8	19
jiveattachment	exstoragefileid	int8	19	√	null
jivedocument	exstoragefileid	int8	19	√	null
jivestoragecomment	exstoragefileid	int8	19
jivestoragefile	exstoragefileid	int8	19
jivestoragefileversion	exstoragefileid	int8	19
jivestoragepreview	exstoragefileid	varchar	128	√	null
jivedocversion	exstoragefileversionid	int8	19	√	null
jivestoragefileversion	exstoragefileversionid	int8	19
jivedvrevartifact	exstorageid	int8	19	√	null
jivestoragemember	exstorageid	int8	19
jivestoragecontainer	exstorageinstanceid	int8	19
jivestoragepreview	exstoragepreviewid	int8	19
jiveextcomments	extcommentid	int8	19
jiveobjpermlvlext	extender	int8	19		0
jiveobjpermlvlmap	extender	int8	19		0
jiveobjpermlvlmsk	extender	int8	19		0
jiveobjtypemsk	extender	int8	19		0
jiveextensionalert	extensionalertid	int8	19
jiveextension	extensionid	int8	19
jiveextensionalert	extensionid	int8	19
jiveextensioni18n	extensionid	int8	19
jiveextensiontag	extensionid	int8	19
jiveoauth2client	extensionid	int8	19
jiveapp	extensionuuid	varchar	127	√	null
jiveextension	extensionuuid	varchar	128
jivestoragedefinition	extensionuuid	varchar	128	√	null
jivetile	extensionuuid	varchar	48	√	null
jivetiletemplate	extensionuuid	varchar	48		'none'::character varying
jivertccollabinteraction	externalcreationdate	int8	19
jiveextcomments	externalid	varchar	255
jivertccollaboration	externalid	varchar	1024	√	null
jivestoragecontainer	externalid	varchar	128	√	null
jivetilestreamentry	externalid	varchar	255	√	null
jiveuuidext	externalid	varchar	255
jiveexternalidentity	externalidentityid	int8	19
jiveuuidext	externalidtype	varchar	128
jivetiletemplate	externallyaccessible	int2	5	√	null
jivestoragecomment	externalmodificationtime	int8	19	√	null
jivertccollaboration	externalpublishdate	int8	19
jivesearchengine	externalsearchurl	varchar	2000
jivetilestreamentry	externalurl	varchar	1024
jivertccollabinteraction	extinteractionid	int8	19
jivertcinteractionidmap	extinteractionid	int8	19
jiveprofilefield	extmanaged	int2	5
jiveprofilefield	extmapping	varchar	2048	√	null
jiveextprops	extpropsid	int8	19
jiveextprops	extpropskey	varchar	4000	√	null
jiveextprops	extpropsvalue	varchar	4000	√	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
jivewebhook	fields	varchar	2000	√	null
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
jiveexportrequest	filelength	int4	10
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	int8	19	√	null
jivedvrevartifact	filesize	int4	10
jivedvrevision	filesize	int8	19
jiveimage	filesize	int4	10
jiveocbmetadata	filesize	int8	19	√	null
jiveosfileitem	filesize	int8	19
jiveappaction	filter	varchar	2048	√	null
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
jivetiletemplate	global	int4	10		0
jiveospropentry	globalkey	varchar	150	√	null
jivestoragedefinition	gotocontainername	varchar	1027	√	null
jivestoragedefinition	gotofilename	varchar	1027	√	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
jivetiletemplate	grouptype	int4	10	√	null
jivegroupuserhist	groupuserid	int8	19
jivepollvote	guestid	varchar	255	√	null
jivecnxtsvcheader	headerid	int8	19
jivecnxtsvcheader	headername	varchar	255
jivecnxtsvcheader	headervalue	varchar	255
jivestoragedefinition	healthcheckurl	varchar	2048	√	null
jiveanswer	helpfulanswer	int2	5
jivecnxtcredtype	helpkey	varchar	64
jivetemplatecategorydef	hidden	int4	10		0
jivetilecategorydef	hidden	int4	10		0
jiveactivityhistry	historyid	int8	19
jivewebhook	hookid	int8	19
jivewebhookqueue	hookid	int8	19
jiveexternalurl	host	varchar	3500
jivecluster	hostname	varchar	255
jiveocservicestats	httpmethod	varchar	10
jivestatlvlscen	i18nkey	varchar	100
jiveinboxcategory	iconclass	varchar	64
jiveappaction	iconurl	varchar	2048	√	null
jivecnxtendpoint	iconurl	varchar	2048	√	null
jivesearchengine	iconurl	varchar	2000	√	null
jivebookmark	id	int8	19
jivecluster	id	varchar	255
jivecontentmeta	id	int8	19
jivecontentmtprop	id	int8	19
jiveexternalurl	id	int8	19
jiveid	id	int8	19
jivemarketoutmsg	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
jiveslide	imageuri	varchar	2048
jivetilestreamentry	imageurl	varchar	1024
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
jiveapp	installtype	int2	5		0
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
jivestorageinsconfig	instanceconfig	text	2147483647	√	null
jivetileinstance	instancedata	text	2147483647	√	null
jivedvrevartifact	instanceid	varchar	255
jiveformattedtext	instanceid	int8	19
jivestorageinsconfig	instanceid	int8	19
jivestorageinstance	instanceid	int8	19
jivetileinstance	instanceorder	int4	10
jivertccollaborationstate	interactionconsistencystatusid	int2	5
jivertcinteractionidmap	interactionid	int8	19
jivetemplatecategorydef	internal	int4	10		1
jivetilecategorydef	internal	int4	10		1
jivewebhook	internal	int2	5
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
jivestoragedefinition	internali18nkeys	varchar	1024	√	null
jivetile	internali18nkeys	varchar	1024	√	null
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
jivertcinteractionperiod	ismostrecent	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
jivestoragecomment	jivecommentid	int8	19
jivestoragecontainer	jivecontainerid	int8	19
jivestoragecontainer	jivecontainertype	int4	10
jiveremotestore	keyid	int8	19
jiveusersecretkey	keyvalue	varchar	255
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
jivetileinstance	lastdatapush	int8	19	√	null
jiveuser	lastloggedin	int8	19		0
jiveextensioni18n	lastmodified	int8	19
jivetilei18n	lastmodified	int8	19
jiveuser	lastname	varchar	100	√	null
jiveuser	lastprofileupdate	int8	19		0
jivetileinstance	lastregister	int8	19	√	null
jivecluster	lasttouchtime	int8	19
jiveofficecoauthors	lastupdatedate	int8	19	√	null
jivemetering	lastupdatets	int8	19	√	null
jivepageviewconfig	lastupdatets	int8	19
jivertcinteractionperiod	latestinteractiondate	int8	19
jiveproject	lateststatusid	int8	19	√	null
jiveuserstatus	latitude	float8	17,17		(-1)
jivewlayout	layoutid	int8	19
jivewlayoutframe	layoutid	int8	19
jivedirsyncuser	ldif	text	2147483647	√	null
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
jivewebhook	listenas	int8	19
jiveusrrellist	listid	int8	19
jiveusrrellistmap	listid	int8	19
jivermtbridgedcont	localcontentid	int8	19
jivermtbridgedcont	localcontenttype	int8	19
jiveappactiontext	locale	varchar	16
jiveextensioni18n	locale	varchar	10
jivei18ntext	locale	varchar	100
jivelocalizedprop	locale	varchar	100
jiverenderedcontent	locale	varchar	100
jivestreamenttext	locale	varchar	16
jivetilei18n	locale	varchar	10
jivecommunity	localecode	varchar	32	√	null
jiveinstanceapp	locallymanaged	int2	5		1
jivebridgeoption	localorigin	int2	5		0
jivetaskqueue	lockingnode	varchar	255	√	null
jivewebhooklocks	lockingnode	varchar	255	√	null
jivelock	lockname	varchar	255
jivelockproperty	lockname	varchar	255
jivetaskqueue	locktime	int8	19	√	null
jivewebhooklocks	locktime	int8	19	√	null
jiveuuid	longid	int8	19
jiveuserstatus	longitude	float8	17,17		(-1)
jiveobjpermlvl	lvltype	varchar	25	√	null
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
jiveextensionalert	message	varchar	256	√	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
jiveextension	metadata	text	2147483647	√	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
jivecarouselcontainer	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
jiveexportrequest	modificationdate	int8	19
jiveextcomments	modificationdate	int8	19
jiveextension	modificationdate	int8	19
jiveextensionalert	modificationdate	int8	19
jiveexternalurl	modificationdate	int8	19
jiveextprops	modificationdate	int8	19
jivegroup	modificationdate	int8	19
jivegroupuserhist	modificationdate	int8	19
jivei18ntext	modificationdate	int8	19
jiveimage	modificationdate	int8	19
jiveinboxcategory	modificationdate	int8	19
jiveinboxentry	modificationdate	int8	19	√	null
jiveinstanceapp	modificationdate	int8	19
jiveinvite	modificationdate	int8	19
jivemessage	modificationdate	int8	19
jiveoauth2client	modificationdate	int8	19
jiveoauth2code	modificationdate	int8	19
jiveoauthpairing	modificationdate	int8	19
jiveoauthtoken	modificationdate	int8	19
jiveocbmetadata	modificationdate	int8	19
jiveocbtoken	modificationdate	int8	19
jiveosfileitem	modificationdate	int8	19
jiveoutcome	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
jiveprivateprops	modificationdate	int8	19
jiveproject	modificationdate	int8	19
jiveptask	modificationdate	int8	19
jiveqstepprog	modificationdate	int8	19	√	null
jiverating	modificationdate	int8	19	√	null
jivertccollabinteraction	modificationdate	int8	19
jivertccollaboration	modificationdate	int8	19
jivertccollaborationstate	modificationdate	int8	19
jivertcinteractionperiod	modificationdate	int8	19
jivesgroup	modificationdate	int8	19
jiveslide	modificationdate	int8	19
jivestatics	modificationdate	int8	19
jivestoragecontainer	modificationdate	int8	19
jivestoragedefinition	modificationdate	int8	19
jivestorageinstance	modificationdate	int8	19
jivestreamchannel	modificationdate	int8	19
jivestreamentry	modificationdate	int8	19
jivetagset	modificationdate	int8	19
jivetemplatecategorydef	modificationdate	int8	19
jivethread	modificationdate	int8	19
jivetile	modificationdate	int8	19
jivetilecategorydef	modificationdate	int8	19
jivetileinstance	modificationdate	int8	19
jivetilestreamentry	modificationdate	int8	19
jivetiletemplate	modificationdate	int8	19
jiveuser	modificationdate	int8	19
jiveusercontainer	modificationdate	int8	19
jiveuserrel	modificationdate	int8	19
jiveuserstatus	modificationdate	int8	19		0
jivewebhook	modificationdate	int8	19
jivewebhookqueue	modificationdate	int8	19
jivetilestreamentry	modifieremail	text	2147483647	√	null
jivetilestreamentry	modifiername	text	2147483647	√	null
jiveavatar	modvalue	int4	10
jivemessagequeue	msgid	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
jivecarouselcontainer	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
jiveextension	name	varchar	255
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
jiveinboxcategory	name	varchar	255
jiveinboxentryprop	name	varchar	100
jiveinstapppref	name	varchar	128
jiveinviteprop	name	varchar	100
jivelabel	name	varchar	200
jivelocalizedprop	name	varchar	100
jivelockproperty	name	varchar	255
jivemessageprop	name	varchar	100
jiveobjpermlvl	name	varchar	25
jiveocbmetadata	name	varchar	255
jiveosfileitem	name	varchar	255
jiveoutcomeprop	name	varchar	100
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
jiveqstepprogprop	name	varchar	255
jivequestionprop	name	varchar	100
jivesgroup	name	varchar	255
jivesgroupprop	name	varchar	100
jivestatuslevel	name	varchar	255
jivestoragedefinition	name	varchar	127
jivestorageresourcename	name	varchar	127
jivestreamentprop	name	varchar	100
jivetagset	name	varchar	100
jivetemplatecategorydef	name	varchar	100
jivethreadprop	name	varchar	100
jivetilecategorydef	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
jivestorageresource	nameid	int8	19
jiveprofileseclvl	namekey	varchar	128
jivebinstore	namespace	varchar	255
jiveuser	namevisible	int4	10
jiveauditlog	node	varchar	512
jiveoutcome	note	text	2147483647		''::text
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	notifymoderationqueue	int2	5
jivewatchsettings	notifymycomm	int2	5
jivewatchsettings	notifyprofileupdates	int2	5
jiveospropentry	numbervalue	int8	19	√	null
jivefieldvalue	numvalue	int8	19	√	null
jivethememap	numvalue	int8	19	√	null
jivetile	oauth2dependent	int2	5		0
jiveoauth2client	oauthclientid	int8	19
jiveoauth2code	oauthclientid	int8	19
jiveoauth2code	oauthcodeid	int8	19
jivewebhook	oauthcodeid	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
jivedemoreco	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
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
jivestorageentupdate	objectid	int8	19
jivestorageresource	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
jivewebhook	objectid	int8	19	√	null
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
jivedemoreco	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
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
jivestorageentupdate	objecttype	int4	10
jivestorageresource	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
jivewebhook	objecttype	int4	10	√	null
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
jivetilestreamentry	opengraphtype	varchar	127
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
jivestorageinsconfig	orderidx	int4	10
jivestorageinstance	orderidx	int4	10
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
jivemessagequeue	originator	varchar	255
jiveexpertisetag	originuserid	int8	19
jivebridgedcont	origsubject	varchar	1000
jivebridgedcont	origtags	varchar	3500
jiveoutcome	outcomeid	int8	19
jiveoutcomeprop	outcomeid	int8	19
jiveoutcome	outcometypeid	int4	10
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
jivetile	ownerid	int8	19	√	null
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
jivecomment	parentcommentid	int8	19	√	null
jivebinmetadata	parentid	int8	19	√	null
jivecontentmeta	parentid	int8	19
jivesectionelement	parentid	int8	19
jivemessage	parentmessageid	int8	19	√	null
jivecarouselcontainer	parentobjectid	int8	19
jivecomment	parentobjectid	int8	19	√	null
jiveoutcome	parentobjectid	int8	19
jiveproject	parentobjectid	int8	19
jiveptask	parentobjectid	int8	19
jivetileinstance	parentobjectid	int8	19
jivewidgetframe	parentobjectid	int8	19
jivewlayoutframe	parentobjectid	int8	19
jivecarouselcontainer	parentobjecttype	int4	10
jivecomment	parentobjecttype	int4	10	√	null
jiveoutcome	parentobjecttype	int4	10
jiveproject	parentobjecttype	int4	10
jiveptask	parentobjecttype	int4	10
jivetileinstance	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
jivewebhookqueue	payload	bytea	2147483647
jiveuserrelgraph	peerchoiceallowed	int2	5		0
jivedemoreco	peoplescore	float8	17,17
jivestoragedefinition	perfixurl	varchar	2048	√	null
jivertccollabinteraction	periodid	int8	19
jivertcinteractionperiod	periodid	int8	19
jiveblogpost	permalink	varchar	255	√	null
jivegroupperm	permission	int4	10
jivestoragemember	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
jivestoragecontainer	permsancestor	int8	19	√	null
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
jiveextension	pluginsourcesha1	varchar	48	√	null
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
jivedemoreco	popularityscore	float8	17,17
jiveexternalurl	port	int4	10	√	null
jiveoutcome	predecessoroutcomeid	int8	19		(-1)
jivedoctype	presenterid	int8	19	√	null
jivepresenter	presenterid	int8	19
jivewfcurrstepprev	previousid	int8	19
jivewfhiststepprev	previousid	int8	19
jiveuserprofile	primaryval	int2	5
jiveprivateprops	privatepropsid	int8	19
jiveprivateprops	privatepropskey	varchar	4000	√	null
jiveprivateprops	privatepropsvalue	varchar	4000	√	null
jivedirsyncuser	processed	int4	10		0
jiveexportrequest	processedcount	int4	10
jivearchivepolicy	processingdate	int8	19
jivetile	productname	varchar	255	√	null
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	varchar	3500
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
jiveoutcomeprop	propvalue	varchar	3500
jivepaletteprop	propvalue	text	2147483647
jivepluginprop	propvalue	varchar	3500
jiveprojectprop	propvalue	varchar	3500
jiveproperty	propvalue	varchar	3500
jiveptaskprop	propvalue	varchar	3500
jiveqstepprogprop	propvalue	varchar	3500
jivequestionprop	propvalue	varchar	3500
jivesgroupprop	propvalue	varchar	3500
jivestreamentprop	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
jiveprofilefield	pseudo	int2	5		0
jiveblogpost	publishdate	int8	19
jiveslide	publishdate	int8	19
jivewidgetframe	published	int4	10
jivewlayoutframe	published	int4	10		0
jiveextension	publishedclientid	varchar	127	√	null
jiveextension	publishedclientsecret	varchar	127	√	null
jiveextension	publisheduuid	varchar	128	√	null
jiveextension	publishedversionid	int8	19	√	null
jiveexternalurl	query	varchar	3500	√	null
jivesearchengine	querytestterm	varchar	40	√	'test'::character varying
jiveqcompletion	questcompletionid	int8	19
jiveqcompletion	questname	varchar	255
jiveapprovalwrkflw	queuedtype	int2	5
jivedocument	readcount	int4	10
jivereadtracker	readdate	int8	19
jivewebhook	readtimeout	int4	10	√	null
jivewatchsettings	receiveemails	int2	5
jivewatchsettings	receivehtmlemails	int2	5		1
jivedemoreco	recoindex	int4	10
jivedocument	recommended	int2	5
jivedocversion	recordid	int8	19
jivebinstore	recordtype	int4	10
jivedemoreco	recotype	int4	10
jiveacccontainer	recursive	int4	10
jiveoauth2client	redirecturi	varchar	2000
jiveoauth2code	redirecturi	varchar	2000	√	null
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)
jivestoragedefinition	registerurl	varchar	2048
jivetile	registerurl	varchar	2500	√	null
jiveapprovalwrkflw	rejected	int2	5
jiveoauth2code	relatedid	int8	19	√	null
jiveuserrel	relateduserid	int8	19
jiveuserrel	relationshipid	int8	19
jiveusrrellistmap	relationshipid	int8	19
jivestreamentry	releasekeysha1	varchar	40	√	null
jiveuserrel	relnshiptypeid	int4	10		2
jivebridgeuser	remoteuserid	int8	19
jivebridgeuser	remoteusername	varchar	100
jivewidget	remotewidgetid	int8	19	√	null
jiveextension	removable	int2	5		1
jiveabuse	reportdate	int8	19
jiveexportrequest	requestenddate	int8	19
jiveexportrequest	requestid	int8	19
jiveapprovalwrkflw	requestmessage	varchar	255	√	null
jiveinboxentry	requestmessage	varchar	255	√	null
jiveexportrequest	requestuserid	int8	19
jivefield	required	int2	5
jivequestion	resolutiondate	int8	19	√	null
jivequestion	resolutionstate	int4	10
jiveabuse	resolved	int2	5	√	null
jivestoragedefinition	resolveresourcesurl	varchar	2048
jivestoragedefresource	resourcenameid	int8	19
jivestorageresourcename	resourcenameid	int8	19
jivemetering	resourcetype	varchar	255
jiveapprovalwrkflw	responsemessage	varchar	255	√	null
jiveinboxentry	responsemessage	varchar	255	√	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
jivetile	sampledata	text	2147483647	√	null
jivestatlvlscen	scenarioid	int8	19
jiveoauth2code	scope	varchar	1000	√	null
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
jiveexportrequest	searchquery	varchar	4000	√	null
jivesearchengine	searchurl	varchar	2000
jivemessagequeue	sendtime	int8	19
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
jiveextension	serviceurl	varchar	1024
jiveoauthtoken	sessionid	varchar	64	√	null
jiveextensionalert	severity	varchar	25		'INFO'::character varying
jivesearchengine	shortname	varchar	255
jiveslide	slideid	int8	19
jiveidmembership	slug	varchar	50
jiveannounce	sortkey	int4	10		0
jiveslide	sortkey	int4	10		0
jivetiletmplassoc	sortorder	int4	10
jiveapperror	source	varchar	1024	√	null
jiveerror	source	varchar	1024	√	null
jiveapperror	sourcedescription	varchar	1024	√	null
jivertccollaboration	sourceid	int2	5
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
jivetaskhistory	starttime	int8	19
jivetaskhistory_1	starttime	int8	19
jivetaskhistory_2	starttime	int8	19
jivetasklateststatus	starttime	int8	19	√	null
jivebridgeoption	state	int4	10		0
jivedocversion	state	varchar	20
jiveinboxentry	state	int2	5
jiveinvite	state	int4	10
jivestoragecontainer	state	int4	10	√	null
jivetasklateststatus	state	int2	5	√	null
jivetile	state	varchar	64		'PUBLISHED'::character varying
jivetileinstance	state	varchar	64
jivetiletemplate	state	varchar	64		'PUBLISHED'::character varying
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
jivecarouselcontainer	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
jiveexportrequest	status	int4	10
jiveextension	status	varchar	25		''::character varying
jiveexternalurl	status	int4	10
jivemessage	status	int4	10
jiveoutcome	status	int4	10		1
jivepoll	status	int4	10
jiveproject	status	int4	10
jivesgroup	status	int4	10
jiveslide	status	int4	10
jivetasklateststatus	status	bytea	2147483647	√	null
jivethread	status	int4	10
jivetileinstance	status	text	2147483647	√	null
jivetilestreamentry	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
jiveqstepprog	stepname	varchar	255
jiveqstepprog	stepprogressid	int8	19
jiveqstepprogprop	stepprogressid	int8	19
jivedvrevartifact	storagekeyversion	int4	10		1
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
jivertccollaboration	subject	text	2147483647	√	''::text
jiveslide	subject	varchar	255
jivetilestreamentry	subject	varchar	255	√	null
jiveannounce	subjecturl	varchar	3500	√	null
jivertccollaboration	subjecturl	text	2147483647	√	''::text
jiveerror	subjobjid	int8	19	√	null
jiveerror	subjobjtype	int8	19	√	null
jivetiletemplate	subtitle	varchar	127	√	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
jiveexpertisetag	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
jiveextension	targetconfig	varchar	4000	√	null
jivewikilink	targetdescription	varchar	3500	√	null
jiveexportrequest	targetenddate	int8	19
jivestreamentry	targetid	int8	19	√	null
jiveslide	targetlink	varchar	2048
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
jiveexportrequest	targetstartdate	int8	19
jivewikilink	targettext	varchar	3500	√	null
jivestreamentry	targettype	int4	10	√	null
jivewikilink	targeturl	varchar	3500	√	null
jiveexpertisetag	targetuserid	int8	19
jiveexportrequest	targetuserid	int8	19
jivetaskqueue	taskdetails	bytea	2147483647	√	null
jivetaskqueue	taskdigest	bpchar	32	√	null
jiveptask	taskid	int8	19
jiveptaskprop	taskid	int8	19
jivetaskqueue	taskid	int8	19
jivetaskhistory	taskuid	varchar	255
jivetaskhistory_1	taskuid	varchar	255
jivetaskhistory_2	taskuid	varchar	255
jivetasklateststatus	taskuid	varchar	255
jivetaskqueue	taskuid	varchar	255
jivepresenter	template	text	2147483647	√	null
jivetemplatecategory	templateid	int8	19
jivetiletemplate	templateid	int8	19
jivetiletmplassoc	templateid	int8	19
jivetiletemplate	templatename	varchar	127
jiveoauthpairing	temppasscodeencoded	varchar	255	√	null
jiveextension	tenancyuri	varchar	256	√	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
jivetile	tileid	int8	19
jivetilecategory	tileid	int8	19
jivetilei18n	tileid	int8	19
jivetileinstance	tileid	int8	19
jivetilestreamentry	tileid	int8	19
jivetiletmplassoc	tileid	int8	19
jiveextcomments	tileinstanceid	int8	19
jivetileinstance	tileinstanceid	int8	19
jivetileinstgone	tileinstanceid	int8	19
jivetilestreamentry	tileinstanceid	int8	19
jivetile	tilename	varchar	127
jiveextcomments	tilestreamentryid	int8	19
jivetilestreamentry	tilestreamentryid	int8	19
jivedirsyncuser	time	int8	19
jiveauditlog	timestamp	int8	19
jiveextensionalert	timestamp	int8	19
jivelock	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
jivedemoreco	topicsscore	float8	17,17
jiveocservicestats	trackeddate	int8	19
jiveofficecoauthors	ttl	int8	19	√	null
jivebridgeoption	type	int4	10
jivecredential	type	int4	10
jiveextcontext	type	int2	5
jiveextension	type	varchar	25
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
jivertccollaboration	typeid	int2	5
jivetypevldtrprop	typeid	int8	19
jivedoctype	typeindex	int4	10
jivewebhook	types	varchar	2000	√	null
jivewebhook	typesmd5	varchar	48	√	null
jivestreamentry	unmappedvalues	text	2147483647	√	null
jivetile	unregisterurl	varchar	2500	√	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
jivestorageresource	url	varchar	2500
jivestreamaction	url	varchar	3500	√	null
jivewebhook	url	varchar	2000
jivewebhooklocks	url	varchar	2000
jivewebhookqueue	url	varchar	2000
jiveusercontainer	usercontainerid	int8	19
jiveusercontnrprop	usercontainerid	int8	19
jiveuser	userenabled	int4	10
jivestoragedefinition	userfaceurl	varchar	2048	√	null
jivestorageinsconfig	usergroupid	int8	19
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
jivecarouselcontainer	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
jivedemoreco	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
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
jiveidmembership	userid	int8	19
jiveinboxentry	userid	int8	19
jiveinstanceapp	userid	int8	19
jiveinvite	userid	int8	19	√	null
jivemessage	userid	int8	19	√	null
jiveoauth2client	userid	int8	19
jiveoauth2code	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
jiveoutcome	userid	int8	19
jivepoll	userid	int8	19	√	null
jivepollvote	userid	int8	19	√	null
jiveprivateprops	userid	int8	19
jiveproject	userid	int8	19
jiveprojectstatus	userid	int8	19
jiveptask	userid	int8	19	√	null
jiveqcompletion	userid	int8	19
jiveqstepprog	userid	int8	19
jivequestion	userid	int8	19
jiverating	userid	int8	19	√	null
jivereadtracker	userid	int8	19
jivertccollabinteraction	userid	int8	19
jivertccollaboration	userid	int8	19
jivertccollaborationuser	userid	int8	19
jivesgroup	userid	int8	19
jivesgroupmember	userid	int8	19
jiveslide	userid	int8	19
jivestatics	userid	int8	19
jivestatuslevelpnt	userid	int8	19
jivestatuslevelpntsum	userid	int8	19
jivestreamapprover	userid	int8	19
jivestreamentry	userid	int8	19
jivetileinstance	userid	int8	19
jivetilestreamentry	userid	int8	19
jivetiletemplate	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
jiveusersecretkey	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
jivewebhook	userid	int8	19
jivestorageinstance	usermappingfield1	int8	19
jivestorageinstance	usermappingfield2	int8	19	√	null
jivestorageinstance	usermappingoption	int4	10
jivestoragedefinition	usermappingoptions	varchar	127	√	null
jivedirsyncuser	username	varchar	255
jivesearchengine	username	varchar	40	√	null
jiveuser	username	varchar	100
jiveuserprofile	userprofileid	int8	19
jiveusersecretkey	usersecretkeyid	int8	19
jiveuserstatus	userstatusid	int8	19
jiveuserstatus	userstatustext	text	2147483647	√	null
jiveuser	usertype	int4	10		0
jivebridgedcont	uuid	varchar	128
jivebridgeuser	uuid	varchar	128
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
jiveextensiontag	value	varchar	25
jivelabelelement	value	varchar	255	√	null
jivelockproperty	value	varchar	255
jiveoauth2code	value	varchar	128
jiveremotestore	value	bytea	2147483647
jiverenderedcontent	value	text	2147483647
jiveuserprofile	value	varchar	3500	√	null
jiveoauth2code	valuetype	int2	5
jivedocversioncmmt	vcommentid	int8	19
jivebintoken	verb	varchar	255
jiveocbtoken	verb	varchar	4
jivestreamentry	verb	varchar	128
jivestorageresource	verbs	int2	5
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
jiveextension	visibletouserid	int8	19	√	null
jivetile	visualstyle	varchar	64
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
jivespamdomainwhitelist	whitelisturl	varchar	255
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