setoopif.public contains 2622 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
boxcollaborations	boxcollaborationid	varchar	30
boxcollaborations	jivecontainerid	int8	19
boxcollaborations	jivecontainertype	int4	10
boxcollaborations	jiveuserid	int8	19
boxcomments	boxcommentid	varchar	30
boxcomments	jivecommentid	int8	19
boxfiles	boxfileid	varchar	30
boxfiles	boxfileurl	varchar	200
boxfiles	etag	varchar	30
boxfiles	sequenceid	varchar	30
boxfileversions	boxfileid	varchar	30
boxfileversions	boxfileversionid	varchar	30
boxfileversions	jivebinarybodyid	int8	19
boxfolders	boxfolderid	varchar	30
boxfolders	jivecontainerid	int8	19
boxfolders	jivecontainertype	int4	10
eapisartifactupdateevents	description	varchar	200
eapisartifactupdateevents	eventdate	int8	19
eapisartifactupdateevents	eventid	int8	19
eapisartifactupdateevents	eventtype	varchar	50
eapisartifactupdateevents	feature	varchar	50
eapisartifactupdateevents	issuccessful	int2	5
eapisartifactupdateevents	userid	int8	19
eapiscontainerconnect	connectid	int8	19
eapiscontainerconnect	containerid	int8	19
eapiscontainerconnect	containertype	int4	10
eapisjabconnections	id	int8	19
eapisjabconnections	url	varchar	2000
eapisjabmodulecontent	binkey	varchar	255
eapisjabmodulecontent	contentkey	varchar	255
eapisjabmodulecontent	length	int8	19
eapisjabmodulecontent	moduleid	int8	19
eapisjabmodulecontent	modulename	varchar	20
eapisjabmodulecontent	resourcedate	int8	19
eapisjabmodules	creator	int8	19
eapisjabmodules	ext_key	varchar	255	√		null
eapisjabmodules	id	int8	19
eapisjabmodules	ispublished	int4	10
eapisjabmodules	moduledisplayname	varchar	255
eapisjabmodules	modulename	varchar	20
eapisjaburlpatterns	moduleid	int8	19
eapisjaburlpatterns	pattern	varchar	350
eapisstats	lastactivity	int8	19
eapisstats	objectid	int8	19
eapisstats	objecttype	int4	10
eapisstats	stathash	int8	19
eapisstats	stattype	int4	10
eapisstatsactive	app	int4	10
eapisstatsactive	firstactivity	int8	19
eapisstatsactive	knownversion	varchar	255
eapisstatsactive	lastactivity	int8	19
eapisstatsactive	stathash	int8	19
eapisstatsactive	userid	int8	19
espboxfiles	boxfileid	varchar	30
espboxfiles	etag	varchar	30
espboxfiles	sequenceid	varchar	30
espboxfileversions	boxfileid	varchar	30
espboxfileversions	boxfileversionid	varchar	30
espboxfileversions	jiveexternalversionid	int8	19
espboxfolders	boxfolderid	varchar	30
espboxfolders	jiveaccesstoken	varchar	127
espboxfolders	jiveauthexpiresin	int8	19
espboxfolders	jivecontainerrelativeurl	varchar	256
espboxfolders	jiverefreshtoken	varchar	127
espboxfolders	jiveurl	varchar	256
gamificationprtcp	containerid	int8	19
gamificationprtcp	containertype	int4	10
gamificationprtcp	userid	int8	19
gamificationrequestqueue	data	text	2147483647
gamificationrequestqueue	requestid	int8	19
jiveabuse	abuseid	int8	19
jiveabuse	abusetype	int8	19
jiveabuse	comments	varchar	255	√		null
jiveabuse	objectid	int8	19
jiveabuse	objecttype	int8	19
jiveabuse	reportdate	int8	19
jiveabuse	resolved	int2	5	√		null
jiveabuse	userid	int8	19
jiveacccontainer	acclaimid	int8	19
jiveacccontainer	containerid	int8	19
jiveacccontainer	containertype	int4	10
jiveacccontainer	recursive	int4	10
jiveacclaim	acclaimid	int8	19
jiveacclaim	acclaimtype	varchar	20
jiveacclaim	creationdate	int8	19
jiveacclaim	modificationdate	int8	19
jiveacclaim	objectid	int8	19
jiveacclaim	objecttype	int4	10
jiveacclaim	score	numeric	131089			0
jiveacclaim	scoredisplay	numeric	131089			0
jiveacclaim	visibility	int4	10			1
jiveacclaimprop	acclaimid	int8	19
jiveacclaimprop	name	varchar	100
jiveacclaimprop	propvalue	varchar	3500
jiveacclaimvote	acclaimid	int8	19
jiveacclaimvote	creationdate	int8	19
jiveacclaimvote	modificationdate	int8	19
jiveacclaimvote	voteid	int8	19
jiveacclaimvote	voterid	int8	19
jiveacclaimvote	votevalue	int4	10			0
jiveaccvoteprop	name	varchar	100
jiveaccvoteprop	propvalue	varchar	3500
jiveaccvoteprop	voteid	int8	19
jiveactivity	activityid	int8	19
jiveactivity	activitytype	int4	10
jiveactivity	containerid	int8	19
jiveactivity	containertype	int4	10
jiveactivity	creationdate	int8	19
jiveactivity	objectid	int8	19
jiveactivity	objecttype	int4	10
jiveactivity	userid	int8	19	√		null
jiveactivityhistry	createcount	int4	10	√		null
jiveactivityhistry	creationdate	int8	19
jiveactivityhistry	historyid	int8	19
jiveactivityhistry	userid	int8	19
jiveactivityhistry	viewcount	int4	10	√		null
jiveannounce	announcementid	int8	19
jiveannounce	body	text	2147483647	√		null
jiveannounce	creationdate	int8	19			0
jiveannounce	enddate	int8	19	√		null
jiveannounce	minorcreateedit	int2	5			0
jiveannounce	modificationdate	int8	19			0
jiveannounce	objectid	int8	19	√		null
jiveannounce	objecttype	int4	10
jiveannounce	sortkey	int4	10			0
jiveannounce	startdate	int8	19
jiveannounce	status	int4	10
jiveannounce	subject	varchar	255
jiveannounce	subjecturl	varchar	3500	√		null
jiveannounce	userid	int8	19
jiveannounceprop	announcementid	int8	19
jiveannounceprop	name	varchar	100
jiveannounceprop	propvalue	varchar	3500
jiveanswer	containerid	int8	19
jiveanswer	containertype	int8	19
jiveanswer	correctanswer	int2	5
jiveanswer	helpfulanswer	int2	5
jiveanswer	messageid	int8	19
jiveanswer	threadid	int8	19
jiveanswer	userid	int8	19	√		null
jiveapiaccessor	accessorid	int8	19
jiveapiaccessor	accessortype	int4	10
jiveapientitlement	accessorid	int8	19
jiveapientitlement	creationdate	int8	19
jiveapientitlement	entitlementid	int8	19
jiveapientitlement	entitlementtype	varchar	127
jiveapientitlement	modificationdate	int8	19
jiveapientitlement	userid	int8	19
jiveapp	appid	int8	19
jiveapp	apppath	varchar	127	√		null
jiveapp	appuuid	varchar	127
jiveapp	creationdate	int8	19
jiveapp	developmentapp	int2	5			0
jiveapp	extensionuuid	varchar	127	√		null
jiveapp	gadgethash	varchar	127	√		null
jiveapp	installorigin	varchar	4			'mkt'::character varying
jiveapp	installtype	int2	5			0
jiveapp	internalname	varchar	255	√		null
jiveapp	modificationdate	int8	19
jiveapp	refreshcompleted	int8	19			'-1'::integer
jiveapp	refreshrequested	int8	19			'-1'::integer
jiveapp	refreshstarted	int8	19			'-1'::integer
jiveapp	refreshstate	varchar	5			'never'::character varying
jiveapp	syslicenseurlmd5	varchar	127	√		null
jiveapp	systemlicenseurl	varchar	1024	√		null
jiveappaction	actionid	int8	19
jiveappaction	appid	int8	19
jiveappaction	appview	varchar	255	√		null
jiveappaction	contributionid	varchar	1024
jiveappaction	creationdate	int8	19
jiveappaction	filter	varchar	2048	√		null
jiveappaction	iconurl	varchar	2048	√		null
jiveappaction	modificationdate	int8	19
jiveappaction	path	varchar	2048	√		null
jiveappaction	style	varchar	255	√		null
jiveappaction	url	varchar	2048	√		null
jiveappaction	viewtarget	varchar	255	√		null
jiveappaction	windowspec	varchar	1024	√		null
jiveappactiontext	actionid	int8	19
jiveappactiontext	attribute	int4	10
jiveappactiontext	locale	varchar	16
jiveappactiontext	text	text	2147483647	√		null
jiveappalert	appalertid	int8	19
jiveappalert	appid	int8	19
jiveappalert	code	int8	19
jiveappalert	creationdate	int8	19
jiveappalert	creatorname	varchar	1024	√		null
jiveappalert	creatoruserid	int8	19	√		null
jiveappalert	effectivedate	int8	19	√		null
jiveappalert	modificationdate	int8	19
jiveappalert	notes	varchar	1024	√		null
jiveappalertack	appalertid	int8	19
jiveappalertack	creationdate	int8	19
jiveappalertack	userid	int8	19
jiveapperror	apperrorid	int8	19
jiveapperror	appid	int8	19	√		null
jiveapperror	code	int8	19
jiveapperror	creationdate	int8	19
jiveapperror	modificationdate	int8	19
jiveapperror	source	varchar	1024	√		null
jiveapperror	sourcedescription	varchar	1024	√		null
jiveapperror	sourcetype	int8	19
jiveapperror	status	int8	19	√		null
jiveappinstalert	acknowledged	int8	19
jiveappinstalert	appinstalertid	int8	19
jiveappinstalert	code	int8	19
jiveappinstalert	creationdate	int8	19
jiveappinstalert	creatorname	varchar	1024	√		null
jiveappinstalert	creatoruserid	int8	19	√		null
jiveappinstalert	effectivedate	int8	19	√		null
jiveappinstalert	instanceappid	int8	19
jiveappinstalert	modificationdate	int8	19
jiveappinstalert	notes	varchar	1024	√		null
jiveapprovalwrkflw	approvaltime	int8	19	√		null
jiveapprovalwrkflw	approved	int2	5
jiveapprovalwrkflw	creationtime	int8	19
jiveapprovalwrkflw	objid	int8	19
jiveapprovalwrkflw	queuedtype	int2	5
jiveapprovalwrkflw	rejected	int2	5
jiveapprovalwrkflw	requestmessage	varchar	255	√		null
jiveapprovalwrkflw	responsemessage	varchar	255	√		null
jiveapprovalwrkflw	typeid	int8	19
jiveapprovalwrkflw	userid	int8	19
jiveapprovalwrkflw	workflowid	int8	19
jiveappsecurity	appid	int8	19
jiveappsecurity	appsecurityid	int8	19
jiveappsecurity	creationdate	int8	19
jiveappsecurity	groupid	int8	19
jiveappsecurity	modificationdate	int8	19
jiveappview	appviewid	int8	19
jiveappview	columnnumber	int4	10			0
jiveappview	creationdate	int8	19
jiveappview	dashboardid	int8	19
jiveappview	initialheights	varchar	127	√		null
jiveappview	instanceappid	int8	19	√		null
jiveappview	modificationdate	int8	19
jiveappview	rownumber	int4	10			0
jiveappview	title	varchar	128	√		null
jivearchivepolicy	destcontainerid	int8	19
jivearchivepolicy	destcontainertype	int8	19
jivearchivepolicy	objectid	int8	19
jivearchivepolicy	objecttype	int8	19
jivearchivepolicy	orgcontainerid	int8	19
jivearchivepolicy	orgcontainertype	int8	19
jivearchivepolicy	processingdate	int8	19
jivearchivepolicy	status	int4	10
jivearchivepolicy	userid	int8	19
jivearchivepolicy	visibility	int4	10
jiveattachment	attachmentid	int8	19
jiveattachment	contenttype	varchar	100
jiveattachment	creationdate	int8	19
jiveattachment	documentid	varchar	255	√		null
jiveattachment	exstoragefileid	int8	19	√		null
jiveattachment	filename	varchar	255
jiveattachment	filesize	int4	10
jiveattachment	modificationdate	int8	19
jiveattachment	objectid	int8	19	√		null
jiveattachment	objecttype	int4	10
jiveattachment	status	int4	10
jiveattachmentprop	attachmentid	int8	19
jiveattachmentprop	name	varchar	100
jiveattachmentprop	propvalue	varchar	3500
jiveattachsettings	allowbydefault	int2	5
jiveattachsettings	enabled	int2	5
jiveattachsettings	maxnumber	int4	10
jiveattachsettings	maxsize	int4	10
jiveattachsettings	typeid	int8	19
jiveattachtypes	allowedtype	varchar	50	√		null
jiveattachtypes	disallowedtype	varchar	50	√		null
jiveattachtypes	typeid	int8	19
jiveattachversion	attachmentid	int8	19
jiveattachversion	internaldocid	int8	19
jiveattachversion	versionid	int4	10
jiveauditlog	auditmessageid	int8	19
jiveauditlog	description	varchar	1024
jiveauditlog	details	varchar	2048	√		null
jiveauditlog	node	varchar	512
jiveauditlog	timestamp	int8	19
jiveauditlog	userid	int8	19
jiveavatar	avatarid	int8	19
jiveavatar	modvalue	int4	10
jiveavatar	ownerid	int8	19	√		null
jiveavatarprop	avatarid	int8	19
jiveavatarprop	name	varchar	100
jiveavatarprop	propvalue	varchar	3500
jiveavataruser	avatarid	int8	19
jiveavataruser	avataruserid	int8	19
jiveavataruser	userid	int8	19
jiveavscanrecord	antivirusid	int8	19
jiveavscanrecord	lastscandate	int8	19
jiveavscanrecord	lastsuccessdate	int8	19
jiveavscanrecord	objectid	int8	19
jiveavscanrecord	objecttype	int4	10
jiveavscanrecord	scancount	int4	10
jiveavscanrecord	scanrequestdate	int8	19
jiveavscanrecord	statusid	int4	10
jiveavscanrecord	violations	varchar	255	√		null
jivebadgerole	badgeroleid	int8	19
jivebadgerole	comparatortoken	int4	10	√		null
jivebadgerole	name	varchar	100
jivebadgerolerel	badgeimageuri	varchar	2048
jivebadgerolerel	badgeroleid	int8	19
jivebadgerolerel	badgerolerelid	int8	19
jivebadgerolerel	creationdate	int8	19
jivebadgerolerel	enabled	int2	5			0
jivebadgerolerel	modificationdate	int8	19
jivebadgerolerel	relatedobjectid	int8	19
jivebadgerolerel	relatedobjecttype	int4	10
jivebadgerolerel	userid	int8	19
jiveban	adminid	int8	19
jiveban	banid	int8	19
jiveban	banlevel	int4	10
jiveban	banneduserid	int8	19	√		null
jiveban	bantype	int4	10
jiveban	comments	varchar	50	√		null
jiveban	creationdate	int8	19
jiveban	expirationdate	int8	19	√		null
jiveban	ipaddress	varchar	15	√		null
jivebinmetadata	appinstanceid	int8	19	√		null
jivebinmetadata	binarymetadataid	int8	19
jivebinmetadata	contentencoding	varchar	255	√		null
jivebinmetadata	contentlanguage	varchar	255	√		null
jivebinmetadata	contentlength	int8	19	√		null
jivebinmetadata	contentlocation	varchar	2000	√		null
jivebinmetadata	contentmd5	varchar	255	√		null
jivebinmetadata	contenttype	varchar	255	√		null
jivebinmetadata	creationdate	int8	19
jivebinmetadata	description	varchar	2000	√		null
jivebinmetadata	displayname	varchar	255	√		null
jivebinmetadata	modificationdate	int8	19
jivebinmetadata	name	varchar	255
jivebinmetadata	parentid	int8	19	√		null
jivebinmetadata	parenttype	int4	10	√		null
jivebinmetadata	userid	int8	19
jivebinstore	bindata	bytea	2147483647
jivebinstore	binkey	varchar	255
jivebinstore	datasize	int8	19
jivebinstore	namespace	varchar	255
jivebinstore	recordtype	int4	10
jivebintoken	accesstokenid	int8	19
jivebintoken	binarymetadataid	int8	19
jivebintoken	creationdate	int8	19
jivebintoken	expirationdate	int8	19
jivebintoken	modificationdate	int8	19
jivebintoken	token	varchar	255
jivebintoken	url	varchar	2000
jivebintoken	verb	varchar	255
jiveblog	blogid	int8	19
jiveblog	cmauthentication	int2	5	√		null
jiveblog	containerid	int8	19			'-2'::integer
jiveblog	containertype	int4	10			17
jiveblog	creationdate	int8	19
jiveblog	description	varchar	1000	√		null
jiveblog	displayname	varchar	255	√		null
jiveblog	feedenabled	int2	5	√		null
jiveblog	feedfullcontent	int2	5	√		null
jiveblog	modificationdate	int8	19
jiveblog	name	varchar	255
jiveblog	pingoverride	int2	5	√		null
jiveblog	pingservices	text	2147483647	√		null
jiveblog	status	int4	10
jiveblogpost	blogid	int8	19
jiveblogpost	blogpostid	int8	19
jiveblogpost	body	text	2147483647	√		null
jiveblogpost	commentstatus	int4	10
jiveblogpost	creationdate	int8	19
jiveblogpost	minoredit	int2	5			0
jiveblogpost	modificationdate	int8	19
jiveblogpost	permalink	varchar	255	√		null
jiveblogpost	publishdate	int8	19
jiveblogpost	status	int4	10
jiveblogpost	subject	varchar	255	√		null
jiveblogpost	userid	int8	19
jiveblogpostprop	blogpostid	int8	19
jiveblogpostprop	name	varchar	100
jiveblogpostprop	propvalue	varchar	3500
jiveblogprop	blogid	int8	19
jiveblogprop	name	varchar	100
jiveblogprop	propvalue	varchar	3500
jivebookmark	creationdate	int8	19
jivebookmark	creatorid	int8	19
jivebookmark	creatortype	int4	10
jivebookmark	id	int8	19
jivebookmark	markedid	int8	19
jivebookmark	markedtype	int4	10
jivebookmark	modificationdate	int8	19
jivebookmark	notes	varchar	3500	√		null
jivebookmark	ownerid	int8	19
jivebookmark	ownertype	int4	10
jivebookmark	status	int4	10
jivebookmark	subject	varchar	255	√		null
jivebridge	bridgeid	int8	19
jivebridge	creationdate	int8	19
jivebridge	description	varchar	255	√		null
jivebridge	disabled	int2	5
jivebridge	engineid	int8	19			'-1'::integer
jivebridge	name	varchar	255
jivebridge	url	varchar	255
jivebridge	userid	int8	19
jivebridgedcont	active	int4	10
jivebridgedcont	bridgedcontid	int8	19
jivebridgedcont	contentid	int8	19
jivebridgedcont	contenttype	int8	19
jivebridgedcont	origcontentid	int8	19
jivebridgedcont	origcontenttype	int8	19
jivebridgedcont	origsubject	varchar	1000
jivebridgedcont	origtags	varchar	3500
jivebridgedcont	rootmessageid	int8	19
jivebridgedcont	url	varchar	255
jivebridgedcont	uuid	varchar	128
jivebridgedcontmsg	body	text	2147483647
jivebridgedcontmsg	bridgedcontid	int8	19
jivebridgedcontmsg	bridgedcontmsgid	int8	19
jivebridgedcontmsg	creationdate	int8	19
jivebridgedcontmsg	orderindex	int4	10
jivebridgedcontmsg	origcontentid	int8	19
jivebridgedcontmsg	origcontenttype	int8	19
jivebridgedcontmsg	userid	int8	19
jivebridgeoption	bridgeid	int8	19
jivebridgeoption	localorigin	int2	5			0
jivebridgeoption	state	int4	10			0
jivebridgeoption	type	int4	10
jivebridgeuser	remoteuserid	int8	19
jivebridgeuser	remoteusername	varchar	100
jivebridgeuser	userid	int8	19
jivebridgeuser	uuid	varchar	128
jivebrowsecnt	authorid	int8	19
jivebrowsecnt	browseid	int8	19
jivebrowsecnt	containerid	int8	19
jivebrowsecnt	containertype	int4	10
jivebrowsecnt	creationdate	int8	19
jivebrowsecnt	lastactivitydate	int8	19
jivebrowsecnt	modificationdate	int8	19
jivebrowsecnt	objectid	int8	19
jivebrowsecnt	objecttype	int4	10
jivebrowsecnt	status	int4	10
jivebrowsecnt	subject	varchar	255	√		null
jivebrowsecntr	browseid	int8	19
jivebrowsecntr	containerid	int8	19
jivebrowsecntr	containertype	int4	10
jivebrowsecntr	creationdate	int8	19
jivebrowsecntr	displayname	varchar	255	√		null
jivebrowsecntr	lastactivitydate	int8	19
jivebrowsecntr	modificationdate	int8	19
jivebrowsecntr	name	varchar	255
jivebrowsecntr	objectid	int8	19
jivebrowsecntr	objecttype	int4	10
jivebrowsecntr	status	int4	10
jivebrowsefol	browseid	int8	19
jivebrowsefol	userid	int8	19
jivebrowseprtd	browseid	int8	19
jivebrowseprtd	userid	int8	19
jivecarouselcontainer	containerid	int8	19
jivecarouselcontainer	creationdate	int8	19
jivecarouselcontainer	modificationdate	int8	19
jivecarouselcontainer	name	varchar	255
jivecarouselcontainer	parentobjectid	int8	19
jivecarouselcontainer	parentobjecttype	int4	10
jivecarouselcontainer	status	int4	10
jivecarouselcontainer	userid	int8	19
jivecluster	hostname	varchar	255
jivecluster	id	varchar	255
jivecluster	lasttouchtime	int8	19
jivecnxtauthstyle	authstyleid	int8	19
jivecnxtauthstyle	creationdate	int8	19
jivecnxtauthstyle	credentialstypes	varchar	255	√		null
jivecnxtauthstyle	description	varchar	2048	√		null
jivecnxtauthstyle	displayname	varchar	255	√		null
jivecnxtauthstyle	modificationdate	int8	19
jivecnxtauthstyle	name	varchar	255
jivecnxtconnection	alias	varchar	255
jivecnxtconnection	appinstanceid	int8	19
jivecnxtconnection	connectionid	int8	19
jivecnxtconnection	creationdate	int8	19
jivecnxtconnection	enabled	int2	5
jivecnxtconnection	modificationdate	int8	19
jivecnxtconnection	serviceid	int8	19
jivecnxtconnection	userid	int8	19
jivecnxtcredtype	creationdate	int8	19
jivecnxtcredtype	credentialstypeid	int8	19
jivecnxtcredtype	description	varchar	2048	√		null
jivecnxtcredtype	displayname	varchar	255	√		null
jivecnxtcredtype	format	varchar	16
jivecnxtcredtype	helpkey	varchar	64
jivecnxtcredtype	labelkey	varchar	64
jivecnxtcredtype	modificationdate	int8	19
jivecnxtcredtype	name	varchar	255
jivecnxtendpoint	authstyleid	int8	19
jivecnxtendpoint	creationdate	int8	19
jivecnxtendpoint	description	varchar	2048	√		null
jivecnxtendpoint	displayname	varchar	255	√		null
jivecnxtendpoint	documentationurl	varchar	2048	√		null
jivecnxtendpoint	enabled	int2	5
jivecnxtendpoint	endpointid	int8	19
jivecnxtendpoint	iconurl	varchar	2048	√		null
jivecnxtendpoint	lenient	int2	5			0
jivecnxtendpoint	modificationdate	int8	19
jivecnxtendpoint	name	varchar	255
jivecnxtendpoint	url	varchar	2048
jivecnxtendpoint	wsdlurl	varchar	2048	√		null
jivecnxtsvcheader	creationdate	int8	19
jivecnxtsvcheader	headerid	int8	19
jivecnxtsvcheader	headername	varchar	255
jivecnxtsvcheader	headervalue	varchar	255
jivecnxtsvcheader	modificationdate	int8	19
jivecnxtsvcheader	serviceid	int8	19
jivecnxtsvcowner	creationdate	int8	19
jivecnxtsvcowner	modificationdate	int8	19
jivecnxtsvcowner	ownerid	int8	19
jivecnxtsvcowner	serviceid	int8	19
jivecnxtsvcowner	userid	int8	19
jivecnxtsvcprop	creationdate	int8	19
jivecnxtsvcprop	modificationdate	int8	19
jivecnxtsvcprop	name	varchar	255
jivecnxtsvcprop	propertyid	int8	19
jivecnxtsvcprop	serviceid	int8	19
jivecnxtsvcprop	value	varchar	255
jivecnxttag	creationdate	int8	19
jivecnxttag	description	varchar	2048	√		null
jivecnxttag	displayname	varchar	255	√		null
jivecnxttag	modificationdate	int8	19
jivecnxttag	name	varchar	255
jivecnxttag	tagid	int8	19
jivecomment	body	text	2147483647
jivecomment	commentid	int8	19
jivecomment	creationdate	int8	19
jivecomment	email	varchar	254	√		null
jivecomment	ip	varchar	15	√		null
jivecomment	modificationdate	int8	19
jivecomment	name	varchar	100	√		null
jivecomment	objectid	int8	19
jivecomment	objecttype	int4	10
jivecomment	parentcommentid	int8	19	√		null
jivecomment	parentobjectid	int8	19	√		null
jivecomment	parentobjecttype	int4	10	√		null
jivecomment	status	int4	10
jivecomment	url	varchar	255	√		null
jivecomment	userid	int8	19	√		null
jivecommentprop	commentid	int8	19
jivecommentprop	name	varchar	100
jivecommentprop	propvalue	varchar	3500
jivecommunity	communityid	int8	19
jivecommunity	creationdate	int8	19
jivecommunity	description	varchar	1000	√		null
jivecommunity	displayname	varchar	255
jivecommunity	lft	int4	10
jivecommunity	localecode	varchar	32	√		null
jivecommunity	modificationdate	int8	19
jivecommunity	name	varchar	255
jivecommunity	rgt	int4	10
jivecommunity	status	int4	10
jivecommunity	workflowid	int8	19	√		null
jivecommunityprop	communityid	int8	19
jivecommunityprop	name	varchar	100
jivecommunityprop	propvalue	varchar	3500
jivecontaineraprvr	containerid	int8	19
jivecontaineraprvr	containertype	int4	10
jivecontaineraprvr	userid	int8	19
jivecontent	body	text	2147483647	√		null
jivecontent	containerid	int8	19	√		null
jivecontent	containertype	int8	19	√		null
jivecontent	contentid	int8	19
jivecontent	contenttype	int8	19
jivecontent	creationdate	int8	19	√		null
jivecontent	modificationdate	int8	19	√		null
jivecontent	status	int4	10	√		null
jivecontent	subject	varchar	255	√		null
jivecontent	userid	int8	19	√		null
jivecontentbackup	body	text	2147483647	√		null
jivecontentbackup	modificationdate	int8	19
jivecontentbackup	objectid	int8	19
jivecontentbackup	objecttype	int4	10
jivecontentbackup	versionid	int4	10
jivecontentmeta	contentid	int8	19
jivecontentmeta	contenttype	int4	10
jivecontentmeta	id	int8	19
jivecontentmeta	parentid	int8	19
jivecontentmeta	parenttype	int4	10
jivecontentmtprop	id	int8	19
jivecontentmtprop	name	varchar	100
jivecontentmtprop	propvalue	varchar	3500
jivecontentplacerel	containerid	int8	19
jivecontentplacerel	containertype	int4	10
jivecontentplacerel	contentobjectid	int8	19
jivecontentplacerel	contentobjecttype	int4	10
jivecontentplacerel	creationdate	int8	19
jivecontentplacerel	modificationdate	int8	19
jivecontentplacerel	relationshipid	int8	19
jivecontentplacerel	userid	int8	19
jivecontentprop	contentid	int8	19
jivecontentprop	contenttype	int8	19
jivecontentprop	modificationdate	int8	19	√		null
jivecontentprop	propname	varchar	255
jivecontentprop	propvalue	varchar	3500
jivecredential	artifactid	int8	19
jivecredential	token	bytea	2147483647
jivecredential	type	int4	10
jivecredential	userid	int8	19
jivecrmadaptercapabilities	adaptername	varchar	50
jivecrmadaptercapabilities	capabilityid	int8	19
jivecrmadaptercapabilities	description	varchar	200
jivecrmadaptercapabilities	isenabled	int2	5			0
jivecrmcasemapping	authorid	int8	19
jivecrmcasemapping	caseid	varchar	100
jivecrmcasemapping	escalatorid	int8	19
jivecrmcasemapping	mappingid	int8	19
jivecrmcasemapping	threadid	int8	19
jivecrmconfiguration	adaptername	varchar	50
jivecrmconfiguration	configurationtype	varchar	50
jivecrmconfiguration	configurationvalues	bytea	2147483647	√		null
jivecrmconfiguration	containerid	int8	19
jivecrmconfiguration	containertype	int4	10
jivecrmescalationqueue	containerid	int8	19
jivecrmescalationqueue	containertype	int4	10
jivecrmescalationqueue	creationdate	int8	19
jivecrmescalationqueue	threadid	int8	19
jivecrmescalationsettings	containerid	int8	19
jivecrmescalationsettings	containertype	int4	10
jivecrmescalationsettings	periodinseconds	int8	19
jivecrmsyncedusers	userid	int8	19
jivecustompermlvl	creationdate	int8	19
jivecustompermlvl	creatorid	int8	19	√		null
jivecustompermlvl	description	varchar	255
jivecustompermlvl	modificationdate	int8	19
jivecustompermlvl	permlevelid	int8	19
jivedashboard	columncount	int4	10
jivedashboard	containerid	int8	19
jivedashboard	containertype	int4	10
jivedashboard	creationdate	int8	19
jivedashboard	dashboardid	int8	19
jivedashboard	displayname	varchar	128
jivedashboard	modificationdate	int8	19
jivedashboard	orderindex	int4	10
jivedashboard	userid	int8	19
jivedatatype	datatype	varchar	20
jivedatatype	datatypeid	int8	19
jivedefobjpermlvl	objpermlevelid	int8	19
jivedefobjpermlvl	objtype	int8	19	√		null
jivedeletedobjects	deleteddate	int8	19
jivedeletedobjects	id	int8	19
jivedeletedobjects	objectid	int8	19
jivedeletedobjects	objecttype	int4	10
jivedemoreco	demorecoid	int8	19
jivedemoreco	objectid	int8	19
jivedemoreco	objecttype	int4	10
jivedemoreco	peoplescore	float8	17,17
jivedemoreco	popularityscore	float8	17,17
jivedemoreco	recoindex	int4	10
jivedemoreco	recotype	int4	10
jivedemoreco	topicsscore	float8	17,17
jivedemoreco	userid	int8	19
jivedevsettings	cacheon	int2	5
jivedevsettings	creationdate	int8	19
jivedevsettings	devsettingsid	int8	19
jivedevsettings	modificationdate	int8	19
jivedevsettings	userid	int8	19
jivedirsyncuser	dn	varchar	4000
jivedirsyncuser	ldif	text	2147483647	√		null
jivedirsyncuser	processed	int4	10			0
jivedirsyncuser	time	int8	19
jivedirsyncuser	username	varchar	255
jivedocbodyconfig	allowbydefault	int4	10
jivedocbodyconfig	enabled	int4	10
jivedocbodyconfig	maxsize	int4	10
jivedocbodyconfig	typeid	int8	19
jivedocbodytypes	allowedtype	varchar	50	√		null
jivedocbodytypes	disallowedtype	varchar	50	√		null
jivedocbodytypes	typeid	int8	19
jivedocbodyversion	bodyid	int8	19
jivedocbodyversion	internaldocid	int8	19
jivedocbodyversion	versionid	int4	10
jivedoccollab	collaboratortype	int2	5
jivedoccollab	internaldocid	int8	19
jivedoccollab	userid	int8	19
jivedocelementtype	elementtypeid	int8	19
jivedocelementtype	name	varchar	20
jivedoctype	description	varchar	1000	√		null
jivedoctype	name	varchar	100
jivedoctype	presenterid	int8	19	√		null
jivedoctype	typeid	int8	19
jivedoctype	typeindex	int4	10
jivedoctype	validator	varchar	255	√		null
jivedoctypeelement	documenttypeid	int8	19
jivedoctypeelement	elementid	int8	19
jivedoctypeelement	elementindex	int4	10
jivedoctypeelement	elementtypeid	int8	19
jivedoctypeelement	frowversion	int8	19	√		null
jivedoctypeprop	name	varchar	100
jivedoctypeprop	propvalue	varchar	3500
jivedoctypeprop	typeid	int8	19
jivedocument	commentstatus	int4	10
jivedocument	containerid	int8	19
jivedocument	containertype	int4	10
jivedocument	creationdate	int8	19
jivedocument	documentid	varchar	255
jivedocument	editpolicy	int4	10
jivedocument	expirationdate	int8	19
jivedocument	exstoragefileid	int8	19	√		null
jivedocument	internaldocid	int8	19
jivedocument	meanrating	int4	10
jivedocument	readcount	int4	10
jivedocument	recommended	int2	5
jivedocument	typeid	int8	19
jivedocument	userid	int8	19
jivedocument	versionid	int4	10
jivedocument	workflowid	int8	19	√		null
jivedocumentaudit	alterdate	int8	19
jivedocumentaudit	altertype	int8	19
jivedocumentaudit	fieldid	int8	19	√		null
jivedocumentaudit	internaldocid	int8	19
jivedocumentaudit	oldvalue	text	2147483647	√		null
jivedocumentaudit	userid	int8	19	√		null
jivedocumentaudit	versionid	int4	10
jivedocumentbody	bodyid	int8	19
jivedocumentbody	bodytext	text	2147483647	√		null
jivedocumentbody	contenttype	varchar	100	√		null
jivedocumentbody	creationdate	int8	19
jivedocumentbody	filename	varchar	255	√		null
jivedocumentbody	filesize	int8	19	√		null
jivedocumentprop	internaldocid	int8	19
jivedocumentprop	name	varchar	100
jivedocumentprop	propvalue	varchar	3500
jivedocumentprop	versionid	int2	5
jivedocversion	creationdate	int8	19
jivedocversion	exstoragefileversionid	int8	19	√		null
jivedocversion	internaldocid	int8	19
jivedocversion	language	bpchar	2
jivedocversion	minorversion	int2	5
jivedocversion	modificationdate	int8	19
jivedocversion	recordid	int8	19
jivedocversion	state	varchar	20
jivedocversion	status	int4	10
jivedocversion	summary	text	2147483647	√		null
jivedocversion	title	varchar	255
jivedocversion	userid	int8	19
jivedocversion	versionid	int4	10
jivedocversioncmmt	comments	text	2147483647
jivedocversioncmmt	creationdate	int8	19
jivedocversioncmmt	internaldocid	int8	19
jivedocversioncmmt	userid	int8	19
jivedocversioncmmt	vcommentid	int8	19
jivedocversioncmmt	versionid	int4	10
jivedraft	body	text	2147483647	√		null
jivedraft	draftid	int8	19
jivedraft	drafttype	int4	10
jivedraft	modificationdate	int8	19
jivedraft	objectid	int8	19
jivedraft	objecttype	int4	10	√		null
jivedraft	subject	varchar	255	√		null
jivedraft	userid	int8	19	√		null
jivedraftimage	draftid	int8	19
jivedraftimage	imageid	int8	19
jivedraftprop	draftid	int8	19
jivedraftprop	name	varchar	100
jivedraftprop	propvalue	varchar	3500
jivedvrevartifact	artifacttype	varchar	20
jivedvrevartifact	contenttype	varchar	100	√		null
jivedvrevartifact	creationdate	int8	19
jivedvrevartifact	exstorageid	int8	19	√		null
jivedvrevartifact	filename	varchar	255	√		null
jivedvrevartifact	filesize	int4	10
jivedvrevartifact	htmlcomponentname	varchar	255	√		''::character varying
jivedvrevartifact	htmlsubtype	varchar	255	√		''::character varying
jivedvrevartifact	instanceid	varchar	255
jivedvrevartifact	modificationdate	int8	19
jivedvrevartifact	page	int4	10
jivedvrevartifact	revisionid	int8	19
jivedvrevartifact	storagekeyversion	int4	10			1
jivedvrevision	creationdate	int8	19
jivedvrevision	documentclassid	int4	10
jivedvrevision	documentid	int8	19
jivedvrevision	filename	varchar	255
jivedvrevision	filesize	int8	19
jivedvrevision	modificationdate	int8	19
jivedvrevision	pagecount	int4	10			0
jivedvrevision	revisionid	int8	19
jivedvrevision	revisionnumber	int4	10
jivedvrevstatus	message	varchar	3500	√		null
jivedvrevstatus	modificationdate	int8	19
jivedvrevstatus	revisionid	int8	19
jivedvrevstatus	step	int4	10			0
jiveeaeuserprop	name	varchar	100
jiveeaeuserprop	propvalue	varchar	3500
jiveeaeuserprop	userid	int8	19
jiveemailtoken	tokendate	int8	19
jiveemailtoken	tokenvalue	int4	10
jiveemailtoken	userid	int8	19
jiveentitlement	contenttype	int4	10
jiveentitlement	creationdate	int8	19	√		null
jiveentitlement	entitlementid	int8	19
jiveentitlement	entitlementmask	int4	10
jiveentitlement	groupid	int8	19	√		null
jiveentitlement	modificationdate	int8	19	√		null
jiveentitlement	objectid	int8	19
jiveentitlement	objecttype	int4	10
jiveentitlement	userid	int8	19	√		null
jiveentitlementmsk	mask	int4	10
jiveentitlementmsk	name	varchar	25
jiveentlmntinherit	containerid	int8	19
jiveentlmntinherit	containertype	int4	10
jiveeptagjoin	creationdate	int8	19
jiveeptagjoin	endpointid	int8	19
jiveeptagjoin	tagid	int8	19
jiveerror	code	int8	19
jiveerror	creationdate	int8	19
jiveerror	errorid	int8	19
jiveerror	message	varchar	1024	√		null
jiveerror	modificationdate	int8	19
jiveerror	source	varchar	1024	√		null
jiveerror	sourcetype	int8	19
jiveerror	srcobjid	int8	19	√		null
jiveerror	srcobjtype	int8	19	√		null
jiveerror	status	int8	19	√		null
jiveerror	subjobjid	int8	19	√		null
jiveerror	subjobjtype	int8	19	√		null
jiveevent	city	text	2147483647	√		null
jiveevent	containerid	int8	19
jiveevent	containertype	int4	10
jiveevent	country	text	2147483647	√		null
jiveevent	creationdate	int8	19
jiveevent	description	text	2147483647	√		null
jiveevent	editpolicy	int4	10			3
jiveevent	email	varchar	200	√		null
jiveevent	endtime	int8	19
jiveevent	eventaccess	int4	10
jiveevent	eventid	int8	19
jiveevent	eventtype	int4	10
jiveevent	host	text	2147483647	√		null
jiveevent	icsuid	varchar	200
jiveevent	locale	varchar	30	√		null
jiveevent	location	text	2147483647	√		null
jiveevent	maxattendees	int4	10	√		null
jiveevent	modificationdate	int8	19
jiveevent	name	text	2147483647
jiveevent	phone	varchar	200	√		null
jiveevent	starttime	int8	19
jiveevent	status	int4	10
jiveevent	street	text	2147483647	√		null
jiveevent	tagline	text	2147483647	√		null
jiveevent	url	varchar	200	√		null
jiveevent	userid	int8	19
jiveeventattendee	attendeeid	int8	19
jiveeventattendee	creationdate	int8	19
jiveeventattendee	eventid	int8	19
jiveeventattendee	modificationdate	int8	19
jiveeventattendee	status	int4	10
jiveeventattendee	userid	int8	19
jiveexpertisetag	approved	int2	5			0
jiveexpertisetag	creationdate	int8	19
jiveexpertisetag	expertisetagid	int8	19
jiveexpertisetag	originuserid	int8	19
jiveexpertisetag	tagid	int8	19
jiveexpertisetag	targetuserid	int8	19
jiveexportrequest	creationdate	int8	19
jiveexportrequest	error	varchar	4000	√		null
jiveexportrequest	filelength	int4	10
jiveexportrequest	modificationdate	int8	19
jiveexportrequest	processedcount	int4	10
jiveexportrequest	requestenddate	int8	19
jiveexportrequest	requestid	int8	19
jiveexportrequest	requestuserid	int8	19
jiveexportrequest	searchquery	varchar	4000	√		null
jiveexportrequest	status	int4	10
jiveexportrequest	targetenddate	int8	19
jiveexportrequest	targetstartdate	int8	19
jiveexportrequest	targetuserid	int8	19
jiveextcomments	commentid	int8	19
jiveextcomments	creationdate	int8	19
jiveextcomments	extcommentid	int8	19
jiveextcomments	externalid	varchar	255
jiveextcomments	modificationdate	int8	19
jiveextcomments	tileinstanceid	int8	19
jiveextcomments	tilestreamentryid	int8	19
jiveextcontext	contextid	int8	19
jiveextcontext	name	varchar	100
jiveextcontext	type	int2	5
jiveextension	allowupdates	int2	5			0
jiveextension	authordata	varchar	2048
jiveextension	creationdate	int8	19
jiveextension	definition	text	2147483647	√		null
jiveextension	deploydate	int8	19	√		null
jiveextension	deployerid	int8	19	√		null
jiveextension	description	varchar	255
jiveextension	extensionid	int8	19
jiveextension	extensionuuid	varchar	128
jiveextension	metadata	text	2147483647	√		null
jiveextension	modificationdate	int8	19
jiveextension	name	varchar	255
jiveextension	pluginsourcesha1	varchar	48	√		null
jiveextension	publicresourcehash	varchar	64	√		'null'::character varying
jiveextension	publishedclientid	varchar	127	√		null
jiveextension	publishedclientsecret	varchar	127	√		null
jiveextension	publisheduuid	varchar	128	√		null
jiveextension	publishedversionid	int8	19	√		null
jiveextension	removable	int2	5			1
jiveextension	serviceurl	varchar	1024
jiveextension	status	varchar	25			''::character varying
jiveextension	targetconfig	varchar	4000	√		null
jiveextension	tenancyuri	varchar	256	√		null
jiveextension	type	varchar	25
jiveextension	visibletoexternalcontributors	int2	5			0
jiveextension	visibletouserid	int8	19	√		null
jiveextensionalert	alerttype	varchar	64
jiveextensionalert	contextdata	text	2147483647	√		null
jiveextensionalert	creationdate	int8	19
jiveextensionalert	extensionalertid	int8	19
jiveextensionalert	extensionid	int8	19
jiveextensionalert	message	varchar	256	√		null
jiveextensionalert	modificationdate	int8	19
jiveextensionalert	severity	varchar	25			'INFO'::character varying
jiveextensionalert	timestamp	int8	19
jiveextensioncert	certificate	text	2147483647
jiveextensioncert	chainorder	int4	10
jiveextensioncert	extensionid	int8	19
jiveextensiongroup	extensionid	int8	19
jiveextensiongroup	groupid	int8	19
jiveextensioni18n	bundle	text	2147483647	√		null
jiveextensioni18n	extensionid	int8	19
jiveextensioni18n	lastmodified	int8	19
jiveextensioni18n	locale	varchar	10
jiveextensiontag	extensionid	int8	19
jiveextensiontag	value	varchar	25
jiveexternalidentity	externalidentityid	int8	19
jiveexternalidentity	identityvalue	varchar	3500
jiveexternalidentity	identityvaluemd5	varchar	48
jiveexternalidentity	identityvaluemd5lowercase	varchar	48
jiveexternalidentity	type	int4	10
jiveexternalidentity	userid	int8	19
jiveexternallogin	name	varchar	255
jiveexternallogin	ordering	int4	10
jiveexternallogin	type	int4	10
jiveexternallogin	url	varchar	255	√		null
jiveexternalurl	creationdate	int8	19
jiveexternalurl	host	varchar	3500
jiveexternalurl	id	int8	19
jiveexternalurl	mimetype	varchar	100	√		null
jiveexternalurl	modificationdate	int8	19
jiveexternalurl	path	varchar	3500	√		null
jiveexternalurl	port	int4	10	√		null
jiveexternalurl	protocol	varchar	10
jiveexternalurl	query	varchar	3500	√		null
jiveexternalurl	ref	varchar	3500	√		null
jiveexternalurl	status	int4	10
jiveexternalurl	title	varchar	1000	√		null
jiveextinvite	containerid	int4	10
jiveextinvite	containertype	int8	19
jiveextinvite	contentid	int4	10
jiveextinvite	contenttype	int8	19
jiveextinvite	creationdate	int8	19
jiveextinvite	extinviteid	int8	19
jiveextinvite	inviteduserid	int8	19
jiveextinvite	inviteruserid	int8	19
jiveextinvite	modificationdate	int8	19
jiveextprops	associatedid	int8	19
jiveextprops	associatedtype	int4	10
jiveextprops	clientid	varchar	1024	√		null
jiveextprops	clientidmd5	varchar	48	√		null
jiveextprops	creationdate	int8	19
jiveextprops	extpropsid	int8	19
jiveextprops	extpropskey	varchar	4000	√		null
jiveextprops	extpropskeymd5	varchar	48	√		null
jiveextprops	extpropsvalue	varchar	4000	√		null
jiveextprops	extpropsvaluemd5	varchar	48	√		null
jiveextprops	modificationdate	int8	19
jivefeatured	containerid	int8	19
jivefeatured	containertype	int4	10
jivefeatured	creationdate	int8	19
jivefeatured	objectid	int8	19
jivefeatured	objecttype	int4	10
jivefield	alterable	int2	5
jivefield	defvalue	varchar	255	√		null
jivefield	description	varchar	1000	√		null
jivefield	displayname	varchar	100
jivefield	fieldid	int8	19
jivefield	fieldtypeid	int8	19
jivefield	filterable	int2	5
jivefield	frowversion	int8	19	√		null
jivefield	maxsize	int4	10
jivefield	name	varchar	100
jivefield	required	int2	5
jivefield	searchable	int2	5
jivefield	visible	int2	5
jivefieldfrmtprop	fieldtypeid	int8	19
jivefieldfrmtprop	name	varchar	100
jivefieldfrmtprop	propvalue	varchar	3500
jivefieldoption	defaultoption	int4	10
jivefieldoption	fieldid	int8	19
jivefieldoption	optionid	int8	19
jivefieldoption	optionindex	int4	10
jivefieldoption	optionvalue	varchar	255
jivefieldtype	datatypeid	int8	19
jivefieldtype	description	varchar	1000	√		null
jivefieldtype	displayname	varchar	100
jivefieldtype	fieldtypeid	int8	19
jivefieldtype	formatter	varchar	255	√		null
jivefieldtype	modifiable	int4	10
jivefieldtype	name	varchar	20
jivefieldtype	validator	varchar	255	√		null
jivefieldvalue	fieldid	int8	19
jivefieldvalue	internaldocid	int8	19
jivefieldvalue	numvalue	int8	19	√		null
jivefieldvalue	strvalue	varchar	3500	√		null
jivefieldvalue	versionid	int4	10
jivefieldvldtrprop	fieldtypeid	int8	19
jivefieldvldtrprop	name	varchar	100
jivefieldvldtrprop	propvalue	varchar	3500
jivefollow	containerid	int8	19
jivefollow	containertype	int4	10
jivefollow	creationdate	int8	19
jivefollow	userid	int8	19
jiveformattedtext	containerid	int8	19
jiveformattedtext	containertype	int4	10
jiveformattedtext	creationdate	int8	19
jiveformattedtext	instanceid	int8	19
jiveformtoken	creationdate	int8	19
jiveformtoken	tokenkey	varchar	255
jiveformtoken	tokenvalue	varchar	3500
jivegrantedpermlvl	grantedid	int8	19
jivegrantedpermlvl	grantedobjecttype	int4	10
jivegrantedpermlvl	permlevelid	int8	19
jivegrantedpermlvl	targetobjectid	int8	19
jivegrantedpermlvl	targetobjecttype	int4	10
jivegroup	creationdate	int8	19
jivegroup	description	varchar	1000	√		null
jivegroup	federated	int2	5	√		null
jivegroup	groupid	int8	19
jivegroup	modificationdate	int8	19
jivegroup	name	varchar	255
jivegroup	visible	int2	5	√		null
jivegroupperm	groupid	int8	19
jivegroupperm	objectid	int8	19
jivegroupperm	objecttype	int4	10
jivegroupperm	permission	int4	10
jivegroupperm	permissiontype	int4	10
jivegroupprop	groupid	int8	19
jivegroupprop	name	varchar	100
jivegroupprop	propvalue	varchar	3500
jivegroupuser	administrator	int4	10
jivegroupuser	groupid	int8	19
jivegroupuser	userid	int8	19
jivegroupuserhist	administrator	int4	10
jivegroupuserhist	creationdate	int8	19
jivegroupuserhist	groupid	int8	19
jivegroupuserhist	groupuserid	int8	19
jivegroupuserhist	modificationdate	int8	19
jivegroupuserhist	retireddate	int8	19	√		null
jivegroupuserhist	userid	int8	19
jivei18ntext	aliaskey	varchar	2000	√		null
jivei18ntext	creationdate	int8	19
jivei18ntext	custom	int2	5
jivei18ntext	defaulttext	varchar	2000	√		null
jivei18ntext	locale	varchar	100
jivei18ntext	modificationdate	int8	19
jivei18ntext	objectattribute	int4	10
jivei18ntext	objectid	int8	19
jivei18ntext	objecttype	int4	10
jivei18ntext	text	varchar	2000
jivei18ntext	textid	int8	19
jiveid	id	int8	19
jiveid	idtype	int4	10
jiveidea	authorid	int8	19	√		null
jiveidea	containerid	int8	19
jiveidea	containertype	int4	10
jiveidea	creationdate	int8	19
jiveidea	editpolicy	int4	10			2
jiveidea	ideabody	text	2147483647
jiveidea	ideaid	int8	19
jiveidea	ideastate	varchar	255	√		null
jiveidea	ideasubject	varchar	255
jiveidea	modificationdate	int8	19
jiveidea	score	int8	19			0
jiveidea	stageid	int8	19
jiveidea	status	int4	10
jiveidea	userid	int8	19
jiveideacollab	ideaid	int8	19
jiveideacollab	userid	int8	19
jiveideaextfield	fieldid	int8	19
jiveideaextfield	fieldindex	int8	19
jiveideaextfield	fieldtype	int8	19
jiveideaextfield	list	int4	10
jiveideaextfield	name	varchar	255
jiveideaextfield	required	int4	10
jiveideaextfieldvalue	fieldid	int8	19
jiveideaextfieldvalue	fieldvalue	varchar	3500	√		null
jiveideaextfieldvalue	ideaid	int8	19
jiveideaextfldopt	defaultoption	int4	10
jiveideaextfldopt	fieldid	int8	19
jiveideaextfldopt	optindex	int8	19
jiveideaextfldopt	optionvalue	varchar	255
jiveideaprop	id	int8	19
jiveideaprop	ideapropname	varchar	255
jiveideaprop	ideapropvalue	text	2147483647
jiveideastage	stagebackgroundcolor	text	2147483647
jiveideastage	stagedefault	int4	10
jiveideastage	stageenabled	int4	10			1
jiveideastage	stageforegroundcolor	text	2147483647
jiveideastage	stageid	int8	19
jiveideastage	stagename	varchar	255
jiveideastage	votingenabled	int4	10			0
jiveideatou	ideatoustatus	int4	10
jiveideatou	ideatoutext	text	2147483647
jiveideatou	userid	int8	19
jiveideavote	creationdate	int8	19
jiveideavote	ideaid	int8	19
jiveideavote	modificationdate	int8	19	√		null
jiveideavote	userid	int8	19
jiveideavote	votetype	int4	10
jiveidentitytable	dummy	bpchar	1
jiveidmembership	creationdate	int8	19
jiveidmembership	slug	varchar	50
jiveidmembership	userid	int8	19
jiveimage	active	int2	5			1
jiveimage	contenttype	varchar	50
jiveimage	creationdate	int8	19
jiveimage	filename	varchar	255
jiveimage	filesize	int4	10
jiveimage	imageid	int8	19
jiveimage	modificationdate	int8	19
jiveimage	objectid	int8	19	√		null
jiveimage	objecttype	int4	10
jiveimage	userid	int8	19			'-1'::integer
jiveimageversion	imageid	int8	19
jiveimageversion	internaldocid	int8	19
jiveimageversion	versionid	int4	10
jiveimusersexternalid	datesynced	int8	19
jiveimusersexternalid	externalid	varchar	250
jiveimusersexternalid	userid	int8	19
jiveimuserspresence	lastcheckdate	int8	19	√		null
jiveimuserspresence	status	int8	19	√		null
jiveimuserspresence	statusmessage	varchar	100	√		null
jiveimuserspresence	subscriptiondate	int8	19	√		null
jiveimuserspresence	userid	varchar	250
jiveinboxcategory	categoryid	int8	19
jiveinboxcategory	creationdate	int8	19
jiveinboxcategory	description	varchar	1000
jiveinboxcategory	iconclass	varchar	64
jiveinboxcategory	modificationdate	int8	19
jiveinboxcategory	name	varchar	255
jiveinboxentry	categoryid	int8	19			'-1'::integer
jiveinboxentry	creationdate	int8	19
jiveinboxentry	entryid	int8	19
jiveinboxentry	entrytype	int4	10
jiveinboxentry	inboxtype	int2	5
jiveinboxentry	modificationdate	int8	19	√		null
jiveinboxentry	requestmessage	varchar	255	√		null
jiveinboxentry	responsemessage	varchar	255	√		null
jiveinboxentry	state	int2	5
jiveinboxentry	targetobjectid	int8	19
jiveinboxentry	targetobjecttype	int4	10
jiveinboxentry	userid	int8	19
jiveinboxentryprop	entryid	int8	19
jiveinboxentryprop	name	varchar	100
jiveinboxentryprop	propvalue	varchar	3500
jiveinstanceapp	appid	int8	19
jiveinstanceapp	appinstanceuuid	varchar	128
jiveinstanceapp	appurl	varchar	1024
jiveinstanceapp	appurlmd5	varchar	127
jiveinstanceapp	creationdate	int8	19
jiveinstanceapp	instanceappid	int8	19
jiveinstanceapp	locallymanaged	int2	5			1
jiveinstanceapp	modificationdate	int8	19
jiveinstanceapp	userid	int8	19
jiveinstapppref	instanceappid	int8	19
jiveinstapppref	name	varchar	128
jiveinstapppref	propvalue	text	2147483647
jiveinvite	creationdate	int8	19
jiveinvite	email	varchar	254	√		null
jiveinvite	invitationid	int8	19
jiveinvite	inviterid	int8	19	√		null
jiveinvite	modificationdate	int8	19
jiveinvite	objectid	int8	19
jiveinvite	objecttype	int4	10
jiveinvite	revokedate	int8	19	√		null
jiveinvite	revokerid	int8	19	√		null
jiveinvite	sentdate	int8	19	√		null
jiveinvite	state	int4	10
jiveinvite	userid	int8	19	√		null
jiveinviteprop	invitationid	int8	19
jiveinviteprop	name	varchar	100
jiveinviteprop	propvalue	varchar	3500
jivelabel	labelid	int8	19
jivelabel	name	varchar	200
jivelabel	ownerid	int8	19
jivelabel	style	varchar	200	√		null
jivelabelelement	documenttypeid	int8	19
jivelabelelement	elementid	int8	19
jivelabelelement	value	varchar	255	√		null
jivelabelmap	labelid	int8	19
jivelabelmap	objectid	int8	19
jivelabelmap	objecttype	int4	10
jivelabeltype	labelid	int8	19
jivelabeltype	objecttype	int4	10
jivelinkobject	linkkey	varchar	255
jivelinkobject	objectid	int8	19
jivelinkobject	objecttype	int4	10
jivelocalizedprop	locale	varchar	100
jivelocalizedprop	name	varchar	100
jivelocalizedprop	propvalue	text	2147483647
jivelock	lockname	varchar	255
jivelock	timestamp	int8	19
jivelockproperty	lockname	varchar	255
jivelockproperty	name	varchar	255
jivelockproperty	value	varchar	255
jivemarketoutmsg	code	int8	19
jivemarketoutmsg	creationdate	int8	19
jivemarketoutmsg	id	int8	19
jivemarketoutmsg	message	varchar	3500	√		null
jivemessage	body	text	2147483647	√		null
jivemessage	containerid	int8	19
jivemessage	containertype	int4	10
jivemessage	creationdate	int8	19
jivemessage	messageid	int8	19
jivemessage	modificationdate	int8	19
jivemessage	parentmessageid	int8	19	√		null
jivemessage	rewardpoints	int4	10
jivemessage	status	int4	10
jivemessage	subject	varchar	255	√		null
jivemessage	threadid	int8	19
jivemessage	userid	int8	19	√		null
jivemessageprop	messageid	int8	19
jivemessageprop	name	varchar	100
jivemessageprop	propvalue	varchar	3500
jivemessagequeue	description	varchar	255	√		null
jivemessagequeue	details	bytea	2147483647
jivemessagequeue	msgid	int8	19
jivemessagequeue	originator	varchar	255
jivemessagequeue	sendtime	int8	19
jivemetering	component	varchar	255
jivemetering	encrypteddate	varchar	64
jivemetering	encryptedusageamt	varchar	255
jivemetering	isadjustment	int2	5
jivemetering	lastupdatets	int8	19	√		null
jivemetering	plaindate	int8	19
jivemetering	resourcetype	varchar	255
jivemobilepushcertificate	credentials	bytea	2147483647
jivemobilepushcertificate	service	varchar	10
jivemobilepushregistration	deviceapilevel	int4	10			1
jivemobilepushregistration	devicefeatureflags	int4	10			1
jivemobilepushregistration	devicetoken	varchar	4000
jivemobilepushregistration	devicetype	int4	10
jivemobilepushregistration	id	int8	19
jivemobilepushregistration	pushpreference	varchar	20	√		null
jivemobilepushregistration	supportedtypes	varchar	1024
jivemobilepushregistration	userid	int8	19
jivemovedobjects	destinationcontainerid	int8	19
jivemovedobjects	destinationcontainertype	int4	10
jivemovedobjects	id	int8	19
jivemovedobjects	moveddate	int8	19
jivemovedobjects	objectid	int8	19
jivemovedobjects	objecttype	int4	10
jivemovedobjects	sourcecontainerid	int8	19
jivemovedobjects	sourcecontainertype	int4	10
jiveoauth2client	accesstokenexpiration	int8	19	√		null
jiveoauth2client	allowautoextend	int2	5			0
jiveoauth2client	allowsessiongrant	int2	5			0
jiveoauth2client	clientid	varchar	128
jiveoauth2client	clientsecret	varchar	255
jiveoauth2client	creationdate	int8	19
jiveoauth2client	extensionid	int8	19
jiveoauth2client	modificationdate	int8	19
jiveoauth2client	oauthclientid	int8	19
jiveoauth2client	redirecturi	varchar	2000
jiveoauth2client	refreshtokenexpiration	int8	19	√		null
jiveoauth2client	userid	int8	19
jiveoauth2code	agent	varchar	100	√		null
jiveoauth2code	creationdate	int8	19
jiveoauth2code	expirationdate	int8	19
jiveoauth2code	modificationdate	int8	19
jiveoauth2code	oauthclientid	int8	19
jiveoauth2code	oauthcodeid	int8	19
jiveoauth2code	redirecturi	varchar	2000	√		null
jiveoauth2code	relatedid	int8	19	√		null
jiveoauth2code	scope	varchar	1000	√		null
jiveoauth2code	userid	int8	19
jiveoauth2code	value	varchar	128
jiveoauth2code	valuetype	int2	5
jiveoauthaccesslog	lastaccess	int8	19	√		null
jiveoauthaccesslog	oauthtokenid	int8	19
jiveoauthpairing	activationdate	int8	19	√		null
jiveoauthpairing	creationdate	int8	19
jiveoauthpairing	displayname	varchar	255
jiveoauthpairing	expirationdate	int8	19	√		null
jiveoauthpairing	modificationdate	int8	19
jiveoauthpairing	oauthpairingid	int8	19
jiveoauthpairing	onetimecode	varchar	24	√		null
jiveoauthpairing	pairingsubtypeid	varchar	48
jiveoauthpairing	providernamehash	int4	10
jiveoauthpairing	temppasscodeencoded	varchar	255	√		null
jiveoauthpairing	userid	int8	19
jiveoauthpasscode	oauthtokenid	int8	19
jiveoauthpasscode	passcodeencoded	varchar	128
jiveoauthpasscode	passcodeexpiration	int8	19	√		null
jiveoauthpasscode	passcodefailedattempts	int4	10			0
jiveoauthstore	contextid	int8	19	√		null
jiveoauthstore	creationdate	int8	19
jiveoauthstore	expiration	int8	19	√		null
jiveoauthstore	instanceappid	int8	19
jiveoauthstore	servicename	varchar	64
jiveoauthstore	tokenname	varchar	64
jiveoauthstore	tokensecret	varchar	1024
jiveoauthstore	tokenvalue	varchar	1024
jiveoauthstore	userid	int8	19
jiveoauthstore	version	int2	5
jiveoauthtoken	accesstoken	varchar	127	√		null
jiveoauthtoken	accesstokenexp	int8	19	√		null
jiveoauthtoken	apiaccessorid	int8	19
jiveoauthtoken	clientid	varchar	64
jiveoauthtoken	clientsecret	varchar	127	√		null
jiveoauthtoken	creationdate	int8	19
jiveoauthtoken	expirationdate	int8	19	√		null
jiveoauthtoken	modificationdate	int8	19
jiveoauthtoken	oauthtokenid	int8	19
jiveoauthtoken	refreshtoken	varchar	127	√		null
jiveoauthtoken	sessionid	varchar	64	√		null
jiveoauthtoken	userid	int8	19
jiveobjapiaccessor	accessorid	int8	19
jiveobjapiaccessor	objectid	int8	19
jiveobjapiaccessor	objecttype	int4	10
jiveobjecttag	childobjectid	int8	19			'-1'::integer
jiveobjecttag	childobjecttype	int4	10			'-1'::integer
jiveobjecttag	creationdate	int8	19
jiveobjecttag	objectid	int8	19
jiveobjecttag	objecttype	int4	10
jiveobjecttag	tagid	int8	19
jiveobjecttag	type	int4	10
jiveobjecttagset	objectid	int8	19
jiveobjecttagset	objecttype	int4	10
jiveobjecttagset	tagsetid	int8	19
jiveobjecttype	code	varchar	255
jiveobjecttype	typeid	int4	10
jiveobjpermlvl	description	varchar	255	√		null
jiveobjpermlvl	lvltype	varchar	25	√		null
jiveobjpermlvl	name	varchar	25
jiveobjpermlvl	objpermlevelid	int8	19
jiveobjpermlvl	objtype	int8	19	√		null
jiveobjpermlvlext	creationdate	int8	19			0
jiveobjpermlvlext	extender	int8	19			0
jiveobjpermlvlext	objpermlevelid	int8	19
jiveobjpermlvlmap	creationdate	int8	19			0
jiveobjpermlvlmap	extender	int8	19			0
jiveobjpermlvlmap	objpermlevelid	int8	19
jiveobjpermlvlmap	permlevelid	int8	19
jiveobjpermlvlmsk	creationdate	int8	19			0
jiveobjpermlvlmsk	extender	int8	19			0
jiveobjpermlvlmsk	mask	int4	10
jiveobjpermlvlmsk	objpermlevelid	int8	19
jiveobjtypemsk	creationdate	int8	19			0
jiveobjtypemsk	extender	int8	19			0
jiveobjtypemsk	mask	int4	10
jiveobjtypemsk	objtype	int8	19
jiveocservicestats	appuuid	varchar	127
jiveocservicestats	delta	int8	19
jiveocservicestats	httpmethod	varchar	10
jiveocservicestats	servicename	varchar	255
jiveocservicestats	trackeddate	int8	19
jiveofficecoauthors	documentid	int8	19
jiveofficecoauthors	editstartdate	int8	19
jiveofficecoauthors	lastupdatedate	int8	19	√		null
jiveofficecoauthors	ttl	int8	19	√		null
jiveofficecoauthors	userid	int8	19
jiveosappdata	appdataid	int8	19
jiveosappdata	fieldname	varchar	255
jiveosappdata	fieldsize	int4	10	√		null
jiveosappdata	fieldtype	varchar	255	√		null
jiveosappdata	fieldvalue	text	2147483647	√		null
jiveosappdata	gadgetid	varchar	255
jiveosappdata	userid	int8	19
jiveosfileitem	appid	varchar	255
jiveosfileitem	creationdate	int8	19
jiveosfileitem	fileitemid	int8	19
jiveosfileitem	filesize	int8	19
jiveosfileitem	mimetype	varchar	255
jiveosfileitem	modificationdate	int8	19
jiveosfileitem	name	varchar	255
jiveosfileitem	userid	int8	19
jiveospropentry	datavalue	bytea	2147483647	√		null
jiveospropentry	datevalue	int8	19	√		null
jiveospropentry	floatvalue	float8	17,17	√		null
jiveospropentry	globalkey	varchar	150	√		null
jiveospropentry	itemkey	varchar	150	√		null
jiveospropentry	itemtype	int4	10	√		null
jiveospropentry	numbervalue	int8	19	√		null
jiveospropentry	stringvalue	varchar	255	√		null
jiveoutcome	childobjectid	int8	19			'-1'::integer
jiveoutcome	childobjecttype	int4	10			'-1'::integer
jiveoutcome	containerid	int8	19
jiveoutcome	containertype	int4	10
jiveoutcome	creationdate	int8	19
jiveoutcome	modificationdate	int8	19
jiveoutcome	note	text	2147483647			''::text
jiveoutcome	outcomeid	int8	19
jiveoutcome	outcometypeid	int4	10
jiveoutcome	parentobjectid	int8	19
jiveoutcome	parentobjecttype	int4	10
jiveoutcome	predecessoroutcomeid	int8	19			'-1'::integer
jiveoutcome	status	int4	10			1
jiveoutcome	userid	int8	19
jiveoutcomeprop	name	varchar	100
jiveoutcomeprop	outcomeid	int8	19
jiveoutcomeprop	propvalue	varchar	3500
jivepageviewconfig	component	varchar	255
jivepageviewconfig	configxml	text	2147483647	√		null
jivepageviewconfig	lastupdatets	int8	19
jivepalette	modificationdate	int8	19
jivepalette	name	varchar	100
jivepalette	paletteid	int8	19
jivepaletteimage	filename	varchar	100
jivepaletteimage	imageid	int8	19
jivepaletteimage	modificationdate	int8	19
jivepaletteimage	paletteid	int8	19
jivepaletteprop	image	int2	5
jivepaletteprop	modificationdate	int8	19
jivepaletteprop	paletteid	int8	19
jivepaletteprop	propkey	varchar	100
jivepaletteprop	propvalue	text	2147483647
jivepcheckpoint	checkpointid	int8	19
jivepcheckpoint	creationdate	int8	19
jivepcheckpoint	description	varchar	1000	√		null
jivepcheckpoint	duedate	int8	19
jivepcheckpoint	modificationdate	int8	19
jivepcheckpoint	name	varchar	255
jivepcheckpoint	projectid	int8	19
jivepermlevel	name	varchar	25	√		null
jivepermlevel	permlevelid	int8	19
jivepermlevel	system	int2	5			0
jivepermlvlmsk	mask	int4	10
jivepermlvlmsk	objtype	int8	19	√		null
jivepermlvlmsk	permlevelid	int8	19
jivepermmask	mask	int4	10
jivepermmask	name	varchar	255
jivephoto	creationdate	int8	19
jivephoto	description	text	2147483647	√		null
jivephoto	modificationdate	int8	19
jivephoto	photoalbumid	int8	19
jivephoto	photoid	int8	19
jivephoto	status	int4	10
jivephoto	subject	varchar	512	√		null
jivephoto	userid	int8	19
jivephotoalbum	authorshippolicy	int4	10
jivephotoalbum	containerid	int8	19
jivephotoalbum	containertype	int4	10
jivephotoalbum	coverphotoid	int8	19	√		null
jivephotoalbum	creationdate	int8	19
jivephotoalbum	description	text	2147483647	√		null
jivephotoalbum	displayname	varchar	255	√		null
jivephotoalbum	modificationdate	int8	19
jivephotoalbum	name	varchar	255
jivephotoalbum	photoalbumid	int8	19
jivephotoalbum	status	int4	10
jivephotoalbum	userid	int8	19
jivephotoalbum	visibility	int4	10
jivephotoalbumprop	name	varchar	100
jivephotoalbumprop	photoalbumid	int8	19
jivephotoalbumprop	propvalue	varchar	3500
jivephotoprop	name	varchar	100
jivephotoprop	photoid	int8	19
jivephotoprop	propvalue	varchar	3500
jiveplaceheaderbanner	bannerid	int8	19
jiveplaceheaderbanner	bgcolor	varchar	10	√		null
jiveplaceheaderbanner	bgposition	varchar	128	√		null
jiveplaceheaderbanner	bgrepeat	varchar	128	√		null
jiveplaceheaderbanner	location	varchar	1024	√		null
jiveplaceheaderbanner	sortorder	int8	19
jiveplaceheaderbanner	textcolor	varchar	10	√		null
jiveplaceheaderbanner	thumbnaillocation	varchar	1024	√		null
jiveplacetopic	creationdate	int8	19
jiveplacetopic	hidden	int2	5
jiveplacetopic	modificationdate	int8	19
jiveplacetopic	name	varchar	100
jiveplacetopic	placetopicid	int8	19
jiveplacetopic_place	containerid	int8	19
jiveplacetopic_place	containertype	int8	19
jiveplacetopic_place	placetopicid	int8	19
jiveplugin	creationdate	int8	19
jiveplugin	data	bytea	2147483647	√		null
jiveplugin	enabled	int4	10			1
jiveplugin	modificationdate	int8	19
jiveplugin	name	varchar	100
jiveplugin	pluginid	int8	19
jivepluginprop	pluginname	varchar	100
jivepluginprop	propname	varchar	100
jivepluginprop	propvalue	varchar	3500
jivepoll	creationdate	int8	19
jivepoll	description	text	2147483647	√		null
jivepoll	enddate	int8	19
jivepoll	expiredate	int8	19
jivepoll	modificationdate	int8	19
jivepoll	name	varchar	255
jivepoll	objectid	int8	19
jivepoll	objecttype	int4	10
jivepoll	pollid	int8	19
jivepoll	pollmode	int8	19
jivepoll	startdate	int8	19
jivepoll	status	int4	10
jivepoll	userid	int8	19	√		null
jivepolloption	optionid	int8	19
jivepolloption	optionindex	int4	10
jivepolloption	optiontext	varchar	3500
jivepolloption	pollid	int8	19
jivepollvote	guestid	varchar	255	√		null
jivepollvote	optionid	int8	19
jivepollvote	userid	int8	19	√		null
jivepollvote	votedate	int8	19
jivepopularity	containerid	int8	19
jivepopularity	containertype	int4	10
jivepopularity	creationdate	int8	19
jivepopularity	objectid	int8	19
jivepopularity	objecttype	int4	10
jivepopularity	popularityid	int8	19
jivepopularity	score	int4	10
jivepresenter	modificationdate	int8	19
jivepresenter	name	varchar	100
jivepresenter	presenterid	int8	19
jivepresenter	template	text	2147483647	√		null
jiveprivateprops	associatedid	int8	19
jiveprivateprops	associatedtype	int4	10
jiveprivateprops	clientid	varchar	1024	√		null
jiveprivateprops	clientidmd5	varchar	48	√		null
jiveprivateprops	creationdate	int8	19
jiveprivateprops	modificationdate	int8	19
jiveprivateprops	privatepropsid	int8	19
jiveprivateprops	privatepropskey	varchar	4000	√		null
jiveprivateprops	privatepropskeymd5	varchar	48	√		null
jiveprivateprops	privatepropsvalue	varchar	4000	√		null
jiveprivateprops	privatepropsvaluemd5	varchar	48	√		null
jiveprivateprops	userid	int8	19
jiveprofilefield	defaultseclvlid	int8	19			1001
jiveprofilefield	extmanaged	int2	5
jiveprofilefield	extmapping	varchar	2048	√		null
jiveprofilefield	fieldid	int8	19
jiveprofilefield	fieldtype	int4	10
jiveprofilefield	idx	int4	10
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	isshowsummarylabel	int2	5			1
jiveprofilefield	isvisibletoguests	int2	5
jiveprofilefield	isvisibletousers	int2	5
jiveprofilefield	name	varchar	255
jiveprofilefield	pseudo	int2	5			0
jiveprofilefield	regidx	int4	10			'-1'::integer
jiveprofilefield	summaryindex	int2	5			'-1'::integer
jiveprofilefldopt	defaultoption	int2	5
jiveprofilefldopt	fieldid	int8	19
jiveprofilefldopt	fieldvalue	varchar	255
jiveprofilefldopt	idx	int4	10
jiveprofilefldopt	optionid	int8	19			0
jiveprofilefldsec	fieldid	int8	19
jiveprofilefldsec	levelid	int8	19
jiveprofileseclvl	enabled	int2	5			1
jiveprofileseclvl	levelid	int8	19
jiveprofileseclvl	namekey	varchar	128
jiveprofileseclvl	strategyname	varchar	128
jiveproject	creationdate	int8	19
jiveproject	description	varchar	1000	√		null
jiveproject	displayname	varchar	255	√		null
jiveproject	duedate	int8	19	√		null
jiveproject	duedatenull	int4	10
jiveproject	lateststatusid	int8	19	√		null
jiveproject	modificationdate	int8	19
jiveproject	name	varchar	255
jiveproject	parentobjectid	int8	19
jiveproject	parentobjecttype	int4	10
jiveproject	projectid	int8	19
jiveproject	startdate	int8	19
jiveproject	status	int4	10
jiveproject	userid	int8	19
jiveprojectprop	name	varchar	100
jiveprojectprop	projectid	int8	19
jiveprojectprop	propvalue	varchar	3500
jiveprojectstatus	creationdate	int8	19
jiveprojectstatus	projectid	int8	19
jiveprojectstatus	statusdesc	varchar	255	√		null
jiveprojectstatus	statusid	int8	19
jiveprojectstatus	statustype	int4	10
jiveprojectstatus	userid	int8	19
jiveproperty	name	varchar	255
jiveproperty	propvalue	varchar	3500
jiveptask	assignorid	int8	19	√		null
jiveptask	body	varchar	3500	√		null
jiveptask	completed	int4	10
jiveptask	creationdate	int8	19
jiveptask	duedate	int8	19	√		null
jiveptask	duedatenull	int4	10
jiveptask	modificationdate	int8	19
jiveptask	ownerid	int8	19	√		null
jiveptask	parentobjectid	int8	19
jiveptask	parentobjecttype	int4	10
jiveptask	parenttaskid	int8	19			0
jiveptask	subject	varchar	3500
jiveptask	taskid	int8	19
jiveptask	userid	int8	19	√		null
jiveptaskprop	name	varchar	100
jiveptaskprop	propvalue	varchar	3500
jiveptaskprop	taskid	int8	19
jivepublication	creationdate	int8	19
jivepublication	displayorder	int4	10
jivepublication	modificationdate	int8	19
jivepublication	name	varchar	255
jivepublication	publicationid	int8	19
jivepublication	receiveemails	int4	10
jivepublication	userid	int8	19
jiveqcompletion	completiondate	int8	19
jiveqcompletion	questcompletionid	int8	19
jiveqcompletion	questname	varchar	255
jiveqcompletion	userid	int8	19
jiveqstepprog	completiondate	int8	19	√		null
jiveqstepprog	creationdate	int8	19	√		null
jiveqstepprog	modificationdate	int8	19	√		null
jiveqstepprog	stepname	varchar	255
jiveqstepprog	stepprogressid	int8	19
jiveqstepprog	userid	int8	19
jiveqstepprogprop	name	varchar	255
jiveqstepprogprop	propvalue	varchar	3500
jiveqstepprogprop	stepprogressid	int8	19
jivequestion	containerid	int8	19
jivequestion	containertype	int8	19
jivequestion	creationdate	int8	19
jivequestion	resolutiondate	int8	19	√		null
jivequestion	resolutionstate	int4	10
jivequestion	threadid	int8	19
jivequestion	userid	int8	19
jivequestionprop	name	varchar	100
jivequestionprop	propvalue	varchar	3500
jivequestionprop	threadid	int8	19
jiverating	creationdate	int8	19	√		null
jiverating	modificationdate	int8	19	√		null
jiverating	objectid	int8	19
jiverating	objecttype	int4	10
jiverating	score	int4	10
jiverating	userid	int8	19	√		null
jiveratingtype	description	varchar	1000
jiveratingtype	score	int4	10
jivereadtracker	objectid	int8	19
jivereadtracker	objecttype	int4	10
jivereadtracker	readdate	int8	19
jivereadtracker	userid	int8	19
jiveredirectrules	input	varchar	255
jiveredirectrules	output	varchar	255
jiveredirectrules	priority	int4	10
jiveredirectrules	redirecttype	int4	10			0
jiveredirectrules	ruleid	int8	19
jiveredirectrules	type	int4	10
jivereference	referenceid	int8	19
jivereference	refererobjectid	int8	19
jivereference	refererobjecttype	int2	5
jivereference	refobjectid	int8	19
jivereference	refobjecttype	int2	5
jiveremotestore	keyid	int8	19
jiveremotestore	storeid	int8	19
jiveremotestore	storekey	varchar	64
jiveremotestore	timestamp	int8	19
jiveremotestore	value	bytea	2147483647
jiverenderedcontent	cacheversion	int8	19
jiverenderedcontent	locale	varchar	100
jiverenderedcontent	objectid	int8	19
jiverenderedcontent	objecttype	int4	10
jiverenderedcontent	objectversion	int4	10
jiverenderedcontent	value	text	2147483647
jiverenderedcontentversion	version	int8	19
jiveretentionactiance	actiontype	varchar	100
jiveretentionactiance	authoraddress	varchar	100
jiveretentionactiance	authorid	int8	19
jiveretentionactiance	authorlabel	varchar	1000	√		null
jiveretentionactiance	authorlink	varchar	1000	√		null
jiveretentionactiance	ccaddresses	text	2147483647	√		null
jiveretentionactiance	containerid	int8	19
jiveretentionactiance	containerlabel	varchar	1000	√		null
jiveretentionactiance	containerlink	varchar	1000	√		null
jiveretentionactiance	containertype	int4	10
jiveretentionactiance	content	text	2147483647
jiveretentionactiance	contenttype	varchar	100
jiveretentionactiance	creationdate	int8	19
jiveretentionactiance	itemid	int8	19	√		null
jiveretentionactiance	itemlabel	varchar	1000	√		null
jiveretentionactiance	itemlink	varchar	1000	√		null
jiveretentionactiance	itemtype	int4	10	√		null
jiveretentionactiance	messageid	int8	19
jiveretentionactiance	metadata	text	2147483647	√		null
jiveretentionactiance	parentid	int8	19	√		null
jiveretentionactiance	parenttype	int4	10	√		null
jiveretentionactiance	rootid	int8	19
jiveretentionactiance	roottype	int4	10
jiveretentionactiance	subject	varchar	255
jiveretentionactiance	tags	text	2147483647	√		null
jiveretentionaggregatebinary	authorid	int8	19	√		null
jiveretentionaggregatebinary	binaryblob	bytea	2147483647	√		null
jiveretentionaggregatebinary	binaryid	int8	19
jiveretentionaggregatebinary	binarysize	int8	19
jiveretentionaggregatebinary	binstorename	varchar	255	√		null
jiveretentionaggregatebinary	contenttype	varchar	100
jiveretentionaggregatebinary	messageid	int8	19
jiveretentionaggregatebinary	name	varchar	255
jiveretentionaggregatebinary	originaldisplaytype	varchar	255
jiveretentionaggregatebinary	originalid	int8	19
jiveretentionaggregatebinary	originaltype	varchar	255
jiveretentionattachment	attachmentid	int8	19
jiveretentionattachment	messageid	int8	19
jiveretentionattachmentusers	attachmentid	int8	19
jiveretentionattachmentusers	userid	int8	19
jiveretentioncapturedbin	authorid	int8	19
jiveretentioncapturedbin	binarycontenttype	varchar	100
jiveretentioncapturedbin	binarydisplaytype	varchar	255
jiveretentioncapturedbin	binaryid	int8	19
jiveretentioncapturedbin	binaryname	varchar	255
jiveretentioncapturedbin	binarysize	int8	19
jiveretentioncapturedbin	binarytype	int8	19
jiveretentioncapturedbin	binstorename	varchar	255	√		null
jiveretentioncapturedbin	capturedbinaryid	int8	19
jiveretentioncapturedbin	creationdate	int8	19
jiveretentioncapturedbin	objectid	int8	19
jiveretentioncapturedbin	objecttype	int4	10
jiveretentioncapturedbinary	authorid	int8	19
jiveretentioncapturedbinary	binaryblob	bytea	2147483647	√		null
jiveretentioncapturedbinary	binarycontenttype	varchar	100
jiveretentioncapturedbinary	binarydisplaytype	varchar	255
jiveretentioncapturedbinary	binaryid	int8	19
jiveretentioncapturedbinary	binaryname	varchar	255
jiveretentioncapturedbinary	binarysize	int8	19
jiveretentioncapturedbinary	binarytype	int8	19
jiveretentioncapturedbinary	capturedbinaryid	int8	19
jiveretentioncapturedbinary	creationdate	int8	19
jiveretentioncapturedbinary	objectid	int8	19
jiveretentioncapturedbinary	objecttype	int4	10
jiveretentionimage	imageid	int8	19
jiveretentionimage	messageid	int8	19
jiveretentionmessagearchive	actiontype	varchar	100
jiveretentionmessagearchive	authoraddress	varchar	100
jiveretentionmessagearchive	authorid	int8	19
jiveretentionmessagearchive	authorlabel	varchar	1000	√		null
jiveretentionmessagearchive	authorlink	varchar	1000	√		null
jiveretentionmessagearchive	ccaddresses	text	2147483647	√		null
jiveretentionmessagearchive	containerid	int8	19
jiveretentionmessagearchive	containerlabel	varchar	1000	√		null
jiveretentionmessagearchive	containerlink	varchar	1000	√		null
jiveretentionmessagearchive	containertype	int4	10
jiveretentionmessagearchive	content	text	2147483647
jiveretentionmessagearchive	contenttype	varchar	100
jiveretentionmessagearchive	creationdate	int8	19
jiveretentionmessagearchive	itemid	int8	19	√		null
jiveretentionmessagearchive	itemlabel	varchar	1000	√		null
jiveretentionmessagearchive	itemlink	varchar	1000	√		null
jiveretentionmessagearchive	itemtype	int4	10	√		null
jiveretentionmessagearchive	messageid	int8	19
jiveretentionmessagearchive	metadata	text	2147483647	√		null
jiveretentionmessagearchive	parentid	int8	19	√		null
jiveretentionmessagearchive	parenttype	int4	10	√		null
jiveretentionmessagearchive	rootid	int8	19
jiveretentionmessagearchive	roottype	int4	10
jiveretentionmessagearchive	subject	varchar	255
jiveretentionmessagearchive	tags	text	2147483647	√		null
jiveretentionmessagebinaries	capturedbinaryid	int8	19
jiveretentionmessagebinaries	messageid	int8	19
jiveretentionqueue	actiontype	varchar	100
jiveretentionqueue	authoraddress	varchar	100
jiveretentionqueue	authorid	int8	19
jiveretentionqueue	authorlabel	varchar	1000	√		null
jiveretentionqueue	authorlink	varchar	1000	√		null
jiveretentionqueue	ccaddresses	text	2147483647	√		null
jiveretentionqueue	containerid	int8	19
jiveretentionqueue	containerlabel	varchar	1000	√		null
jiveretentionqueue	containerlink	varchar	1000	√		null
jiveretentionqueue	containertype	int4	10
jiveretentionqueue	content	text	2147483647
jiveretentionqueue	contenttype	varchar	100
jiveretentionqueue	creationdate	int8	19
jiveretentionqueue	itemid	int8	19	√		null
jiveretentionqueue	itemlabel	varchar	1000	√		null
jiveretentionqueue	itemlink	varchar	1000	√		null
jiveretentionqueue	itemtype	int4	10	√		null
jiveretentionqueue	messageid	int8	19
jiveretentionqueue	metadata	text	2147483647	√		null
jiveretentionqueue	parentid	int8	19	√		null
jiveretentionqueue	parenttype	int4	10	√		null
jiveretentionqueue	rootid	int8	19
jiveretentionqueue	roottype	int4	10
jiveretentionqueue	subject	varchar	255
jiveretentionqueue	tags	text	2147483647	√		null
jivermtbridgedcont	bridgedcontid	int8	19
jivermtbridgedcont	localcontentid	int8	19
jivermtbridgedcont	localcontenttype	int8	19
jivermtbridgedcont	rmtbridgedcontid	int8	19
jivermtbridgedcont	rmtcontentid	int8	19
jivermtbridgedcont	rmtcontenttype	int8	19
jivermtbridgedcont	url	varchar	255
jivermtbridgedcont	uuid	varchar	128
jivertccollabinteraction	body	text	2147483647
jivertccollabinteraction	collaborationid	int8	19
jivertccollabinteraction	creationdate	int8	19
jivertccollabinteraction	externalcreationdate	int8	19
jivertccollabinteraction	extinteractionid	int8	19
jivertccollabinteraction	modificationdate	int8	19
jivertccollabinteraction	periodid	int8	19
jivertccollabinteraction	userid	int8	19
jivertccollaboration	collaborationid	int8	19
jivertccollaboration	containerid	int8	19
jivertccollaboration	containertype	int4	10
jivertccollaboration	creationdate	int8	19
jivertccollaboration	externalid	varchar	64	√		null
jivertccollaboration	externalpublishdate	int8	19
jivertccollaboration	modificationdate	int8	19
jivertccollaboration	sourceid	int2	5
jivertccollaboration	subject	text	2147483647	√		''::text
jivertccollaboration	subjecturl	text	2147483647	√		''::text
jivertccollaboration	typeid	int2	5
jivertccollaboration	userid	int8	19
jivertccollaborationstate	collabconsistencystatusid	int2	5
jivertccollaborationstate	collaborationid	int8	19
jivertccollaborationstate	creationdate	int8	19
jivertccollaborationstate	interactionconsistencystatusid	int2	5
jivertccollaborationstate	modificationdate	int8	19
jivertccollaborationuser	collaborationid	int8	19
jivertccollaborationuser	userid	int8	19
jivertcinteractionidmap	collaborationid	int8	19
jivertcinteractionidmap	extinteractionid	int8	19
jivertcinteractionidmap	interactionid	int8	19
jivertcinteractionperiod	collaborationid	int8	19
jivertcinteractionperiod	creationdate	int8	19
jivertcinteractionperiod	earliestinteractiondate	int8	19
jivertcinteractionperiod	ismostrecent	int2	5			0
jivertcinteractionperiod	latestinteractiondate	int8	19
jivertcinteractionperiod	modificationdate	int8	19
jivertcinteractionperiod	periodid	int8	19
jivesamlauthnrequest	creationdate	int8	19
jivesamlauthnrequest	messagexml	text	2147483647
jivesamlauthnrequest	msgid	int8	19
jivesamlauthnrequest	requestid	varchar	255
jivesearchengine	authenticated	int2	5			0
jivesearchengine	description	varchar	2000	√		null
jivesearchengine	descriptorurl	varchar	2000	√		null
jivesearchengine	enabled	int4	10
jivesearchengine	engineid	int8	19
jivesearchengine	externalsearchurl	varchar	2000
jivesearchengine	iconurl	varchar	2000	√		null
jivesearchengine	maxresultcount	int4	10			20
jivesearchengine	password	varchar	40	√		null
jivesearchengine	querytestterm	varchar	40	√		'test'::character varying
jivesearchengine	searchcontenttype	varchar	100	√		null
jivesearchengine	searchhttpmethod	varchar	10	√		'GET'::character varying
jivesearchengine	searchurl	varchar	2000
jivesearchengine	shortname	varchar	255
jivesearchengine	username	varchar	40	√		null
jivesectionelement	documenttypeid	int8	19
jivesectionelement	elementid	int8	19
jivesectionelement	elementindex	int4	10
jivesectionelement	elementtypeid	int8	19
jivesectionelement	parentid	int8	19
jiveserverscript	creationdate	int8	19
jiveserverscript	extensionuuid	varchar	48	√		null
jiveserverscript	filename	varchar	255
jiveserverscript	js	text	2147483647	√		null
jiveserverscript	jshash	varchar	64
jiveserverscript	modificationdate	int8	19
jiveserverscript	scriptid	int8	19
jivesgroup	creationdate	int8	19
jivesgroup	description	varchar	1000	√		null
jivesgroup	displayname	varchar	255
jivesgroup	groupid	int8	19
jivesgroup	grouptype	int4	10
jivesgroup	modificationdate	int8	19
jivesgroup	name	varchar	255
jivesgroup	status	int4	10
jivesgroup	userid	int8	19
jivesgroupmember	creationdate	int8	19
jivesgroupmember	groupid	int8	19
jivesgroupmember	memberdate	int8	19	√		null
jivesgroupmember	membershipid	int8	19
jivesgroupmember	membertype	int4	10
jivesgroupmember	userid	int8	19
jivesgroupmember	workflowid	int8	19	√		null
jivesgroupprop	groupid	int8	19
jivesgroupprop	name	varchar	100
jivesgroupprop	propvalue	varchar	3500
jiveslide	body	text	2147483647
jiveslide	containerid	int8	19
jiveslide	containertype	int4	10
jiveslide	creationdate	int8	19
jiveslide	imageuri	varchar	2048
jiveslide	modificationdate	int8	19
jiveslide	publishdate	int8	19
jiveslide	slideid	int8	19
jiveslide	sortkey	int4	10			0
jiveslide	status	int4	10
jiveslide	subject	varchar	255
jiveslide	targetlink	varchar	2048
jiveslide	userid	int8	19
jivespamdomainwhitelist	whitelisturl	varchar	255
jivestatics	creationdate	int8	19
jivestatics	crypthash	varchar	64	√		null
jivestatics	description	varchar	1000	√		null
jivestatics	filename	varchar	127
jivestatics	modificationdate	int8	19
jivestatics	placeobjectid	int8	19
jivestatics	placeobjecttype	int4	10
jivestatics	staticid	int8	19
jivestatics	statictypeid	int4	10			1
jivestatics	status	int4	10			2
jivestatics	userid	int8	19
jivestatlvlscen	code	varchar	20
jivestatlvlscen	enabled	int2	5
jivestatlvlscen	i18nkey	varchar	100
jivestatlvlscen	points	int8	19
jivestatlvlscen	scenarioid	int8	19
jivestatuslevel	description	varchar	1000	√		null
jivestatuslevel	groupid	int8	19
jivestatuslevel	imagepath	varchar	255
jivestatuslevel	largeimagepath	varchar	255	√		null
jivestatuslevel	maxpoints	int4	10
jivestatuslevel	minpoints	int4	10
jivestatuslevel	name	varchar	255
jivestatuslevel	statuslevelid	int8	19
jivestatuslevelpnt	code	varchar	20
jivestatuslevelpnt	containerid	int8	19
jivestatuslevelpnt	containertype	int8	19
jivestatuslevelpnt	creationdate	int8	19
jivestatuslevelpnt	objectid	int8	19
jivestatuslevelpnt	objecttype	int4	10
jivestatuslevelpnt	pointid	int8	19
jivestatuslevelpnt	points	int8	19
jivestatuslevelpnt	userid	int8	19
jivestatuslevelpntsum	calculationdate	int8	19
jivestatuslevelpntsum	containerid	int8	19
jivestatuslevelpntsum	containertype	int8	19
jivestatuslevelpntsum	dirty	int2	5			0
jivestatuslevelpntsum	pointlevel	int8	19	√		null
jivestatuslevelpntsum	userid	int8	19
jivestorageattachment	espattid	varchar	512	√		null
jivestorageattachment	exstorageattid	int8	19
jivestorageattachment	exstoragecontainerid	int8	19
jivestoragecomment	espcommentid	varchar	512	√		null
jivestoragecomment	exstoragecommentid	int8	19
jivestoragecomment	exstoragefileid	int8	19
jivestoragecomment	externalmodificationtime	int8	19	√		null
jivestoragecomment	jivecommentid	int8	19
jivestoragecontainer	containerconfig	text	2147483647	√		null
jivestoragecontainer	creationdate	int8	19
jivestoragecontainer	exstoragecontainerid	int8	19
jivestoragecontainer	exstorageinstanceid	int8	19
jivestoragecontainer	externalid	varchar	512	√		null
jivestoragecontainer	jivecontainerid	int8	19
jivestoragecontainer	jivecontainertype	int4	10
jivestoragecontainer	modificationdate	int8	19
jivestoragecontainer	permsancestor	int8	19	√		null
jivestoragecontainer	state	int4	10	√		null
jivestoragedefinition	clientid	varchar	1024
jivestoragedefinition	configcontainerurl	varchar	2048	√		null
jivestoragedefinition	configinstanceurl	varchar	2048	√		null
jivestoragedefinition	creationdate	int8	19
jivestoragedefinition	definitionid	int8	19
jivestoragedefinition	description	varchar	4000	√		null
jivestoragedefinition	displayname	varchar	1027
jivestoragedefinition	extensionuuid	varchar	128	√		null
jivestoragedefinition	gotocontainername	varchar	1027	√		null
jivestoragedefinition	gotofilename	varchar	1027	√		null
jivestoragedefinition	healthcheckurl	varchar	2048	√		null
jivestoragedefinition	internali18nkeys	varchar	1024	√		null
jivestoragedefinition	modificationdate	int8	19
jivestoragedefinition	name	varchar	127
jivestoragedefinition	perfixurl	varchar	2048	√		null
jivestoragedefinition	registerurl	varchar	2048
jivestoragedefinition	resolveresourcesurl	varchar	2048
jivestoragedefinition	userfaceurl	text	2147483647	√		null
jivestoragedefinition	usermappingoptions	varchar	127	√		null
jivestoragedefresource	definitionid	int8	19
jivestoragedefresource	resourcenameid	int8	19
jivestorageentupdate	objectid	int8	19
jivestorageentupdate	objecttype	int4	10
jivestoragefile	espfileid	varchar	512	√		null
jivestoragefile	exstoragecontainerid	int8	19
jivestoragefile	exstoragefileid	int8	19
jivestoragefile	previewappid	bpchar	36	√		null
jivestoragefile	previewappurl	varchar	3500	√		null
jivestoragefileversion	espfileversionid	varchar	512	√		null
jivestoragefileversion	exstoragefileid	int8	19
jivestoragefileversion	exstoragefileversionid	int8	19
jivestoragefileversion	previewappcontext	varchar	1024	√		null
jivestorageinsconfig	enabled	int2	5
jivestorageinsconfig	instanceconfig	text	2147483647	√		null
jivestorageinsconfig	instanceid	int8	19
jivestorageinsconfig	orderidx	int4	10
jivestorageinsconfig	usergroupid	int8	19
jivestorageinstance	creationdate	int8	19
jivestorageinstance	definitionid	int8	19
jivestorageinstance	displayname	varchar	1027
jivestorageinstance	instanceid	int8	19
jivestorageinstance	modificationdate	int8	19
jivestorageinstance	orderidx	int4	10
jivestorageinstance	usermappingfield1	int8	19
jivestorageinstance	usermappingfield2	int8	19	√		null
jivestorageinstance	usermappingoption	int4	10
jivestoragemember	entityid	int8	19
jivestoragemember	entitytype	int4	10
jivestoragemember	espid	varchar	512	√		null
jivestoragemember	exstoragecontainerid	int8	19
jivestoragemember	exstorageid	int8	19
jivestoragemember	isasyncplaceholder	int2	5			0
jivestoragemember	permission	int4	10
jivestoragepreview	esppreviewid	varchar	512	√		null
jivestoragepreview	exstoragecontainerid	int8	19
jivestoragepreview	exstoragefileid	varchar	512	√		null
jivestoragepreview	exstoragepreviewid	int8	19
jivestorageresource	nameid	int8	19
jivestorageresource	objectid	int8	19
jivestorageresource	objecttype	int4	10
jivestorageresource	url	varchar	2500
jivestorageresource	verbs	int2	5
jivestorageresourcename	name	varchar	127
jivestorageresourcename	resourcenameid	int8	19
jivestreamaction	label	varchar	127
jivestreamaction	method	varchar	32
jivestreamaction	seq	int2	5
jivestreamaction	streamentryid	int8	19
jivestreamaction	type	varchar	32
jivestreamaction	url	varchar	3500	√		null
jivestreamapprover	streamentryid	int8	19
jivestreamapprover	userid	int8	19
jivestreamchannel	channelsigmd5	varchar	127
jivestreamchannel	channelsignature	varchar	3500
jivestreamchannel	creationdate	int8	19
jivestreamchannel	displayid	int4	10			1000
jivestreamchannel	generatorid	varchar	127
jivestreamchannel	modificationdate	int8	19
jivestreamchannel	streamchannelid	int8	19
jivestreamentprop	name	varchar	100
jivestreamentprop	propvalue	varchar	3500
jivestreamentprop	streamentryid	int8	19
jivestreamentry	activityfaviconurl	varchar	1024	√		null
jivestreamentry	activityid	varchar	3500	√		null
jivestreamentry	activityidmd5	varchar	127	√		null
jivestreamentry	activityspec	varchar	32	√		null
jivestreamentry	body	varchar	1024	√		null
jivestreamentry	creationdate	int8	19
jivestreamentry	modificationdate	int8	19
jivestreamentry	objectid	int8	19	√		null
jivestreamentry	objectmediatype	varchar	32	√		null
jivestreamentry	objecttitle	varchar	1024	√		null
jivestreamentry	objecttype	int4	10	√		null
jivestreamentry	releasekeysha1	varchar	40	√		null
jivestreamentry	streamchannelid	int8	19
jivestreamentry	streamentryid	int8	19
jivestreamentry	summary	varchar	3500	√		null
jivestreamentry	targetid	int8	19	√		null
jivestreamentry	targettype	int4	10	√		null
jivestreamentry	title	varchar	420	√		null
jivestreamentry	unmappedvalues	text	2147483647	√		null
jivestreamentry	userid	int8	19
jivestreamentry	verb	varchar	128
jivestreamenttext	attribute	int4	10
jivestreamenttext	locale	varchar	16
jivestreamenttext	streamentryid	int8	19
jivestreamenttext	text	text	2147483647	√		null
jivestrnotpref	preferenceid	int8	19
jivestrnotpref	receivemobile	int4	10
jivestrnotpref	streamid	int8	19
jivestrnotpref	userid	int8	19
jivesubscription	creationdate	int8	19
jivesubscription	modificationdate	int8	19
jivesubscription	publicationid	int8	19
jivesubscription	subscriptionid	int8	19
jivesubscriptionassociation	associationid	int8	19
jivesubscriptionassociation	associationtype	int4	10
jivesubscriptionassociation	entryid	int8	19
jivesubscriptionassociation	subscriptionid	int8	19
jivesubscriptionsubscriber	entryid	int8	19
jivesubscriptionsubscriber	subscriberid	int8	19
jivesubscriptionsubscriber	subscribertype	int4	10
jivesubscriptionsubscriber	subscriptionid	int8	19
jivetag	creationdate	int8	19
jivetag	tagid	int8	19
jivetag	tagname	varchar	100
jivetagcloud	containerid	int8	19
jivetagcloud	containertype	int4	10
jivetagcloud	tagcount	int4	10
jivetagcloud	taggabletype	int8	19
jivetagcloud	tagid	int8	19
jivetagset	containerid	int8	19
jivetagset	containertype	int4	10
jivetagset	creationdate	int8	19
jivetagset	description	varchar	1000	√		null
jivetagset	displayorder	int4	10			0
jivetagset	modificationdate	int8	19
jivetagset	name	varchar	100
jivetagset	tagsetid	int8	19
jivetagsetmap	tagid	int8	19
jivetagsetmap	tagsetid	int8	19
jivetaskhistory	endtime	int8	19
jivetaskhistory	executionerror	text	2147483647	√		null
jivetaskhistory	executionid	int8	19
jivetaskhistory	executor	varchar	255
jivetaskhistory	starttime	int8	19
jivetaskhistory	taskuid	varchar	255
jivetaskhistory_1	endtime	int8	19
jivetaskhistory_1	executionerror	text	2147483647	√		null
jivetaskhistory_1	executionid	int8	19
jivetaskhistory_1	executor	varchar	255
jivetaskhistory_1	starttime	int8	19
jivetaskhistory_1	taskuid	varchar	255
jivetaskhistory_2	endtime	int8	19
jivetaskhistory_2	executionerror	text	2147483647	√		null
jivetaskhistory_2	executionid	int8	19
jivetaskhistory_2	executor	varchar	255
jivetaskhistory_2	starttime	int8	19
jivetaskhistory_2	taskuid	varchar	255
jivetasklateststatus	endtime	int8	19	√		null
jivetasklateststatus	executor	varchar	255	√		null
jivetasklateststatus	starttime	int8	19	√		null
jivetasklateststatus	state	int2	5	√		null
jivetasklateststatus	status	bytea	2147483647	√		null
jivetasklateststatus	taskuid	varchar	255
jivetaskqueue	exectime	int8	19
jivetaskqueue	lockingnode	varchar	255	√		null
jivetaskqueue	locktime	int8	19	√		null
jivetaskqueue	taskdetails	bytea	2147483647	√		null
jivetaskqueue	taskdigest	bpchar	32	√		null
jivetaskqueue	taskid	int8	19
jivetaskqueue	taskuid	varchar	255
jivetemplatecategory	categoryid	int8	19
jivetemplatecategory	templateid	int8	19
jivetemplatecategorydef	categoryid	int8	19
jivetemplatecategorydef	creationdate	int8	19
jivetemplatecategorydef	description	varchar	1000	√		null
jivetemplatecategorydef	hidden	int4	10			0
jivetemplatecategorydef	internal	int4	10			1
jivetemplatecategorydef	modificationdate	int8	19
jivetemplatecategorydef	name	varchar	100
jivetermsandcond	body	text	2147483647	√		null
jivetermsandcond	version	int4	10
jivethememap	maptype	varchar	16
jivethememap	numvalue	int8	19	√		null
jivethememap	stringvalue	varchar	100	√		null
jivethememap	theme	varchar	32
jivethread	containerid	int8	19
jivethread	containertype	int4	10
jivethread	creationdate	int8	19
jivethread	modificationdate	int8	19
jivethread	rewardpoints	int4	10
jivethread	rootmessageid	int8	19
jivethread	status	int4	10
jivethread	threadid	int8	19
jivethreadlatest	messagecount	int4	10	√		null
jivethreadlatest	messageid	int8	19	√		null
jivethreadlatest	rootmessageuserid	int8	19
jivethreadlatest	threadid	int8	19
jivethreadprop	name	varchar	100
jivethreadprop	propvalue	varchar	3500
jivethreadprop	threadid	int8	19
jivetile	actionurl	varchar	1024	√		null
jivetile	clientid	varchar	127	√		null
jivetile	configurationurl	varchar	1024	√		null
jivetile	creationdate	int8	19
jivetile	dataproviderkey	varchar	127			'external'::character varying
jivetile	defaultsharing	varchar	64			'SHOULD'::character varying
jivetile	description	varchar	4000	√		null
jivetile	displayname	varchar	255	√		null
jivetile	displaywidth	varchar	64			'NARROW'::character varying
jivetile	enabledproviderkey	varchar	127			'alwaysEnabled'::character varying
jivetile	extensionuuid	varchar	48	√		null
jivetile	internali18nkeys	varchar	1024	√		null
jivetile	modificationdate	int8	19
jivetile	oauth2dependent	int2	5			0
jivetile	ownerid	int8	19	√		null
jivetile	pagetype	varchar	256			'PLACE'::character varying
jivetile	productname	varchar	255	√		null
jivetile	registerurl	varchar	2500	√		null
jivetile	sampledata	text	2147483647	√		null
jivetile	state	varchar	64			'PUBLISHED'::character varying
jivetile	tileid	int8	19
jivetile	tilename	varchar	127
jivetile	unregisterurl	varchar	2500	√		null
jivetile	viewurl	varchar	2500	√		null
jivetile	visualstyle	varchar	64
jivetilecategory	categoryid	int8	19
jivetilecategory	tileid	int8	19
jivetilecategorydef	categoryid	int8	19
jivetilecategorydef	creationdate	int8	19
jivetilecategorydef	description	varchar	1000	√		null
jivetilecategorydef	hidden	int4	10			0
jivetilecategorydef	internal	int4	10			1
jivetilecategorydef	modificationdate	int8	19
jivetilecategorydef	name	varchar	100
jivetilei18n	bundle	text	2147483647	√		null
jivetilei18n	lastmodified	int8	19
jivetilei18n	locale	varchar	10
jivetilei18n	tileid	int8	19
jivetileinstance	config	text	2147483647	√		null
jivetileinstance	creationdate	int8	19
jivetileinstance	displayname	varchar	255	√		null
jivetileinstance	externalid	varchar	127	√		null
jivetileinstance	instancecolumn	int4	10
jivetileinstance	instancedata	text	2147483647	√		null
jivetileinstance	instanceorder	int4	10
jivetileinstance	lastdatapush	int8	19	√		null
jivetileinstance	lastdatapusherror	int8	19	√		null
jivetileinstance	lastregister	int8	19	√		null
jivetileinstance	modificationdate	int8	19
jivetileinstance	parentobjectid	int8	19
jivetileinstance	parentobjecttype	int4	10
jivetileinstance	privatepath	varchar	127	√		null
jivetileinstance	pusherrordetail	text	2147483647	√		null
jivetileinstance	state	varchar	64
jivetileinstance	status	text	2147483647	√		null
jivetileinstance	streamiconurl	varchar	1024	√		null
jivetileinstance	tileid	int8	19
jivetileinstance	tileinstanceid	int8	19
jivetileinstance	userid	int8	19
jivetileinstgone	deletiondate	int8	19
jivetileinstgone	tileinstanceid	int8	19
jivetilepage	creationdate	int8	19
jivetilepage	displayname	varchar	255
jivetilepage	displayorder	int4	10
jivetilepage	layout	varchar	255
jivetilepage	modificationdate	int8	19
jivetilepage	name	varchar	255
jivetilepage	pagetype	varchar	64
jivetilepage	parentobjectid	int8	19
jivetilepage	parentobjecttype	int4	10
jivetilepage	templateid	int8	19
jivetilepage	tilepageid	int8	19
jivetilepageprop	name	varchar	100
jivetilepageprop	propvalue	varchar	3500
jivetilepageprop	tilepageid	int8	19
jivetileprops	name	varchar	100
jivetileprops	propvalue	varchar	3500
jivetileprops	tileid	int8	19
jivetilestreamentry	actiondescription	varchar	255	√		null
jivetilestreamentry	actionname	varchar	127
jivetilestreamentry	attributionemail	varchar	127	√		null
jivetilestreamentry	attributionname	varchar	127	√		null
jivetilestreamentry	body	text	2147483647	√		null
jivetilestreamentry	containerid	int8	19
jivetilestreamentry	containertype	int4	10
jivetilestreamentry	context	text	2147483647	√		null
jivetilestreamentry	creationdate	int8	19
jivetilestreamentry	externalgroupname	text	2147483647	√		null
jivetilestreamentry	externalid	varchar	255	√		null
jivetilestreamentry	externalurl	varchar	1024
jivetilestreamentry	iconurl	varchar	1024	√		null
jivetilestreamentry	imageurl	varchar	1024
jivetilestreamentry	modificationdate	int8	19
jivetilestreamentry	modifieremail	text	2147483647	√		null
jivetilestreamentry	modifiername	text	2147483647	√		null
jivetilestreamentry	opengraphtype	varchar	127
jivetilestreamentry	status	int4	10
jivetilestreamentry	subject	varchar	255	√		null
jivetilestreamentry	tileid	int8	19
jivetilestreamentry	tileinstanceid	int8	19
jivetilestreamentry	tilestreamentryid	int8	19
jivetilestreamentry	userid	int8	19
jivetiletemplate	backgroundimageurl	varchar	1024	√		null
jivetiletemplate	bgcolor	varchar	64	√		null
jivetiletemplate	bgposition	varchar	64	√		null
jivetiletemplate	bgrepeat	varchar	64	√		null
jivetiletemplate	blurb	varchar	400	√		null
jivetiletemplate	contenttypes	varchar	1500	√		null
jivetiletemplate	creationdate	int8	19
jivetiletemplate	description	varchar	4000	√		null
jivetiletemplate	displayname	varchar	255	√		null
jivetiletemplate	extensionuuid	varchar	48			'none'::character varying
jivetiletemplate	externallyaccessible	int2	5	√		null
jivetiletemplate	global	int4	10			0
jivetiletemplate	grouptype	int4	10	√		null
jivetiletemplate	modificationdate	int8	19
jivetiletemplate	state	varchar	64			'PUBLISHED'::character varying
jivetiletemplate	subtitle	varchar	127	√		null
jivetiletemplate	templateid	int8	19
jivetiletemplate	templatename	varchar	127
jivetiletemplate	textcolor	varchar	64	√		null
jivetiletemplate	userid	int8	19
jivetiletmplassoc	sortorder	int4	10
jivetiletmplassoc	templateid	int8	19
jivetiletmplassoc	tilecolumn	int4	10			1
jivetiletmplassoc	tileid	int8	19
jivetypevldtrprop	name	varchar	100
jivetypevldtrprop	propvalue	varchar	3500
jivetypevldtrprop	typeid	int8	19
jiveuser	creationdate	int8	19
jiveuser	email	varchar	254
jiveuser	emailvisible	int4	10
jiveuser	federated	int4	10			0
jiveuser	firstname	varchar	100	√		null
jiveuser	initiallogindate	int8	19			0
jiveuser	lastloggedin	int8	19			0
jiveuser	lastname	varchar	100	√		null
jiveuser	lastprofileupdate	int8	19			0
jiveuser	modificationdate	int8	19
jiveuser	name	varchar	100	√		null
jiveuser	namevisible	int4	10
jiveuser	passwordhash	varchar	64
jiveuser	status	int4	10			6
jiveuser	userenabled	int4	10
jiveuser	userid	int8	19
jiveuser	username	varchar	254
jiveuser	usertype	int4	10			0
jiveuser	visible	int4	10			1
jiveuseraltemail	email	varchar	254
jiveuseraltemail	userid	int8	19
jiveuseraltemail	userprofileid	int8	19
jiveuserannprop	annid	int8	19
jiveuserannprop	userid	int8	19
jiveusercontainer	creationdate	int8	19
jiveusercontainer	modificationdate	int8	19
jiveusercontainer	status	int4	10
jiveusercontainer	usercontainerid	int8	19
jiveusercontainer	userid	int8	19
jiveusercontnrprop	name	varchar	100
jiveusercontnrprop	propvalue	varchar	3500
jiveusercontnrprop	usercontainerid	int8	19
jiveuserimhandle	imhandle	varchar	100
jiveuserimhandle	imtype	int4	10
jiveuserimhandle	userid	int8	19
jiveusermesgcount	messagecount	int4	10
jiveusermesgcount	userid	int8	19
jiveuserperm	objectid	int8	19
jiveuserperm	objecttype	int4	10
jiveuserperm	permission	int4	10
jiveuserperm	permissiontype	int4	10
jiveuserperm	userid	int8	19
jiveuserprofile	fieldid	int8	19
jiveuserprofile	levelid	int8	19	√		null
jiveuserprofile	primaryval	int2	5
jiveuserprofile	userid	int8	19
jiveuserprofile	userprofileid	int8	19
jiveuserprofile	value	varchar	3500	√		null
jiveuserprop	name	varchar	100
jiveuserprop	propvalue	varchar	3500
jiveuserprop	userid	int8	19
jiveuserrel	creationdate	int8	19
jiveuserrel	graphid	int8	19
jiveuserrel	modificationdate	int8	19
jiveuserrel	relateduserid	int8	19
jiveuserrel	relationshipid	int8	19
jiveuserrel	relnshiptypeid	int4	10			2
jiveuserrel	retirementdate	int8	19	√		0
jiveuserrel	state	varchar	20			'pending_approval'::character varying
jiveuserrel	userid	int8	19
jiveuserrel	workflowid	int8	19	√		null
jiveuserrelgraph	approvalsenabled	int2	5			0
jiveuserrelgraph	drptchoiceallowed	int2	5			0
jiveuserrelgraph	enabled	int2	5			1
jiveuserrelgraph	graphid	int8	19
jiveuserrelgraph	graphtypeid	int4	10			1
jiveuserrelgraph	labeldirrpt	varchar	40	√		null
jiveuserrelgraph	labelmanager	varchar	40	√		null
jiveuserrelgraph	labelpeer	varchar	40	√		null
jiveuserrelgraph	mgrchoiceallowed	int2	5			0
jiveuserrelgraph	name	varchar	255
jiveuserrelgraph	peerchoiceallowed	int2	5			0
jiveuserrelgraph	reflexive	int2	5			1
jiveuserroster	subuserid	int8	19
jiveuserroster	userid	int8	19
jiveusersecretkey	creationdate	int8	19
jiveusersecretkey	keyvalue	varchar	255
jiveusersecretkey	userid	int8	19
jiveusersecretkey	usersecretkeyid	int8	19
jiveuserstatus	containerid	int8	19			'-1'::integer
jiveuserstatus	containertype	int4	10			'-1'::integer
jiveuserstatus	creationdate	int8	19
jiveuserstatus	latitude	float8	17,17			'-1'::integer
jiveuserstatus	longitude	float8	17,17			'-1'::integer
jiveuserstatus	modificationdate	int8	19			0
jiveuserstatus	status	int4	10			2
jiveuserstatus	statustype	int4	10			0
jiveuserstatus	userid	int8	19
jiveuserstatus	userstatusid	int8	19
jiveuserstatus	userstatustext	text	2147483647	√		null
jiveusrrelgrapr	graphid	int8	19
jiveusrrelgrapr	userid	int8	19
jiveusrrelgrntf	graphid	int8	19
jiveusrrelgrntf	userid	int8	19
jiveusrrellist	labelstyle	varchar	200	√		null
jiveusrrellist	listid	int8	19
jiveusrrellist	name	varchar	200
jiveusrrellist	userid	int8	19
jiveusrrellistmap	listid	int8	19
jiveusrrellistmap	relationshipid	int8	19
jiveuuid	longid	int8	19
jiveuuid	objectid	int8	19	√		null
jiveuuid	objecttype	int4	10	√		null
jiveuuid	uuid	varchar	128
jiveuuid	version	int4	10	√		null
jiveuuidext	externalid	varchar	255
jiveuuidext	externalidtype	varchar	128
jiveuuidext	uuid	varchar	128
jiveversion	name	varchar	50
jiveversion	timestamp	int8	19	√		null
jiveversion	version	int4	10
jivevideo	body	text	2147483647	√		null
jivevideo	commentstatus	int4	10			2
jivevideo	containerid	int8	19
jivevideo	containertype	int4	10
jivevideo	creationdate	int8	19
jivevideo	duration	int4	10			0
jivevideo	embedded	int2	5	√		null
jivevideo	embedsource	text	2147483647	√		null
jivevideo	externalid	varchar	512	√		null
jivevideo	isdone	int2	5			0
jivevideo	modificationdate	int8	19
jivevideo	status	int4	10			0
jivevideo	subject	varchar	255	√		null
jivevideo	userid	int8	19
jivevideo	videometadata	text	2147483647	√		null
jivevideo	videosource	text	2147483647	√		null
jivevideo	videothumbnail	varchar	512	√		null
jivevideo	videotype	varchar	512	√		null
jivevideo	vidid	int8	19
jivevideoscreens	attachmentid	int8	19
jivevideoscreens	isdefault	int2	5
jivevideoscreens	vidid	int8	19
jiveviewcount	objectid	int8	19
jiveviewcount	objecttype	int4	10
jiveviewcount	viewcount	int8	19	√		0
jivewatch	expirable	int2	5
jivewatch	objectid	int8	19
jivewatch	objecttype	int4	10
jivewatch	userid	int8	19
jivewatch	watchtype	int4	10
jivewatchsettings	emailfrequency	int2	5
jivewatchsettings	includepostcontent	int2	5			1
jivewatchsettings	notifyactionqueue	int2	5
jivewatchsettings	notifydirectaction	int2	5
jivewatchsettings	notifyinboxnotific	int2	5
jivewatchsettings	notifymoderationqueue	int2	5
jivewatchsettings	notifymycomm	int2	5
jivewatchsettings	notifyprofileupdates	int2	5			'-1'::integer
jivewatchsettings	receiveemails	int2	5
jivewatchsettings	receivehtmlemails	int2	5			1
jivewatchsettings	upgraded	int2	5			1
jivewatchsettings	userid	int8	19
jivewebhook	bugdetail	varchar	3500	√		null
jivewebhook	buggy	int2	5
jivewebhook	buggydate	int8	19	√		null
jivewebhook	connectiontimeout	int4	10	√		null
jivewebhook	containerid	int8	19
jivewebhook	containertype	int4	10
jivewebhook	creationdate	int8	19
jivewebhook	enabled	int2	5
jivewebhook	fields	varchar	2000	√		null
jivewebhook	hookid	int8	19
jivewebhook	internal	int2	5
jivewebhook	listenas	int8	19
jivewebhook	modificationdate	int8	19
jivewebhook	oauthcodeid	int8	19
jivewebhook	objectid	int8	19	√		null
jivewebhook	objecttype	int4	10	√		null
jivewebhook	readtimeout	int4	10	√		null
jivewebhook	types	varchar	2000	√		null
jivewebhook	typesmd5	varchar	48	√		null
jivewebhook	url	varchar	2000
jivewebhook	userid	int8	19
jivewebhooklocks	creationdate	int8	19
jivewebhooklocks	lockingnode	varchar	255	√		null
jivewebhooklocks	locktime	int8	19	√		null
jivewebhooklocks	urlmd5	varchar	48
jivewebhookqueue	creationdate	int8	19
jivewebhookqueue	entryid	int8	19
jivewebhookqueue	hookid	int8	19
jivewebhookqueue	modificationdate	int8	19
jivewebhookqueue	payload	bytea	2147483647
jivewebhookqueue	url	varchar	2000
jivewebhookqueue	urlmd5	varchar	48
jivewfcurrentstep	actionid	int2	5	√		null
jivewfcurrentstep	caller	varchar	100	√		null
jivewfcurrentstep	duedate	timestamp	29,6	√		null
jivewfcurrentstep	entryid	int8	19	√		null
jivewfcurrentstep	finishdate	timestamp	29,6	√		null
jivewfcurrentstep	id	int8	19
jivewfcurrentstep	owner	varchar	100	√		null
jivewfcurrentstep	startdate	timestamp	29,6	√		null
jivewfcurrentstep	status	varchar	20	√		null
jivewfcurrentstep	stepid	int2	5	√		null
jivewfcurrstepprev	id	int8	19
jivewfcurrstepprev	previousid	int8	19
jivewfentry	id	int8	19
jivewfentry	name	varchar	20	√		null
jivewfentry	state	int4	10	√		null
jivewfhistorystep	actionid	int4	10	√		null
jivewfhistorystep	caller	varchar	100	√		null
jivewfhistorystep	duedate	timestamp	29,6	√		null
jivewfhistorystep	entryid	int8	19	√		null
jivewfhistorystep	finishdate	timestamp	29,6	√		null
jivewfhistorystep	id	int8	19
jivewfhistorystep	owner	varchar	100	√		null
jivewfhistorystep	startdate	timestamp	29,6	√		null
jivewfhistorystep	status	varchar	20	√		null
jivewfhistorystep	stepid	int4	10	√		null
jivewfhiststepprev	id	int8	19
jivewfhiststepprev	previousid	int8	19
jivewidget	bridgeid	int8	19	√		null
jivewidget	classname	varchar	255
jivewidget	remotewidgetid	int8	19	√		null
jivewidget	type	varchar	255	√		null
jivewidget	widgetid	int8	19
jivewidgetframe	containerid	int4	10
jivewidgetframe	frameid	int8	19
jivewidgetframe	frameindex	int4	10
jivewidgetframe	parentobjectid	int8	19
jivewidgetframe	parentobjecttype	int4	10
jivewidgetframe	published	int4	10
jivewidgetframe	widgetid	int8	19
jivewidgetfrmprop	frameid	int8	19
jivewidgetfrmprop	name	varchar	100
jivewidgetfrmprop	propvalue	text	2147483647
jivewikilink	creationdate	int8	19			0
jivewikilink	linkid	int8	19			0
jivewikilink	objectid	int8	19
jivewikilink	objecttype	int4	10
jivewikilink	targetanchortext	varchar	3500	√		null
jivewikilink	targetattachmentid	int8	19	√		null
jivewikilink	targetdescription	varchar	3500	√		null
jivewikilink	targetlinktype	int4	10
jivewikilink	targetobjectid	int8	19	√		null
jivewikilink	targetobjecttype	int4	10	√		null
jivewikilink	targettext	varchar	3500	√		null
jivewikilink	targeturl	varchar	3500	√		null
jivewlayout	classname	varchar	255
jivewlayout	disabled	int4	10			0
jivewlayout	layoutid	int8	19
jivewlayoutframe	layoutid	int8	19
jivewlayoutframe	parentobjectid	int8	19
jivewlayoutframe	parentobjecttype	int4	10
jivewlayoutframe	published	int4	10			0
spattachments	attachmentguid	varchar	255
spattachments	attachmentid	int8	19
spattachments	attachmenttype	int4	10
spattachments	containerid	int8	19
spattachments	containertype	int4	10
spattachments	originalfilename	varchar	2000
spattachments	originalsubmittedfiletype	varchar	255
spauthenticationtokens	authtoken	varchar	255
spauthenticationtokens	expirationdate	int8	19
spauthenticationtokens	spconnectionpropertiesid	int8	19
spconnectionproperties	claimsenabled	int8	19	√		null
spconnectionproperties	connection_type	varchar	255			'SiteCollection'::character varying
spconnectionproperties	connectionpropertiesid	int8	19
spconnectionproperties	credentialstype	varchar	50
spconnectionproperties	default_parent_site_guid	varchar	255	√		null
spconnectionproperties	default_parent_site_url	varchar	255	√		null
spconnectionproperties	description	varchar	2000
spconnectionproperties	domain	varchar	255	√		null
spconnectionproperties	everyoneprincipal	varchar	255	√		null
spconnectionproperties	fullcontrolprincipal	varchar	255	√		null
spconnectionproperties	is_default	varchar	1	√		null
spconnectionproperties	kdc	varchar	255	√		null
spconnectionproperties	password	bytea	2147483647	√		null
spconnectionproperties	registrationtoken	varchar	255	√		null
spconnectionproperties	searchenabled	int8	19	√		null
spconnectionproperties	searchengineid	int8	19	√		null
spconnectionproperties	searchexternalurl	varchar	2000	√		null
spconnectionproperties	searchiconurl	varchar	2000	√		null
spconnectionproperties	searchmaxresults	int8	19	√		null
spconnectionproperties	searchscope	varchar	2000	√		null
spconnectionproperties	searchscopetype	varchar	255	√		null
spconnectionproperties	searchstorageinstanceid	int8	19	√		null
spconnectionproperties	searchtestkeywords	varchar	255	√		null
spconnectionproperties	sharepoint_facing_address	varchar	255	√		null
spconnectionproperties	sitecollectionid	varchar	255	√		null
spconnectionproperties	sp_version	varchar	255	√		null
spconnectionproperties	spwaconnpropid_fk	int8	19	√		null
spconnectionproperties	url	varchar	2000
spconnectionproperties	username	varchar	255	√		null
spconnectionproperties	wst2005stsurl	varchar	300	√		null
spconnectionproperties	wst2005tokenexpirationdate	int8	19	√		null
spconnectionproperties	wst2005tokenvalue	bytea	2147483647	√		null
spconnectionproperties	wst2005wctx	varchar	300	√		null
spconnectionproperties	wst2005wreply	varchar	300	√		null
spconnectionproperties	wst2005wtrealm	varchar	300	√		null
spcontainers	containerid	int8	19
spcontainers	containermode	varchar	50
spcontainers	containertype	int4	10
spcontainers	remotedocuments	varchar	255	√		null
spcontainers	siteguid	varchar	255
spcontainers	siteurl	varchar	255
spcontainers	spconnectionpropertiesid	int8	19
spdocuments	documentguid	varchar	255
spdocuments	documentid	int8	19
spdocuments	documenttype	int4	10
spdocumentversions	documentid	int8	19
spdocumentversions	documenttype	int4	10
spdocumentversions	originalfilename	varchar	2000
spdocumentversions	originalsubmittedfiletype	varchar	255
spdocumentversions	sharepointversion	varchar	255
spdocumentversions	version	int4	10
spremotedocpreviewtranslation	id	varchar	100
spremotedocpreviewtranslation	modetype	int4	10
spremotedocpreviewtranslation	spfileguid	varchar	50
spremotedocpreviewtranslation	spsiteguid	varchar	50
spremotedoctranslation	containerid	int8	19
spremotedoctranslation	containertype	int4	10
spremotedoctranslation	creationdate	varchar	255	√		null
spremotedoctranslation	filename	varchar	255
spremotedoctranslation	modificationdate	varchar	255	√		null
spremotedoctranslation	objectid	int8	19
spremotedoctranslation	spguid	varchar	255
spremotedoctranslation	spuser	varchar	255
spremotedoctranslation	status	varchar	255
spremotedoctranslation	version	int4	10
spusertranslation	jiveuserid	int8	19
spusertranslation	spconnectionpropertiesid	int8	19
spusertranslation	spuserid	varchar	255
spwebappconnectionproperties	credentialstype	varchar	50
spwebappconnectionproperties	description	varchar	2000
spwebappconnectionproperties	domain	varchar	255	√		null
spwebappconnectionproperties	everyoneprincipal	varchar	255	√		null
spwebappconnectionproperties	fullcontrolprincipal	varchar	255	√		null
spwebappconnectionproperties	is_default	varchar	1	√		null
spwebappconnectionproperties	jive_facing_address	varchar	255	√		null
spwebappconnectionproperties	kdc	varchar	255	√		null
spwebappconnectionproperties	managed_path_web_application	varchar	255	√		null
spwebappconnectionproperties	new_site_creation_policy	varchar	255	√		null
spwebappconnectionproperties	password	bytea	2147483647	√		null
spwebappconnectionproperties	sp_version	varchar	255	√		null
spwebappconnectionproperties	url	varchar	2000
spwebappconnectionproperties	username	varchar	255	√		null
spwebappconnectionproperties	waconnectionpropertiesid	int8	19
spwebappconnectionproperties	wst2005stsurl	varchar	300	√		null
spwebappconnectionproperties	wst2005wctx	varchar	300	√		null
spwebappconnectionproperties	wst2005wreply	varchar	300	√		null
spwebappconnectionproperties	wst2005wtrealm	varchar	300	√		null
tshtst	testfield	int4	10	√		null