|
Primary Key
|
Name
|
Type
|
Length
|
Precision
|
Can Be Null
|
Default
|
References
|
Action
|
Hints
|
Comment
|
|
true
|
NotificationDeliveryId
|
VARCHAR
|
36
|
|
false
|
|
|
|
|
Unique id of this notification transmission
|
|
false
|
NotificationId
|
VARCHAR
|
36
|
|
true
|
|
IWA_Notification(NotificationId)
|
ON DELETE SET NULL
|
MsSqlServer
|
Id of the notification
|
|
false
|
Channel
|
VARCHAR
|
100
|
|
false
|
|
|
|
|
Channel e.g. 'web' or 'mail'
|
|
false
|
ReceiverId
|
VARCHAR
|
210
|
|
false
|
|
IWA_SecurityMember(SecurityMemberId)
|
ON DELETE SET NULL
|
|
Receiver of the notification transmission
|
|
false
|
DeliveredAt
|
DATETIME
|
|
|
true
|
|
|
|
|
Timestamp when this notification has been delivered
|
|
false
|
ReadAt
|
DATETIME
|
|
|
true
|
|
|
|
|
Timestamp when the user has read the notification
|
|
false
|
Hide
|
BIT
|
|
|
false
|
|
|
|
|
Whether the notification should be shown or not
|
|
false
|
DeliveryState
|
INTEGER
|
|
|
false
|
|
|
|
Java
|
Delivery state (PENDING, ERROR, DELIVERED)
|
|
false
|
Error
|
VARCHAR
|
255
|
|
true
|
|
|
|
Java
|
Error message in case of error
|
|
false
|
ErrorTimeoutTimestamp
|
DATETIME
|
|
|
true
|
|
|
|
|
Time when the notification delivery timeouts and the state is set back from ERROR to PENDING to retry the delivery
|
|
false
|
NumberOfErrors
|
INTEGER
|
|
|
false
|
|
|
|
|
Number of time the delivery failed with an error so far
|