Query

event_store.db — pending_interactions

SQL

CREATE TABLE pending_interactions  (
  id TEXT PRIMARY KEY,
  thread_id TEXT NOT NULL,
  event_id TEXT,
  kind TEXT NOT NULL,
  question TEXT NOT NULL,
  choices TEXT,
  context TEXT,
  resolved INTEGER DEFAULT 0,
  resolved_at TEXT,
  dedupe_key TEXT,
  created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
  updated_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
  FOREIGN KEY (event_id) REFERENCES events(id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
thread_id TEXT Rename | Drop
event_id TEXT ✓ Rename | Drop
kind TEXT Rename | Drop
question TEXT Rename | Drop
choices TEXT ✓ Rename | Drop
context TEXT ✓ Rename | Drop
resolved INTEGER ✓ Rename | Drop
resolved_at TEXT ✓ Rename | Drop
dedupe_key TEXT ✓ Rename | Drop
created_at TEXT Rename | Drop
updated_at TEXT Rename | Drop

Foreign Keys

Column Destination
event_id events.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_pending_dedupe dedupe_key ✓ SQL 
CREATE UNIQUE INDEX idx_pending_dedupe
ON pending_interactions (dedupe_key)
Drop
idx_pending_resolved
  • resolved
  • created_at
 SQL 
CREATE INDEX idx_pending_resolved
ON pending_interactions (resolved, created_at)
Drop
idx_pending_thread
  • thread_id
  • created_at
 SQL 
CREATE INDEX idx_pending_thread
ON pending_interactions (thread_id, created_at)
Drop
sqlite_autoindex_pending_interactions_1 id ✓ SQL
-- no sql found --
 Drop