Table JiveCore700.public.jivewikilink 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
linkid int8 19 0
objecttype int4 10
objectid int8 19
targetlinktype int4 10
targetobjecttype int4 10  √  null
targetobjectid int8 19  √  null
targetattachmentid int8 19  √  null
targeturl varchar 3500  √  null
targettext varchar 3500  √  null
targetdescription varchar 3500  √  null
targetanchortext varchar 3500  √  null
creationdate int8 19 0

Analyzed at Fri Dec 20 10:31 PST 2013

Indexes:
Column(s) Type Sort Constraint Name
linkid Primary key Asc jivewl_id_pk
objecttype + objectid Performance Asc/Asc jivewl_otypid_idx
targetobjecttype + targetobjectid Performance Asc/Asc jivewl_ttypid_idx
targeturl Performance Asc jvwklnk_trgturl_idx