SchemaSpy - Table eae6.public.jiveallstreamitem

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Auto	Default
id	bigserial	19	√	nextval('jiveallstreamitem_id_seq'::regclass)
activitycontextid	int8	19
activitycontexttype	int4	10
activitydescriptorid	int8	19
activitydescriptortype	int4	10
activityidhi	int8	19
activityidlo	int8	19
activityparentid	int8	19
activityparenttype	int4	10
activitytime	int8	19
activitytype	int4	10
activityuserid	int8	19
parentid	int8	19

Table contained 0 rows at Fri Sep 07 10:00 PDT 2012

Indexes:

Column(s)	Type	Sort	Constraint Name
id	Primary key	Asc	jiveallstreamitem_pk
activityidhi + activityidlo + parentid	Must be unique	Asc/Asc/Asc	jiveallstreamitem_dx
parentid	Performance	Asc	jiveallstreamitem_pid