| Table | Object | AsAssociation | AsParent | AttributeName | BusinessClass | ClassName | CustomFields | DataType | DbDataClass | Enum | FieldForOptimisticLocking | FilterQueryDataType | HideFieldOnQuery | ParentCanBeModified | QueryClassPublicAPI | QueryClassWithGroupFunction | QueryExecutorProviderClass | SecondaryKeys | SecurityMemberLegacyFields | Truncate |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| IWA_SystemProperty | PropertyValue | String | ||||||||||||||||||
| IWA_Application | IWA_Application | SecuritySystemId | ||||||||||||||||||
| IWA_ProcessModel | ApplicationId | true | ||||||||||||||||||
| IWA_ProcessModelVersion | ProcessModelId | true | ||||||||||||||||||
| IWA_ProcessModelVersion | Changed | lastChangeDate | ||||||||||||||||||
| IWA_Library | Provider | true | ||||||||||||||||||
| IWA_Library | Name | true | ||||||||||||||||||
| IWA_Library | Description | String | true | |||||||||||||||||
| IWA_CaseMap | Model | String | ||||||||||||||||||
| IWA_SecurityMember | Type | ch.ivyteam.ivy.security.internal.securitymember.SecurityMemberType | ||||||||||||||||||
| IWA_Role | DisplayDescriptionTemplate | true | ||||||||||||||||||
| IWA_Role | ParentSecurityMemberId | true | true | |||||||||||||||||
| IWA_RoleProperty | SecurityMemberId | true | ||||||||||||||||||
| IWA_RoleProperty | PropertyValue | String | ||||||||||||||||||
| IWA_RoleRoleMember | IWA_RoleRoleMember | true | ||||||||||||||||||
| IWA_User | IWA_User | ch.ivyteam.ivy.security.IUser | ch.ivyteam.ivy.security.internal.db.DbUserData | true | true | ch.ivyteam.ivy.security.internal.user.query.UserQueryExecutorProvider | ||||||||||||||
| IWA_User | UserId | true | ||||||||||||||||||
| IWA_User | UserPassword | passwordHash | true | |||||||||||||||||
| IWA_User | SecuritySystemId | true | ||||||||||||||||||
| IWA_User | ExternalSecurityName | true | ||||||||||||||||||
| IWA_User | Language | true | ||||||||||||||||||
| IWA_User | FormattingLanguage | true | ||||||||||||||||||
| IWA_User | State | ch.ivyteam.ivy.security.internal.user.UserState | true | |||||||||||||||||
| IWA_UserRole | IWA_UserRole | true | ||||||||||||||||||
| IWA_UserProperty | SecurityMemberId | true | ||||||||||||||||||
| IWA_UserProperty | PropertyValue | String | ||||||||||||||||||
| IWA_UserAbsence | SecurityMemberId | true | ||||||||||||||||||
| IWA_UserAbsence | Description | true | ||||||||||||||||||
| IWA_UserSubstitute | SecurityMemberId | true | ||||||||||||||||||
| IWA_UserSubstitute | Description | true | ||||||||||||||||||
| IWA_UserSubstitute | SubstitutionType | ch.ivyteam.ivy.security.SubstitutionType | ||||||||||||||||||
| IWA_Case | IWA_Case | ch.ivyteam.ivy.workflow.ICase | true | SecuritySystemId,ModifiedTimestamp,UUID | true | |||||||||||||||
| IWA_Case | Kind | ch.ivyteam.ivy.workflow.internal.caze.CaseKind | ||||||||||||||||||
| IWA_Case | ProcessModelId | true | ||||||||||||||||||
| IWA_Case | WorkingTime | NUMBER | ||||||||||||||||||
| IWA_Case | BusinessRuntime | NUMBER | ||||||||||||||||||
| IWA_Case | State | ch.ivyteam.ivy.workflow.CaseState | ||||||||||||||||||
| IWA_Case | BusinessState | ch.ivyteam.ivy.workflow.caze.CaseBusinessState | ||||||||||||||||||
| IWA_Case | Priority | ch.ivyteam.ivy.workflow.WorkflowPriority | ||||||||||||||||||
| IWA_CaseOwner | IWA_CaseOwner | true | ||||||||||||||||||
| IWA_CaseLocalized | CaseId | true | ||||||||||||||||||
| IWA_CaseLocalized | Name | true | ||||||||||||||||||
| IWA_CaseLocalized | Description | String | true | |||||||||||||||||
| IWA_Task | IWA_Task | ch.ivyteam.ivy.workflow.ITask | true | SecuritySystemId,ModifiedTimestamp,UUID | true | |||||||||||||||
| IWA_Task | CaseId | true | ||||||||||||||||||
| IWA_Task | ExpiryPriority | ch.ivyteam.ivy.workflow.WorkflowPriority | ||||||||||||||||||
| IWA_Task | State | ch.ivyteam.ivy.workflow.TaskState | ||||||||||||||||||
| IWA_Task | BusinessState | ch.ivyteam.ivy.workflow.task.TaskBusinessState | ||||||||||||||||||
| IWA_Task | OriginalPriority | ch.ivyteam.ivy.workflow.WorkflowPriority | ||||||||||||||||||
| IWA_Task | Priority | ch.ivyteam.ivy.workflow.WorkflowPriority | ||||||||||||||||||
| IWA_Task | WorkingTime | NUMBER | ||||||||||||||||||
| IWA_Task | BusinessRuntime | NUMBER | ||||||||||||||||||
| IWA_TaskLocalized | TaskId | true | ||||||||||||||||||
| IWA_TaskLocalized | Name | true | ||||||||||||||||||
| IWA_TaskLocalized | Description | String | true | |||||||||||||||||
| IWA_WorkflowEvent | IWA_WorkflowEvent | ch.ivyteam.ivy.workflow.IWorkflowEvent | ch.ivyteam.ivy.workflow.internal.db.DbWorkflowEventData | true | ch.ivyteam.ivy.workflow.internal.query.WorkflowEventQueryExecutorProvider | |||||||||||||||
| IWA_WorkflowEvent | CaseId | true | ||||||||||||||||||
| IWA_WorkflowEvent | AdditionalInfo1 | true | ||||||||||||||||||
| IWA_WorkflowEvent | AdditionalInfo2 | true | ||||||||||||||||||
| IWA_WorkflowEvent | AdditionalInfo3 | true | ||||||||||||||||||
| IWA_WorkflowEvent | AdditionalInfo4 | true | ||||||||||||||||||
| IWA_WorkflowEvent | AdditionalInfo5 | true | ||||||||||||||||||
| IWA_WorkflowEvent | CaseState | ch.ivyteam.ivy.workflow.CaseState | ||||||||||||||||||
| IWA_WorkflowEvent | TaskState | ch.ivyteam.ivy.workflow.TaskState | ||||||||||||||||||
| IWA_CaseMapEvent | BusinessCaseId | true | ||||||||||||||||||
| IWA_CaseMapEvent | Kind | ch.ivyteam.ivy.casemap.runtime.repo.restricted.CaseMapEventKind | ||||||||||||||||||
| IWA_CaseMapEvent | ProcessingState | ch.ivyteam.ivy.casemap.runtime.repo.restricted.ProcessingState | ||||||||||||||||||
| IWA_CaseMapEvent | ProcessingErrorMessage | true | ||||||||||||||||||
| IWA_IntermediateEvent | IWA_IntermediateEvent | ch.ivyteam.ivy.workflow.IIntermediateEvent | ch.ivyteam.ivy.workflow.internal.db.DbIntermediateEventData | true | ch.ivyteam.ivy.workflow.internal.query.IntermediateEventQueryExecutorProvider | |||||||||||||||
| IWA_Note | Note | String | ||||||||||||||||||
| IWA_TaskNote | IWA_TaskNote | true | ||||||||||||||||||
| IWA_CaseNote | IWA_CaseNote | true | ||||||||||||||||||
| IWA_TaskCustomStringField | TaskId | true | ||||||||||||||||||
| IWA_TaskCustomTextField | TaskId | true | ||||||||||||||||||
| IWA_TaskCustomTextField | Value | String | ||||||||||||||||||
| IWA_TaskCustomNumberField | TaskId | true | ||||||||||||||||||
| IWA_TaskCustomTimestampField | TaskId | true | ||||||||||||||||||
| IWA_CaseCustomStringField | CaseId | true | ||||||||||||||||||
| IWA_CaseCustomTextField | CaseId | true | ||||||||||||||||||
| IWA_CaseCustomTextField | Value | String | ||||||||||||||||||
| IWA_CaseCustomNumberField | CaseId | true | ||||||||||||||||||
| IWA_CaseCustomTimestampField | CaseId | true | ||||||||||||||||||
| IWA_UserLocation | SecurityMemberId | true | ||||||||||||||||||
| IWA_TaskLocation | TaskId | true | ||||||||||||||||||
| IWA_TaskSignalEventReceiver | IWA_TaskSignalEventReceiver | ch.ivyteam.ivy.workflow.signal.ITaskBoundarySignalEventReceiver | TaskBoundarySignalEventReceiver | |||||||||||||||||
| IWA_TaskSignalEventReceiver | WaitingTaskId | true | ||||||||||||||||||
| IWA_SignalEvent | IWA_SignalEvent | ch.ivyteam.ivy.workflow.signal.ISignalEvent | ||||||||||||||||||
| IWA_SignalEvent | SecuritySystemId | true | ||||||||||||||||||
| IWA_Language | SecuritySystemId | true | ||||||||||||||||||
| IWA_PermissionGroup | ParentPermissionGroupId | true | ||||||||||||||||||
| IWA_AccessControl | SecurityDescriptorId | true | ||||||||||||||||||
| IWA_PermissionGroupPermission | IWA_PermissionGroupPermission | true | ||||||||||||||||||
| IWA_PermissionGroupPermission | PermissionGroupId | true | ||||||||||||||||||
| IWA_Blob | IWA_Blob | ch.ivyteam.ivy.blob.storage.core.Blob | ch.ivyteam.ivy.blob.storage.core.db.DbBlobData | ch.ivyteam.ivy.blob.storage.core.impl.BlobQueryExecutorProvider | ||||||||||||||||
| IWA_Blob | Description | true | ||||||||||||||||||
| IWA_BusinessData | Version | true | ||||||||||||||||||
| IWA_BusinessData | ObjectValue | String | ||||||||||||||||||
| IWA_Notification | IWA_Notification | ch.ivyteam.ivy.notification.Notification | ch.ivyteam.ivy.notification.internal.db.DbNotificationData | ch.ivyteam.ivy.notification.query.impl.NotificationQueryExecutorProvider | ||||||||||||||||
| IWA_Notification | Payload | String | ||||||||||||||||||
| IWA_NotificationReceiver | IWA_NotificationReceiver | true | ||||||||||||||||||
| IWA_NotificationDelivery | IWA_NotificationDelivery | ch.ivyteam.ivy.notification.delivery.NotificationDelivery | ch.ivyteam.ivy.notification.internal.db.DbNotificationDeliveryData | ch.ivyteam.ivy.notification.delivery.query.impl.NotificationDeliveryQueryExecutorProvider | ||||||||||||||||
| IWA_NotificationDelivery | DeliveryState | ch.ivyteam.ivy.notification.delivery.DeliveryState | ||||||||||||||||||
| IWA_NotificationDelivery | Error | true |