PPM_CHAT_ACTIONS

This table stores Chatbot actions for an intent. PPM Chatbot performs the following types of actions: form action and simple response action. Form action should be associated with a report type. Simple response action is a text response to a question.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name Null? Data Type Description
CHAT_ACTION_ID NOT NULL NUMBER System-generated identifier
IS_FORM_ACTION NOT NULL VARCHAR2(1 CHAR) Determines whether or not it is related to the report type.
REPORT_TYPE_ID NULLABLE NUMBER Report type ID
VERSION NOT NULL NUMBER  
CREATED_BY NOT NULL NUMBER  
CREATION_DATE NOT NULL DATE  
LAST_UPDATED_BY NOT NULL NUMBER  
LAST_UPDATE_DATE NOT NULL DATE  

Indexes

Index Name

Index Type

Sequence

Column Name

PPM_CHAT_ACTIONS_N1

NONUNIQUE

1

REPORT_TYPE_ID

Sequences

Sequence Name Sequence Type
PPM_CHAT_ACTIONS_S CHAT_ACTION_ID