Table JiveCore700.public.jiveannounce 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
announcementid int8 19
jiveannounceprop.announcementid jap_aid_fk R
objecttype int4 10
objectid int8 19  √  null
userid int8 19
jiveuser.userid Implied Constraint R
subject varchar 255
body text 2147483647
startdate int8 19
enddate int8 19  √  null
status int4 10
minorcreateedit int2 5 0
modificationdate int8 19 0
creationdate int8 19 0
subjecturl varchar 3500  √  null
sortkey int4 10 0

Analyzed at Fri Dec 20 10:31 PST 2013

Indexes:
Column(s) Type Sort Constraint Name
announcementid Primary key Asc jiveannounce_pk
objecttype + objectid Performance Asc/Asc jvannnc_cntnr_idx
enddate Performance Asc jvannnc_edate_idx
startdate Performance Asc jvannnc_sdate_idx
userid Performance Asc jvannnc_user_idx

Close relationships: