| Table | Object | AsAssociation | AsParent | AttributeName | BusinessClass | ClassName | CustomFields | DataType | DbDataClass | Enum | FieldForOptimisticLocking | FilterQueryDataType | HideFieldOnQuery | ParentCanBeModified | 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 | 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_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 | 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_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_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 |