db_700op_default_eae.public contains 279 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
jiveaaprop	id	bigserial	19		√	nextval('jiveaaprop_id_seq'::regclass)
jiveallstreamitem	id	bigserial	19		√	nextval('jiveallstreamitem_id_seq'::regclass)
jiveallstreamparentgroup	id	bigserial	19		√	nextval('jiveallstrmprnt_id_seq'::regclass)
jiveantimatterstreamitem	id	bigserial	19		√	nextval('jiveantistrmitm_id_seq'::regclass)
jiveantimatterstreamparent	id	bigserial	19		√	nextval('jiveantistrmprnt_id_seq'::regclass)
jiveaprop	id	bigserial	19		√	nextval('jiveaprop_id_seq'::regclass)
jivecontentbody	id	bigserial	19		√	nextval('jivecontentbody_id_seq'::regclass)
jivecontextstreamitem	id	bigserial	19		√	nextval('jivecontextstreamitem_id_seq'::regclass)
jivecontextstreamparentgroup	id	bigserial	19		√	nextval('jivectxtstrmprnt_id_seq'::regclass)
jiveprofilestreamitem	id	bigserial	19		√	nextval('jiveprofilestreamitem_id_seq'::regclass)
jiveprofilestreamparentgroup	id	bigserial	19		√	nextval('jivepflstrmprnt_id_seq'::regclass)
jiverecentuserstreamupdate	id	bigserial	19		√	nextval('jiverctusrstrmup_id_seq'::regclass)
jiverecommendationscores	id	bigserial	19		√	nextval('jiverecoscores_id_seq'::regclass)
jiverejectedreco	id	bigserial	19		√	nextval('jiverejectedreco_id_seq'::regclass)
jivestreamassociation	id	bigserial	19		√	nextval('jivestreamassoc_id_seq'::regclass)
jivestreamconfiguration	id	bigserial	19		√	nextval('jivestrmcfg_id_seq'::regclass)
jivetraceractivity	id	bigserial	19		√	nextval('jivetraceractivity_id_seq'::regclass)
jiveuseractivity	id	bigserial	19		√	nextval('jiveuseractivity_id_seq'::regclass)
jiveuserexclusions	id	bigserial	19		√	nextval('jiveusrexcl_id_seq'::regclass)
jiveuserinboxitem	id	bigserial	19		√	nextval('jiveuserinboxitem_id_seq'::regclass)
jiveuserinboxparentgroup	id	bigserial	19		√	nextval('jiveusribxprnt_id_seq'::regclass)
jiveuserobjuntracking	id	bigserial	19		√	nextval('jiveuserobjuntracking_id_seq'::regclass)
jiveuserrecommendations	id	bigserial	19		√	nextval('jiveusrreco_id_seq'::regclass)
jiveuserstreamitem	id	bigserial	19		√	nextval('jiveuserstreamitem_id_seq'::regclass)
jiveuserstreamparentgroup	id	bigserial	19		√	nextval('jiveusrstrmprnt_id_seq'::regclass)
jiveusertorecommendationlookup	id	bigserial	19		√	nextval('jiveusrtorecolkup_id_seq'::regclass)
jivefirehose	activity	bytea	2147483647
jivestreamconfiguration	receiveemails	int2	5
jiveactivityfirehose	activitycontexttype	int4	10	√		null
jiveallstreamitem	activitycontexttype	int4	10
jiveantimatterstreamitem	activitycontexttype	int4	10
jivecontextstreamitem	activitycontexttype	int4	10
jiveprofilestreamitem	activitycontexttype	int4	10
jiverecentuserstreamupdate	activitycontexttype	int4	10
jivetraceractivity	activitycontexttype	int4	10
jiveuseractivity	activitycontexttype	int4	10
jiveuserinboxitem	activitycontexttype	int4	10
jiveuserstreamitem	activitycontexttype	int4	10
jiveactivityfirehose	activitydescriptortype	int4	10	√		null
jiveallstreamitem	activitydescriptortype	int4	10
jiveantimatterstreamitem	activitydescriptortype	int4	10
jivecontextstreamitem	activitydescriptortype	int4	10
jiveprofilestreamitem	activitydescriptortype	int4	10
jiverecentuserstreamupdate	activitydescriptortype	int4	10
jivetraceractivity	activitydescriptortype	int4	10
jiveuseractivity	activitydescriptortype	int4	10
jiveuserinboxitem	activitydescriptortype	int4	10
jiveuserstreamitem	activitydescriptortype	int4	10
jiveactivityfirehose	activityparenttype	int4	10	√		null
jiveallstreamitem	activityparenttype	int4	10
jiveantimatterstreamitem	activityparenttype	int4	10
jivecontextstreamitem	activityparenttype	int4	10
jiveprofilestreamitem	activityparenttype	int4	10
jiverecentuserstreamupdate	activityparenttype	int4	10
jivetraceractivity	activityparenttype	int4	10
jiveuseractivity	activityparenttype	int4	10
jiveuserinboxitem	activityparenttype	int4	10
jiveuserstreamitem	activityparenttype	int4	10
jiveactivityfirehose	activitytype	int4	10
jiveallstreamitem	activitytype	int4	10
jiveantimatterstreamitem	activitytype	int4	10
jivecontextstreamitem	activitytype	int4	10
jiveprofilestreamitem	activitytype	int4	10
jiverecentuserstreamupdate	activitytype	int4	10
jivetraceractivity	activitytype	int4	10
jiveuseractivity	activitytype	int4	10
jiveuserinboxitem	activitytype	int4	10
jiveuserstreamitem	activitytype	int4	10
jivecontextstreamparentgroup	contexttype	int4	10
jivemovedcontent	contexttype	int4	10
jiveuserexclusions	contexttype	int4	10
jiveuserexclusions	exclusiontype	int4	10
jiveuserinboxparentgroup	isread	int4	10
jiveallstreamparentgroup	objecttype	int4	10
jiveantimatterstreamparent	objecttype	int4	10
jivecontextstreamparentgroup	objecttype	int4	10
jivemovedcontent	objecttype	int4	10
jiveprofilestreamparentgroup	objecttype	int4	10
jiverejectedreco	objecttype	int4	10
jivestreamassociation	objecttype	int4	10
jiveuserexclusions	objecttype	int4	10
jiveuserinboxparentgroup	objecttype	int4	10
jiveuserobjuntracking	objecttype	int4	10
jiveuserstreamparentgroup	objecttype	int4	10
jiverecentuserstreamupdate	processingstate	int4	10
jiveaprop	propertytype	int4	10
jivestreamassociation	receiveemails	int4	10
jiveuserrecommendations	recommendedtype	int4	10
jivestreamassociation	source	int4	10
jivestreamconfiguration	source	int4	10
jiveuserexclusions	sourcetype	int4	10
jiveuserstreamparentgroup	tracked	int4	10
jiveuserinboxparentgroup	untracked	int4	10
jiveupgradeversion	version	int4	10
jiveactivityfirehose	activitycontextid	int8	19	√		null
jiveallstreamitem	activitycontextid	int8	19
jiveantimatterstreamitem	activitycontextid	int8	19
jivecontextstreamitem	activitycontextid	int8	19
jiveprofilestreamitem	activitycontextid	int8	19
jiverecentuserstreamupdate	activitycontextid	int8	19
jivetraceractivity	activitycontextid	int8	19
jiveuseractivity	activitycontextid	int8	19
jiveuserinboxitem	activitycontextid	int8	19
jiveuserstreamitem	activitycontextid	int8	19
jiveactivityfirehose	activitydescriptorid	int8	19	√		null
jiveallstreamitem	activitydescriptorid	int8	19
jiveantimatterstreamitem	activitydescriptorid	int8	19
jivecontextstreamitem	activitydescriptorid	int8	19
jiveprofilestreamitem	activitydescriptorid	int8	19
jiverecentuserstreamupdate	activitydescriptorid	int8	19
jivetraceractivity	activitydescriptorid	int8	19
jiveuseractivity	activitydescriptorid	int8	19
jiveuserinboxitem	activitydescriptorid	int8	19
jiveuserstreamitem	activitydescriptorid	int8	19
jiveaaprop	activityidhi	int8	19
jiveactivityfirehose	activityidhi	int8	19
jiveactivitypipeline	activityidhi	int8	19
jiveallstreamitem	activityidhi	int8	19
jiveantimatterstreamitem	activityidhi	int8	19
jiveaprop	activityidhi	int8	19
jivecontextstreamitem	activityidhi	int8	19
jivefirehose	activityidhi	int8	19
jiveprofilestreamitem	activityidhi	int8	19
jiverecentuserstreamupdate	activityidhi	int8	19
jivetraceractivity	activityidhi	int8	19
jiveuseractivity	activityidhi	int8	19
jiveuserinboxitem	activityidhi	int8	19
jiveuserstreamitem	activityidhi	int8	19
jiveaaprop	activityidlo	int8	19
jiveactivityfirehose	activityidlo	int8	19
jiveactivitypipeline	activityidlo	int8	19
jiveallstreamitem	activityidlo	int8	19
jiveantimatterstreamitem	activityidlo	int8	19
jiveaprop	activityidlo	int8	19
jivecontextstreamitem	activityidlo	int8	19
jivefirehose	activityidlo	int8	19
jiveprofilestreamitem	activityidlo	int8	19
jiverecentuserstreamupdate	activityidlo	int8	19
jivetraceractivity	activityidlo	int8	19
jiveuseractivity	activityidlo	int8	19
jiveuserinboxitem	activityidlo	int8	19
jiveuserstreamitem	activityidlo	int8	19
jiveactivityfirehose	activityparentid	int8	19	√		null
jiveallstreamitem	activityparentid	int8	19
jiveantimatterstreamitem	activityparentid	int8	19
jivecontextstreamitem	activityparentid	int8	19
jiveprofilestreamitem	activityparentid	int8	19
jiverecentuserstreamupdate	activityparentid	int8	19
jivetraceractivity	activityparentid	int8	19
jiveuseractivity	activityparentid	int8	19
jiveuserinboxitem	activityparentid	int8	19
jiveuserstreamitem	activityparentid	int8	19
jiveactivityfirehose	activitytime	int8	19
jiveactivitypipeline	activitytime	int8	19
jiveallstreamitem	activitytime	int8	19
jiveantimatterstreamitem	activitytime	int8	19
jivecontextstreamitem	activitytime	int8	19
jivefirehose	activitytime	int8	19
jivemovedcontent	activitytime	int8	19
jiveprofilestreamitem	activitytime	int8	19
jiverecentuserstreamupdate	activitytime	int8	19
jivetraceractivity	activitytime	int8	19
jiveuseractivity	activitytime	int8	19
jiveuserinboxitem	activitytime	int8	19
jiveuserstreamitem	activitytime	int8	19
jiveactivityfirehose	activityuserid	int8	19
jiveallstreamitem	activityuserid	int8	19
jiveantimatterstreamitem	activityuserid	int8	19
jivecontextstreamitem	activityuserid	int8	19
jiveprofilestreamitem	activityuserid	int8	19
jiverecentuserstreamupdate	activityuserid	int8	19
jivetraceractivity	activityuserid	int8	19
jiveuseractivity	activityuserid	int8	19
jiveuserinboxitem	activityuserid	int8	19
jiveuserstreamitem	activityuserid	int8	19
jivelastseen	aftertime	int8	19	√		null
jivelastseen	beforetime	int8	19	√		null
jiveactivitycontent	bodyid	int8	19
jivecontextstreamparentgroup	contextid	int8	19
jivemovedcontent	contextid	int8	19
jiveuserexclusions	contextid	int8	19
jiverejectedreco	createddate	int8	19
jivestreamconfiguration	createddate	int8	19
jiveuserrecommendations	createddate	int8	19
jivequeuestatistics	dropped	int8	19
jiverecentuserstreamupdate	lastprocesstime	int8	19
jivelastseen	markallreadtime	int8	19	√		null
jivestreamconfiguration	modifieddate	int8	19
jiveallstreamparentgroup	objectid	int8	19
jiveantimatterstreamparent	objectid	int8	19
jivecontentbody	objectid	int8	19
jivecontextstreamparentgroup	objectid	int8	19
jivemovedcontent	objectid	int8	19
jiveprofilestreamparentgroup	objectid	int8	19
jiverejectedreco	objectid	int8	19
jivestreamassociation	objectid	int8	19
jiveuserexclusions	objectid	int8	19
jiveuserinboxparentgroup	objectid	int8	19
jiveuserobjuntracking	objectid	int8	19
jiveuserstreamparentgroup	objectid	int8	19
jivecontentbody	objecttype	int8	19
jiveallstreamitem	parentid	int8	19
jiveantimatterstreamitem	parentid	int8	19
jivecontextstreamitem	parentid	int8	19
jiveprofilestreamitem	parentid	int8	19
jivetraceractivity	parentid	int8	19
jiveuserinboxitem	parentid	int8	19
jiveuserstreamitem	parentid	int8	19
jiveallstreamparentgroup	parenttime	int8	19
jiveantimatterstreamparent	parenttime	int8	19
jivecontextstreamparentgroup	parenttime	int8	19
jiveprofilestreamparentgroup	parenttime	int8	19
jiveuserinboxparentgroup	parenttime	int8	19
jiveuserstreamparentgroup	parenttime	int8	19
jiveuserinboxparentgroup	prevreadtracktime	int8	19
jivequeuestatistics	processed	int8	19
jiveaprop	propertyid	int8	19
jiveuserinboxparentgroup	readtracktime	int8	19
jivelastseen	recencytime	int8	19
jiverecommendationscores	recommendationid	int8	19
jiveuserrecommendations	recommendedid	int8	19
jivecontentbody	senttorecommender	int8	19
jiveuserexclusions	sourceid	int8	19
jivestreamassociation	streamid	int8	19
jiverecentuserstreamupdate	takeableaftertime	int8	19			0
jivetaskelection	tasktime	int8	19
jiveuserexclusions	time	int8	19
jivelastseen	unreadtime	int8	19	√		null
jiverecentuserstreamupdate	updatetime	int8	19
jiveantimatterstreamitem	userid	int8	19
jiveantimatterstreamparent	userid	int8	19
jivelastseen	userid	int8	19
jiveprofilestreamparentgroup	userid	int8	19
jiverejectedreco	userid	int8	19
jivestreamassociation	userid	int8	19
jivestreamconfiguration	userid	int8	19
jivetraceractivity	userid	int8	19
jiveuserexclusions	userid	int8	19
jiveuserinboxitem	userid	int8	19
jiveuserinboxparentgroup	userid	int8	19
jiveuserobjuntracking	userid	int8	19
jiveuserstreamitem	userid	int8	19
jiveuserstreamparentgroup	userid	int8	19
jiveusertorecommendationlookup	userid	int8	19
jiveuserrecommendations	confidence	numeric	131089
jiverecommendationscores	maxrank	numeric	131089
jiverecommendationscores	minrank	numeric	131089
jiverecommendationscores	rank	numeric	131089
jiveuserrecommendations	rank	numeric	131089
jiveuserstreamparentgroup	score	numeric	131089
jiverecommendationscores	weight	numeric	131089
jiveactivityfirehose	activityaddproperties	text	2147483647	√		null
jiveactivityfirehose	activityproperties	text	2147483647	√		null
jiveactivitypipeline	authors	text	2147483647	√		null
jivecontentbody	contentbody	text	2147483647
jiveactivitypipeline	hiders	text	2147483647	√		null
jiveactivitypipeline	participants	text	2147483647	√		null
jiveinstanceproperty	propvalue	text	2147483647
jiverecentuserstreamupdate	users	text	2147483647
jiveactivityfirehose	activitylocalecode	varchar	32	√		null
jiveupgradeversion	name	varchar	50
jiveactivitycontent	activityid	varchar	255
jiveactivityfirehose	activitysystemid	varchar	255
jivestreamconfiguration	name	varchar	255	√		null
jivenodeproperty	nodeid	varchar	255
jiverecentuserstreamupdate	processingnodeid	varchar	255	√		null
jiveaaprop	propname	varchar	255
jiveaprop	propname	varchar	255
jiveinstanceproperty	propname	varchar	255
jivenodeproperty	propname	varchar	255
jiveaaprop	propvalue	varchar	255
jiveusertorecommendationlookup	querykey	varchar	255
jivequeuestatistics	queuename	varchar	255
jiverecommendationscores	rankname	varchar	255
jiveuserrecommendations	recoid	varchar	255
jiveusertorecommendationlookup	recoid	varchar	255
jivetaskelection	taskname	varchar	255
jivetaskelection	tasknodeid	varchar	255
jivenodeproperty	propvalue	varchar	512	√		null