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

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