Table JiveCore700.public.jivewfcurrentstep 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.id jwfcrstppv_id_fk R
jivewfentry.id Implied Constraint R
entryid int8 19  √  null
jivewfentry.id jwfcs_entid_fk R
stepid int2 5  √  null
actionid int2 5  √  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 jwfcs_pk
caller Performance Asc jwfcs_c_idx
entryid Performance Asc jwfcs_eid_idx
owner Performance Asc jwfcs_o_idx

Close relationships  within of separation: