Query

event_store.db — events

SQL

CREATE TABLE events  (
  seq INTEGER PRIMARY KEY AUTOINCREMENT,
  id TEXT NOT NULL UNIQUE,
  kind TEXT NOT NULL,
  ts TEXT NOT NULL,
  actor TEXT,
  subject_entity_ids TEXT,
  payload TEXT NOT NULL,
  source_ref TEXT,
  confidence REAL DEFAULT 0.0,
  dedupe_key TEXT UNIQUE,
  episode_id TEXT,
  created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
seq INTEGER ✓ ✓ Rename | Drop
id TEXT Rename | Drop
kind TEXT Rename | Drop
ts TEXT Rename | Drop
actor TEXT ✓ Rename | Drop
subject_entity_ids TEXT ✓ Rename | Drop
payload TEXT Rename | Drop
source_ref TEXT ✓ Rename | Drop
confidence REAL ✓ Rename | Drop
dedupe_key TEXT ✓ Rename | Drop
episode_id TEXT ✓ Rename | Drop
created_at TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_events_actor_ts
  • actor
  • ts
 SQL 
CREATE INDEX idx_events_actor_ts
ON events (actor, ts)
Drop
idx_events_episode episode_id SQL 
CREATE INDEX idx_events_episode
ON events (episode_id)
Drop
idx_events_episode_kind_seq
  • episode_id
  • kind
  • seq
 SQL 
CREATE INDEX idx_events_episode_kind_seq
ON events(episode_id, kind, seq DESC)
Drop
idx_events_episode_seq
  • episode_id
  • seq
 SQL 
CREATE INDEX idx_events_episode_seq
ON events(episode_id, seq DESC)
Drop
idx_events_kind_ts
  • kind
  • ts
 SQL 
CREATE INDEX idx_events_kind_ts
ON events (kind, ts)
Drop
idx_events_seq seq SQL 
CREATE INDEX idx_events_seq
ON events (seq)
Drop
idx_events_ts ts SQL 
CREATE INDEX idx_events_ts
ON events (ts)
Drop
sqlite_autoindex_events_1 id ✓ SQL
-- no sql found --
 Drop
sqlite_autoindex_events_2 dedupe_key ✓ SQL
-- no sql found --
 Drop