Setup Table
AI-generatedSummary
Creates (if not exists) a table for storing chat messages. The table includes columns: id (auto-increment primary key), session_id (VARCHAR2), message_type (VARCHAR2 with check constraint), content (CLOB), timestamp_created (TIMESTAMP), metadata (CLOB). It also creates an index on session_id for fast lookup. If the table already exists, the operation does nothing.
Inputs
None.
Output shape
The operation returns an array with a single object containing success (boolean), message (string), and operation (string) fields.
Success is true when the table is created or already exists. The message indicates the table name and that setup succeeded. Operation is always 'setup'.
Examples
Example 1: Create the default table CHAT_MEMORY
Operation: Setup Table; Table Name: CHAT_MEMORY (default)
Example 2: Create a custom table
Operation: Setup Table; Table Name: my_chat_store