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 SET NULL Security System ID
false ReceiverId VARCHAR 210 false IWA_SecurityMember(SecurityMemberId) ON DELETE SET NULL Receiver of the notification
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_ReceiverIdIndex ReceiverId
IWA_Notification_CreatedAtIndex CreatedAt

Referenced By

Foreign Table Column Comment
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