Table IWA_Application

Applications

Columns

Primary Key Name Type Length Precision Can Be Null Default References Action Hints Comment
true ApplicationId BIGINT false Identifies the application.
false Name VARCHAR 40 false Oracle Name of the application.
false Description VARCHAR 2000 true Java Description of the application.
false OwnerName VARCHAR 40 false Oracle Name of the owner of the web application.
false State INTEGER false The state of the web application. The states are defined in the java enumeration ch.ivyteam.ivy.application.ActivityState
false FileDirectory VARCHAR 500 false Oracle Directory where Xpert.ivy stores the files of the application.
false SecuritySystemId BIGINT false IWA_SecuritySystem(SecuritySystemId) References the security system this application belongs to.

Constraints

Constraint Name Columns Hints Comment
UNIQUE IWA_Application_NameIndex Name

Indexes

Name Columns Hints Comment
IWA_Application_SecuritySystemIdIndex SecuritySystemId

Referenced By

Foreign Table Column Comment
IWA_ProcessModel ApplicationId References the application this process model belongs to.
IWA_Library ApplicationId References the application this library belongs to.
IWA_CaseMap ApplicationId Reference the application the case map belongs to
IWA_Case ApplicationId References the application this case belongs to. This is redundant with ProcessModelId -> IWA_ProcessModel.ApplicationId and is introduced for performance reason.
IWA_Task ApplicationId References the application this task belongs to. This is redundant with CaseId->IWA_Case.ApplicationId and is introduced for performance reasons only.
IWA_WorkflowEvent ApplicationId References the application this workflow event belongs to.
IWA_IntermediateEvent ApplicationId References the application that this intermediate event belongs to.
IWA_SignalEvent ApplicationId

Oracle

Object ConvertEmptyStringToNull DeleteTriggerName
IWA_Application IWA_ApplicationDeleteTrg
Name true
OwnerName true
FileDirectory true

Cache

Object Strategy
IWA_Application ALL

Java

Object Truncate
Description true