Table IWA_ProcessModel

Process Models

Columns

Primary Key	Name	Type	Length	Precision	Can Be Null	Default	References	Action	Hints	Comment
true	ProcessModelId	BIGINT			false					Identifies the process model.
false	Name	VARCHAR	40		false				Oracle	Name of the process model. Identifies the process within a application.
false	State	INTEGER			false					The state of the process. The values of the state are defined by the java class ch.ivyteam.ivy.application.ActivityState
false	ApplicationId	BIGINT			false		IWA_Application(ApplicationId)	ON DELETE SET NULL	Java , MsSqlServer , MySql , Oracle	References the application this process model belongs to.

Constraints

Constraint	Name	Columns	Hints	Comment
UNIQUE	IWA_ProcessModel_AppIdNameIndex	ApplicationId , Name

Indexes

Name	Columns	Hints	Comment
IWA_ProcessModel_ApplicationIdIndex	ApplicationId

Referenced By

Foreign Table	Column	Comment
IWA_ProcessModelVersion	ProcessModelId	Identifies the process model this process model version belongs to.
IWA_Case	ProcessModelId	References the process model this case belongs to.
IWA_Task	ProcessModelId	References the process model this task belongs to. This is redundant with CaseId -> IWA_Case.ProcessModelId and is introduced for performance reasons only.

Cache

Object	Strategy
IWA_ProcessModel	ALL

Oracle

Object	ConvertEmptyStringToNull	NoReferenceUseTrigger
Name	true
ApplicationId		true

Java

Object	AsParent
ApplicationId	true

MySql

Object	NoReferenceUseTrigger
ApplicationId	true

MsSqlServer

Object	NoReferenceUseTrigger
ApplicationId	true