Table JiveCore700.public.jivebridgedcont Generated by
SchemaSpy
Legend: SourceForge.net
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
bridgedcontid int8 19
jivebridgedcontmsg.bridgedcontid jbridgecontmsg_bdid_fk R
jivermtbridgedcont.bridgedcontid Implied Constraint R
contentid int8 19
contenttype int8 19
origcontentid int8 19
origcontenttype int8 19
origsubject varchar 1000
origtags varchar 3500
rootmessageid int8 19
active int4 10
url varchar 255
uuid varchar 128
jiveuuid.uuid Implied Constraint R

Analyzed at Fri Dec 20 10:31 PST 2013

Indexes:
Column(s) Type Sort Constraint Name
bridgedcontid Primary key Asc jivebridgedcont_pk
contentid + contenttype Performance Asc/Asc jivebridgedhas_idx

Close relationships: