Table JiveCore700.public.jiveptask 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
taskid int8 19
jiveptaskprop.taskid jptaskp_tid_fk R
jivetaskqueue.taskid Implied Constraint R
parenttaskid int8 19 0
parentobjecttype int4 10
parentobjectid int8 19
subject varchar 3500
body varchar 3500  √  null
userid int8 19  √  null
jiveuser.userid Implied Constraint R
assignorid int8 19  √  null
ownerid int8 19  √  null
jivecnxtsvcowner.ownerid Implied Constraint R
creationdate int8 19
modificationdate int8 19
duedate int8 19  √  null
duedatenull int4 10
completed int4 10

Analyzed at Fri Dec 20 10:31 PST 2013

Indexes:
Column(s) Type Sort Constraint Name
taskid Primary key Asc jiveptask_pk
duedate + duedatenull Performance Asc/Asc jiveptask_ddn_idx
ownerid Performance Asc jiveptask_oid_idx
parenttaskid Performance Asc jiveptask_prnt_idx

Close relationships: