sbs6a.public contains 1585 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
jiveabuse	abuseid	int8	19
jiveabuse	abusetype	int8	19
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
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	255	√		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	gadgethash	varchar	127	√		null
jiveapp	internalname	varchar	255	√		null
jiveapp	modificationdate	int8	19
jiveapp	refreshcompleted	int8	19			(-1)
jiveapp	refreshrequested	int8	19			(-1)
jiveapp	refreshstarted	int8	19			(-1)
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	iconurl	varchar	2048	√		null
jiveappaction	modificationdate	int8	19
jiveappaction	path	varchar	2048	√		null
jiveappaction	style	varchar	255	√		null
jiveappaction	viewtarget	varchar	255	√		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
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	int4	10
jivearchivepolicy	destcontainertype	int8	19
jivearchivepolicy	objectid	int4	10
jivearchivepolicy	objecttype	int8	19
jivearchivepolicy	orgcontainerid	int4	10
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	filename	varchar	255
jiveattachment	filesize	int4	10
jiveattachment	modificationdate	int8	19
jiveattachment	objectid	int8	19	√		null
jiveattachment	objecttype	int4	10
jiveattachmentdl	attachmentid	int8	19
jiveattachmentdl	downloadcomplete	int2	5
jiveattachmentdl	downloaddate	int8	19
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	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)
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)
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
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	100	√		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
jivecontentprop	contentid	int8	19
jivecontentprop	contenttype	int8	19
jivecontentprop	modificationdate	int8	19	√		null
jivecontentprop	propname	varchar	255
jivecontentprop	propvalue	text	2147483647
jivecredential	artifactid	int8	19
jivecredential	token	bytea	2147483647
jivecredential	type	int4	10
jivecredential	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
jivedevsettings	cacheon	int2	5
jivedevsettings	creationdate	int8	19
jivedevsettings	devsettingsid	int8	19
jivedevsettings	modificationdate	int8	19
jivedevsettings	userid	int8	19
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	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	int4	10	√		null
jivedocumentprop	internaldocid	int8	19
jivedocumentprop	name	varchar	100
jivedocumentprop	propvalue	varchar	3500
jivedocumentprop	versionid	int2	5
jivedocversion	creationdate	int8	19
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	filename	varchar	255	√		null
jivedvrevartifact	filesize	int4	10
jivedvrevartifact	instanceid	varchar	255
jivedvrevartifact	modificationdate	int8	19
jivedvrevartifact	page	int4	10
jivedvrevartifact	revisionid	int8	19
jivedvrevision	creationdate	int8	19
jivedvrevision	documentclassid	int4	10
jivedvrevision	documentid	int8	19
jivedvrevision	evidocid	varchar	50	√		null
jivedvrevision	evifrozen	int4	10			0
jivedvrevision	eviprevversionid	varchar	50	√		null
jivedvrevision	eviversionid	varchar	50	√		null
jivedvrevision	filename	varchar	255
jivedvrevision	filesize	int8	19
jivedvrevision	hashbytes	varchar	255	√		null
jivedvrevision	metadata	varchar	3500	√		null
jivedvrevision	modificationdate	int8	19
jivedvrevision	origin	int4	10
jivedvrevision	packageid	int8	19	√		null
jivedvrevision	pagecount	int4	10			0
jivedvrevision	reconciled	int4	10			1
jivedvrevision	revisionid	int8	19
jivedvrevision	revisionnumber	int4	10
jivedvrevision	userid	int8	19
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
jiveextcontext	contextid	int8	19
jiveextcontext	name	varchar	100
jiveextcontext	type	int2	5
jiveexternalidentity	externalidentityid	int8	19
jiveexternalidentity	identityvalue	varchar	255
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
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	255
jivegateway	communityid	int8	19
jivegateway	disablecutoffdate	int4	10	√		null
jivegateway	exportenabled	int4	10
jivegateway	gatewayid	int8	19
jivegateway	gatewaytype	varchar	10
jivegateway	importenabled	int4	10
jivegatewayprop	gatewayid	int8	19
jivegatewayprop	name	varchar	100
jivegatewayprop	propvalue	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	100
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	creationdate	int8	19
jivei18ntext	custom	int2	5
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
jiveidentitytable	dummy	bpchar	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
jiveimageversion	imageid	int8	19
jiveimageversion	internaldocid	int8	19
jiveimageversion	versionid	int4	10
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	100	√		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
jivelicenseconfirm	accepted	int4	10
jivelicenseconfirm	confirmationbody	text	2147483647	√		null
jivelicenseconfirm	confirmationbodye	text	2147483647	√		null
jivelicenseconfirm	confirmationdate	int8	19
jivelicenseconfirm	confirmationid	int8	19
jivelicenseconfirm	remoteconfirmid	int8	19	√		null
jivelicenseconfirm	reportid	int8	19	√		null
jivelicenseconfirm	uuid	varchar	100
jivelicensereport	manual	int4	10
jivelicensereport	reportbody	text	2147483647
jivelicensereport	reportbodye	text	2147483647	√		null
jivelicensereport	reportdate	int8	19	√		null
jivelicensereport	reporter	varchar	100	√		null
jivelicensereport	reportid	int8	19
jivelicensereport	uuid	varchar	100
jivelinkobject	linkkey	varchar	255
jivelinkobject	objectid	int8	19
jivelinkobject	objecttype	int4	10
jivelocalizedprop	locale	varchar	100
jivelocalizedprop	name	varchar	100
jivelocalizedprop	propvalue	text	2147483647
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
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
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
jiveoauthaccesslog	lastaccess	int8	19	√		null
jiveoauthaccesslog	oauthtokenid	int8	19
jiveoauthclient	clientid	varchar	64
jiveoauthclient	clientsecret	varchar	127
jiveoauthclient	creationdate	int8	19
jiveoauthclient	description	varchar	1000	√		null
jiveoauthclient	modificationdate	int8	19
jiveoauthclient	name	varchar	100
jiveoauthclient	oauthclientid	int8	19
jiveoauthclientaccesstoken	accesstoken	varchar	127	√		null
jiveoauthclientaccesstoken	creationdate	int8	19
jiveoauthclientaccesstoken	expirationdate	int8	19
jiveoauthclientaccesstoken	modificationdate	int8	19
jiveoauthclientaccesstoken	oauthclientaccesstokenid	int8	19
jiveoauthclientaccesstoken	oauthclientid	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	32	√		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	userid	int8	19
jiveobjapiaccessor	accessorid	int8	19
jiveobjapiaccessor	objectid	int8	19
jiveobjapiaccessor	objecttype	int4	10
jiveobjecttag	creationdate	int8	19
jiveobjecttag	objectid	int8	19
jiveobjecttag	objecttype	int4	10
jiveobjecttag	tagid	int8	19
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
jiveocbmetadata	binarymetadataid	int8	19
jiveocbmetadata	creationdate	int8	19
jiveocbmetadata	description	varchar	2000	√		null
jiveocbmetadata	displayname	varchar	255
jiveocbmetadata	filesize	int8	19	√		null
jiveocbmetadata	instanceappid	int8	19	√		null
jiveocbmetadata	mimetype	varchar	255	√		null
jiveocbmetadata	modificationdate	int8	19
jiveocbmetadata	name	varchar	255
jiveocbmetadata	userid	int8	19
jiveocbtoken	accesstokenid	int8	19
jiveocbtoken	binarymetadataid	int8	19
jiveocbtoken	creationdate	int8	19
jiveocbtoken	expirationdate	int8	19
jiveocbtoken	modificationdate	int8	19
jiveocbtoken	token	varchar	255
jiveocbtoken	url	varchar	255
jiveocbtoken	verb	varchar	4
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
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
jivepaletteprop	image	int2	5
jivepaletteprop	modificationdate	int8	19
jivepaletteprop	paletteid	int8	19
jivepaletteprop	propkey	varchar	100
jivepaletteprop	propvalue	varchar	3500
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
jiveplugin	creationdate	int8	19
jiveplugin	data	bytea	2147483647	√		null
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
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	isvisibletoguests	int2	5
jiveprofilefield	isvisibletousers	int2	5
jiveprofilefield	name	varchar	255
jiveprofilefield	regidx	int4	10			(-1)
jiveprofilefldopt	defaultoption	int2	5
jiveprofilefldopt	fieldid	int8	19
jiveprofilefldopt	fieldvalue	varchar	255
jiveprofilefldopt	idx	int4	10
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	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
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
jivequestprogress	completiondate	int8	19	√		null
jivequestprogress	data	text	2147483647
jivequestprogress	questid	int8	19
jivequestprogress	questprogressid	int8	19
jivequestprogress	userid	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
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
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
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
jivesession	app	varchar	100
jivesession	data	bytea	2147483647	√		null
jivesession	expires	int8	19	√		null
jivesession	id	varchar	100
jivesession	lastaccess	int8	19	√		null
jivesession	maxinactive	int4	10	√		null
jivesession	valid	bpchar	1
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	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
jivestatics	creationdate	int8	19
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	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
jivestatuslevelpntsum	pointlevel	int8	19	√		null
jivestatuslevelpntsum	userid	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
jivesystemjob	beanid	varchar	1024
jivesystemjob	completedon	int8	19			0
jivesystemjob	creationdate	int8	19
jivesystemjob	jobid	varchar	255
jivesystemjob	nodeid	varchar	512	√		null
jivesystemjob	result	varchar	3500	√		null
jivesystemjob	rundate	int8	19
jivesystemjob	startedon	int8	19			0
jivesystemjob	status	int4	10
jivesystemjob	userid	int8	19
jivesystemjobprop	jobid	varchar	255
jivesystemjobprop	name	varchar	255
jivesystemjobprop	propvalue	varchar	3500
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	modificationdate	int8	19
jivetagset	name	varchar	100
jivetagset	tagsetid	int8	19
jivetagsetmap	tagid	int8	19
jivetagsetmap	tagsetid	int8	19
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
jivetypevldtrprop	name	varchar	100
jivetypevldtrprop	propvalue	varchar	3500
jivetypevldtrprop	typeid	int8	19
jiveuser	creationdate	int8	19
jiveuser	email	varchar	100
jiveuser	emailvisible	int4	10
jiveuser	federated	int4	10			0
jiveuser	firstname	varchar	100	√		null
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	100
jiveuser	usertype	int4	10			0
jiveuser	visible	int4	10			1
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
jiveuserstatus	containerid	int8	19			(-1)
jiveuserstatus	containertype	int4	10			(-1)
jiveuserstatus	creationdate	int8	19
jiveuserstatus	latitude	float8	17,17			(-1)
jiveuserstatus	longitude	float8	17,17			(-1)
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	version	int4	10
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	notifymycomm	int2	5
jivewatchsettings	receiveemails	int2	5
jivewatchsettings	receivehtmlemails	int2	5			1
jivewatchsettings	upgraded	int2	5			1
jivewatchsettings	userid	int8	19
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