Applications
| 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 | State | INTEGER | false | The state of the web application. The states are defined in the java enumeration ch.ivyteam.ivy.application.ActivityState | ||||||
| false | SecuritySystemId | BIGINT | false | IWA_SecuritySystem(SecuritySystemId) | References the security system this application belongs to. |
| Constraint | Name | Columns | Hints | Comment |
|---|---|---|---|---|
| UNIQUE | IWA_Application_NameIndex | Name |
| Name | Columns | Hints | Comment |
|---|---|---|---|
| IWA_Application_SecuritySystemIdIndex | SecuritySystemId |
| 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 | |
| IWA_Blob | ApplicationId | References to application to which this blob belongs to (deprecated, use SecuritySystemId) |
| Object | SecondaryKeys |
|---|---|
| IWA_Application | SecuritySystemId |
| Object | ConvertEmptyStringToNull | DeleteTriggerName |
|---|---|---|
| IWA_Application | IWA_ApplicationDeleteTrg | |
| Name | true |
| Object | Strategy |
|---|---|
| IWA_Application | ALL |