Table IWA_TaskElement

Process elements that are relevant to task operations

Columns

Primary Key	Name	Type	Length	Precision	Can Be Null	Default	References	Action	Hints	Comment
true	TaskElementId	BIGINT			false					Identifies the task element.
false	ProcessModelVersionId	BIGINT			false		IWA_ProcessModelVersion(ProcessModelVersionId)	ON DELETE CASCADE		References the process model version this process element belongs to.
false	ProcessElementId	VARCHAR	200		false					Identifies the process element within the Xpert.ivy project.
false	JoinPathes	INTEGER			false					The number of input pathes that are joined on this task element.
false	Kind	INTEGER			false					The process element kind. See java enumeration ch.ivyteam.ivy.workflow.TaskElementKind for possible values.

Constraints

Constraint	Name	Columns	Hints	Comment
UNIQUE	IWA_TaskElement_ProcessModelVersionIdProcessElementIdKind	ProcessModelVersionId , ProcessElementId , Kind

Indexes

Name	Columns	Hints	Comment
IWA_TaskElement_ProcessModelVersionIdIndex	ProcessModelVersionId

Referenced By

Foreign Table	Column	Comment
IWA_TaskStart	TaskElementId	References the task element this task start belongs to.
IWA_TaskEnd	TaskElementId	References the task element this task end belongs to.
IWA_TaskSwitchEvent	TaskElementId	References the task element this task switch event belongs to.

Cache

Object	Strategy
IWA_TaskElement	ALL_REMOVE_UNUSED