InAppChannelDetail (ver23.11.0)
This table stores the details related to the in-app notifications.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
ClickActionReplyToEmailAddress | 23.11.0 | VARCHAR2(255 CHAR) | Email address to which a message will be sent on click of the notification item. |
ClickActionURL | 23.11.0 | VARCHAR2(255 CHAR) | URL of the redirected page on click of the notification item. |
EventType | 23.11.0 | VARCHAR2(10 CHAR) | Selected Event type. |
InAppChannelDetailID | 23.11.0 | NUMBER(19,0) | The unique sequential number generated by the application. Indexed. Required. |
Message | 23.11.0 | VARCHAR2(2000 CHAR) | Notification message content. |
NotificationDefinitionID | 23.11.0 | NUMBER(19,0) | Foreign key to NotificationDefinition table PK. |
Recipient | 23.11.0 | VARCHAR2(10 CHAR) | User group/groups who gets the in-app notification. |
Subject | 23.11.0 | VARCHAR2(40 CHAR) | Subject or header of the notification content. |
WhenCreated | 23.11.0 | TIMESTAMP(6) | The date and time the record was created. Defaults to system date. Required. |
WhenModified | 23.11.0 | TIMESTAMP(6) | The date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 23.11.0 | VARCHAR2(100 CHAR) | The name of the person who created the record. Defaults to user. Required. |
WhoModifed | 23.11.0 | VARCHAR2(100 CHAR) | The name of the person who modified the record. Defaults to the user. Required. |