Query

event_store.db — intel_narratives

Could not fetch row with primary-key 161817.

Could not fetch row with primary-key 97757.

SQL

CREATE TABLE intel_narratives  (
  narrative_id TEXT PRIMARY KEY,
  title TEXT NOT NULL,
  thesis TEXT NOT NULL,
  state TEXT NOT NULL DEFAULT 'emerging',
  last_confidence REAL,
  last_uncertainty TEXT,
  last_update_worthy INTEGER NOT NULL DEFAULT 0,
  last_update_worthy_reason TEXT,
  last_published_artifact_id TEXT,
  last_publish_at TEXT,
  degraded INTEGER NOT NULL DEFAULT 0,
  degraded_reason TEXT,
  created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
  last_updated_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
  last_signal_seen_at TEXT,
  first_signal_id TEXT,
  domains_json TEXT NOT NULL DEFAULT '[]',
  variant_labels_json TEXT NOT NULL DEFAULT '[]',
  provenance_json TEXT,
  evidence_log_json TEXT NOT NULL DEFAULT '[]'
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
narrative_id TEXT ✓ ✓ Rename | Drop
title TEXT Rename | Drop
thesis TEXT Rename | Drop
state TEXT Rename | Drop
last_confidence REAL ✓ Rename | Drop
last_uncertainty TEXT ✓ Rename | Drop
last_update_worthy INTEGER Rename | Drop
last_update_worthy_reason TEXT ✓ Rename | Drop
last_published_artifact_id TEXT ✓ Rename | Drop
last_publish_at TEXT ✓ Rename | Drop
degraded INTEGER Rename | Drop
degraded_reason TEXT ✓ Rename | Drop
created_at TEXT Rename | Drop
last_updated_at TEXT Rename | Drop
last_signal_seen_at TEXT ✓ Rename | Drop
first_signal_id TEXT ✓ Rename | Drop
domains_json TEXT Rename | Drop
variant_labels_json TEXT Rename | Drop
provenance_json TEXT ✓ Rename | Drop
evidence_log_json TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_intel_narratives_active
  • state
  • last_updated_at
 SQL 
CREATE INDEX idx_intel_narratives_active
ON intel_narratives (state, last_updated_at DESC)
Drop
idx_intel_narratives_last_seen last_signal_seen_at SQL 
CREATE INDEX idx_intel_narratives_last_seen
ON intel_narratives (last_signal_seen_at DESC)
Drop
idx_intel_narratives_pending
  • last_update_worthy
  • last_publish_at
 SQL 
CREATE INDEX idx_intel_narratives_pending
ON intel_narratives (last_update_worthy, last_publish_at)
Drop
sqlite_autoindex_intel_narratives_1 narrative_id ✓ SQL
-- no sql found --
 Drop