Query

event_store.db — episode_context_index

SQL

CREATE TABLE episode_context_index  (
  episode_id       TEXT NOT NULL,
  intent           TEXT NOT NULL,
  retrieval_mode   TEXT NOT NULL,
  context_event_id TEXT NOT NULL,
  context_seq      INTEGER NOT NULL,
  context_ts       TEXT NOT NULL,
  max_input_seq    INTEGER NOT NULL,
  local_day_bucket TEXT NOT NULL,
  PRIMARY KEY (episode_id, intent, retrieval_mode)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
episode_id TEXT ✓ Rename | Drop
intent TEXT ✓ Rename | Drop
retrieval_mode TEXT ✓ Rename | Drop
context_event_id TEXT Rename | Drop
context_seq INTEGER Rename | Drop
context_ts TEXT Rename | Drop
max_input_seq INTEGER Rename | Drop
local_day_bucket TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_ctx_index_event context_event_id SQL 
CREATE INDEX idx_ctx_index_event
ON episode_context_index(context_event_id)
Drop
sqlite_autoindex_episode_context_index_1
  • episode_id
  • intent
  • retrieval_mode
 ✓ SQL
-- no sql found --
 Drop