WF_WORKFLOW_DEF

Column Name	Data Type	Field Length	Not Null?	Data Def.
ID	NUMBER	22	Not null
WF_DEF_ID	NUMBER
VERSION_START	NUMBER		Not null	0
VERSION_END	NUMBER			0
IN_PROCESS_ONLY	CHAR	1 BYTE
LAST_INSTANTIATED	DATE
PARAMETERS	VARCHAR2	1024 BYTES	Y

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))

Core Database