Table JiveCore700.public.jivewfhistorystep 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
id int8 19
jivewfcurrstepprev.previousid jwfcrstppv_pid_fk R
jivewfhiststepprev.id jwfhisstppv_id_pk R
jivewfhiststepprev.previousid jwfhisstppv_pid_fk R
jivewfentry.id Implied Constraint R
entryid int8 19  √  null
jivewfentry.id jwfhisstp_entid_fk R
stepid int4 10  √  null
actionid int4 10  √  null
owner varchar 100  √  null
startdate timestamp 29,6  √  null
finishdate timestamp 29,6  √  null
duedate timestamp 29,6  √  null
status varchar 20  √  null
caller varchar 100  √  null

Analyzed at Fri Dec 20 10:31 PST 2013

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc jwfhstep_pk
caller Performance Asc jwfhstep_c_idx
entryid Performance Asc jwfhstep_eid_idx
owner Performance Asc jwfhstep_o_idx

Close relationships  within of separation: