Table IWA_ProcessModelVersion

Process Model Versions represents an ivy projects

Columns

Primary Key Name Type Length Precision Can Be Null Default References Action Hints Comment
true ProcessModelVersionId BIGINT false Identifies the process model version
false ProcessModelId BIGINT false IWA_ProcessModel(ProcessModelId) ON DELETE CASCADE Java , MsSqlServer , MySql Identifies the process model this process model version belongs to.
false VersionNumber INTEGER false The version number. This number starts at 0 and is then increased by one for every new version.
false State INTEGER false The state of the process. The values of the state are defined by the java class ivyteam.webapp.workflow.Activity
false ReleaseState INTEGER false The release state of the process. The values of the state are defined by the java class ivyteam.webapp.workflow.ProcessModelVersionImpl
false ReleaseTimestamp DATETIME true Date and time when this process model version was released.
false ProjectDirectory VARCHAR 500 true The directory where the Axon Ivy project that belongs to this pmv is stored. If null the project directory is located at the standard location under the application directory.
false ProjectName VARCHAR 200 false The name of the project that belongs to this pmv
false ProjectHash VARCHAR 32 true MD5 hash of last deployed artifact.
false Changed DATETIME false Java The time the process model version was changed.

Constraints

Constraint Name Columns Hints Comment
UNIQUE IWA_ProcessModelVersion_ProcessModelVersionIdVersionNumberIndex ProcessModelId , VersionNumber

Indexes

Name Columns Hints Comment
IWA_ProcessModelVersion_ProcessModelIdIndex ProcessModelId

Referenced By

Foreign Table Column Comment
IWA_Library ProcessModelVersionId References the process model version this library belongs to
IWA_CaseMap ProcessModelVersionId Reference the process model version the case map belongs to
IWA_TaskElement ProcessModelVersionId References the process model version this process element belongs to.
IWA_Notification ProcessModelVersionId References the Process Model Version that is used to resolve notification templates. Can be null if no context is provided.

Cache

Object Strategy
IWA_ProcessModelVersion ALL

Java

Object AsParent AttributeName
ProcessModelId true
Changed lastChangeDate

MySql

Object NoReferenceUseTrigger
ProcessModelId true

MsSqlServer

Object NoReferenceUseTrigger
ProcessModelId true