Versions Compared

Old Version 2

changes.mady.by.user Søren Duusgaard

Saved on

compared with

New Version 3

changes.mady.by.user Søren Duusgaard

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column
width33%

Groups

Wiki Markup
{float:left|width=200px|background=lightgrey|border=solid blue 2px|margin=1px|padding=0px}
{children:page=Rator DB ER Diagram Navigator|depth=1|excerpt=trueindent=1px}
{float}
Column
width33%

WF_HOOKPOINT_WF_DEF

IN_PROCESS_ONLY
Column NameData TypeField LengthNot Null?Data Def.Comments

ID

NUMBER

22 

Not null 

  Primary key

WF_DEFHOOKPOINT_ID

NUMBER

  Not null  

VERSION_START

NUMBER

 

Not null

0 

VERSION_ENDWF_DEF_ID

NUMBER

 

 

0 

CHAR

1 BYTE

   
LAST_INSTANTIATEDFROM_DATE

DATE

  

Not null

 Sysdate 

PARAMETERS

VARCHAR2

1024 BYTES

Y

  
Column
width33%

New in Vs. 10 to support the introduction of the interface WfVersionable used in the rator-wf-core project.

Constraints:

constraint wf_workflow_def__id_version primary key (id, version_start),

constraint wf_workflow_def__id_versionEnd unique (id, version_end),

constraint wf_workflow_def_chk_version CHECK (nvl(version_start, 0)>=0 AND (nvl(version_end,version_start)>=version_start OR nvl(version_end,0)=0)hookpoint_wf_def_id_date_UQ unique (wf_hookpoint_id,from_date)