SchemaSpy - Table setoopifeae.public.jiveuserinboxitem

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column	Type	Size	Nulls	Auto	Default	Children	Parents	Comments
id	bigserial	19		√	nextval('jiveuserinboxitem_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
userid	int8	19

Table contained 0 rows at Fri Jan 13 12:19 PST 2017

Indexes:

Column(s)	Type	Sort	Constraint Name
id	Primary key	Asc	jiveuserinboxitem_pk
parentid	Performance	Asc	jiveuseribxitem_pid
activityidhi + activityidlo + userid	Must be unique	Asc/Asc/Asc	jiveuserinboxitem_dx