Query

event_store.db — intel_narrative_members

SQL

CREATE TABLE intel_narrative_members  (
  narrative_id TEXT NOT NULL,
  signal_id TEXT NOT NULL,
  added_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
  added_tick_id TEXT,
  PRIMARY KEY (narrative_id, signal_id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
narrative_id TEXT ✓ Rename | Drop
signal_id TEXT ✓ Rename | Drop
added_at TEXT Rename | Drop
added_tick_id TEXT ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_inm_narrative
  • narrative_id
  • added_at
 SQL 
CREATE INDEX idx_inm_narrative
ON intel_narrative_members (narrative_id, added_at DESC)
Drop
idx_inm_signal signal_id SQL 
CREATE INDEX idx_inm_signal
ON intel_narrative_members (signal_id)
Drop
sqlite_autoindex_intel_narrative_members_1
  • narrative_id
  • signal_id
 ✓ SQL
-- no sql found --
 Drop