PPM_CHAT_INTENTS_NLS

This table stores the list of intents for PPM Chatbot.

Foreign Keys

Primary Key Table Primary Key Column Foreign Key Column
PPM_CHAT_ACTIONS CHAT_ACTION_ID CHAT_ACTION_ID

Column Descriptions

Column Name Null? Data Type Description
CHAT_INTENT_ID NOT NULL NUMBER System-generated identifier
CHAT_INTENT_NAME NOT NULL VARCHAR2(255 CHAR) Intent name
DESCRIPTION NULLABLE VARCHAR2(400 CHAR)  
ENABLED_FLAG NOT NULL VARCHAR2(1 CHAR) Determines whether it is enabled or not
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  
DEFINITION_LANGUAGE NOT NULL VARCHAR2(40 CHAR)  
REFERENCE_CODE NOT NULL VARCHAR2(200 CHAR) Reference code

Indexes

Index Name

Index Type

Sequence

Column Name

PPM_CHAT_INTENTS_NLS_N1

NONUNIQUE

1

CHAT_ACTION_ID

Sequences

Sequence Name Sequence Type
PPM_CHAT_INTENTS_S CHAT_INTENT_ID