Table IWA_Notification

Notification

Columns

Primary Key Name Type Length Precision Can Be Null Default References Action Hints Comment
true NotificationId VARCHAR 36 false Unique id of this notification
false Kind VARCHAR 100 false Notification kind e.g. 'new-task'
false Payload CLOB false Java JSON formatted payload
false SecuritySystemId BIGINT false IWA_SecuritySystem(SecuritySystemId) ON DELETE CASCADE Security System ID
false ProcessModelVersionId BIGINT true IWA_ProcessModelVersion(ProcessModelVersionId) ON DELETE SET NULL References the Process Model Version that is used to resolve notification templates. Can be null if no context is provided.
false Template VARCHAR 255 true Path of the template in the project
false CreatedAt DATETIME false Timestamp when this notification has been created
false IsUshered BIT false Are the notification deliveries already ushered (created) or not

Indexes

Name Columns Hints Comment
IWA_Notification_KindIndex Kind
IWA_Notification_SecuritySystemIdIndex SecuritySystemId
IWA_Notification_ProcessModelVersionIdIndex ProcessModelVersionId
IWA_Notification_CreatedAtIndex CreatedAt

Referenced By

Foreign Table Column Comment
IWA_NotificationReceiver NotificationId Id of the notification
IWA_NotificationDelivery NotificationId Id of the notification

Java

Object BusinessClass DataType DbDataClass QueryExecutorProviderClass
IWA_Notification ch.ivyteam.ivy.notification.Notification ch.ivyteam.ivy.notification.internal.db.DbNotificationData ch.ivyteam.ivy.notification.query.impl.NotificationQueryExecutorProvider
Payload String

Cache

Object Strategy
IWA_Notification ALL_REMOVE_UNUSED