Query

event_store.db — episodes

SQL

CREATE TABLE episodes  (
  id TEXT PRIMARY KEY,
  event_id TEXT,
  thread_id TEXT NOT NULL,
  stage        TEXT NOT NULL,
  pending_id   TEXT,
  headline     TEXT,
  data TEXT,
  completed_at 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
event_id TEXT ✓ Rename | Drop
thread_id TEXT Rename | Drop
stage TEXT Rename | Drop
pending_id TEXT ✓ Rename | Drop
headline TEXT ✓ Rename | Drop
data TEXT ✓ Rename | Drop
completed_at 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_episodes_event event_id SQL 
CREATE INDEX idx_episodes_event
ON episodes (event_id)
Drop
idx_episodes_stage
  • stage
  • updated_at
 SQL 
CREATE INDEX idx_episodes_stage
ON episodes (stage, updated_at)
Drop
idx_episodes_thread thread_id SQL 
CREATE INDEX idx_episodes_thread
ON episodes (thread_id)
Drop
idx_episodes_thread_id thread_id SQL 
CREATE INDEX idx_episodes_thread_id
ON episodes(thread_id)
Drop
sqlite_autoindex_episodes_1 id ✓ SQL
-- no sql found --
 Drop