Notification Subscription
| Primary Key | Name | Type | Length | Precision | Can Be Null | Default | References | Action | Hints | Comment |
|---|---|---|---|---|---|---|---|---|---|---|
| true | NotificationSubscriptionId | BIGINT | false | Unique id of this notification subscription | ||||||
| false | Channel | VARCHAR | 100 | false | Channel e.g. 'web' or 'mail' | |||||
| false | Kind | VARCHAR | 100 | false | Notification kind e.g. 'new-task' | |||||
| false | SubscriberId | VARCHAR | 210 | false | IWA_SecurityMember(SecurityMemberId) | ON DELETE CASCADE | Subscriber of the notification | |||
| false | Subscribed | BIT | false | Whether the notification is subscribed or not |
| Constraint | Name | Columns | Hints | Comment |
|---|---|---|---|---|
| UNIQUE | IWA_NotificationSubscription_ChannelKindSubscriberIdIndex | SubscriberId , Kind , Channel |
| Name | Columns | Hints | Comment |
|---|---|---|---|
| IWA_NotificationSubscription_ChannelIndex | Channel | ||
| IWA_NotificationSubscription_KindIndex | Kind | ||
| IWA_NotificationSubscription_SubscriberIdIndex | SubscriberId |
| Object | Strategy |
|---|---|
| IWA_NotificationSubscription | ALL_REMOVE_UNUSED |