Query

event_store.db — intel_memory

SQL

CREATE TABLE intel_memory  (
  story_key TEXT PRIMARY KEY,
  entity_key TEXT NOT NULL,
  theme_key TEXT NOT NULL,
  latest_story_id TEXT,
  first_seen_at TEXT,
  last_seen_at TEXT,
  last_alerted_at TEXT,
  last_digested_at TEXT,
  last_decision TEXT NOT NULL DEFAULT 'monitor',
  last_alert_class TEXT NOT NULL DEFAULT 'none',
  continuity_state TEXT NOT NULL DEFAULT 'new',
  uncertainty_state TEXT NOT NULL DEFAULT 'open',
  followup_status TEXT NOT NULL DEFAULT 'none',
  followup_attempts INTEGER NOT NULL DEFAULT 0,
  last_followup_at TEXT,
  last_verification_note TEXT,
  last_confidence REAL NOT NULL DEFAULT 0.0,
  last_corroboration_score REAL NOT NULL DEFAULT 0.0,
  last_importance_score REAL NOT NULL DEFAULT 0.0,
  last_provenance_score REAL NOT NULL DEFAULT 0.0,
  quality_delta REAL NOT NULL DEFAULT 0.0,
  latest_headline TEXT,
  latest_thesis TEXT,
  latest_why_now TEXT,
  unresolved_questions TEXT,
  seen_timestamps_30d TEXT,
  surfaced_timestamps_30d TEXT,
  alerted_timestamps_30d TEXT,
  seen_count_total INTEGER NOT NULL DEFAULT 0,
  surfaced_count_total INTEGER NOT NULL DEFAULT 0,
  alert_count_total INTEGER NOT NULL DEFAULT 0,
  updated_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
story_key TEXT ✓ ✓ Rename | Drop
entity_key TEXT Rename | Drop
theme_key TEXT Rename | Drop
latest_story_id TEXT ✓ Rename | Drop
first_seen_at TEXT ✓ Rename | Drop
last_seen_at TEXT ✓ Rename | Drop
last_alerted_at TEXT ✓ Rename | Drop
last_digested_at TEXT ✓ Rename | Drop
last_decision TEXT Rename | Drop
last_alert_class TEXT Rename | Drop
continuity_state TEXT Rename | Drop
uncertainty_state TEXT Rename | Drop
followup_status TEXT Rename | Drop
followup_attempts INTEGER Rename | Drop
last_followup_at TEXT ✓ Rename | Drop
last_verification_note TEXT ✓ Rename | Drop
last_confidence REAL Rename | Drop
last_corroboration_score REAL Rename | Drop
last_importance_score REAL Rename | Drop
last_provenance_score REAL Rename | Drop
quality_delta REAL Rename | Drop
latest_headline TEXT ✓ Rename | Drop
latest_thesis TEXT ✓ Rename | Drop
latest_why_now TEXT ✓ Rename | Drop
unresolved_questions TEXT ✓ Rename | Drop
seen_timestamps_30d TEXT ✓ Rename | Drop
surfaced_timestamps_30d TEXT ✓ Rename | Drop
alerted_timestamps_30d TEXT ✓ Rename | Drop
seen_count_total INTEGER Rename | Drop
surfaced_count_total INTEGER Rename | Drop
alert_count_total INTEGER Rename | Drop
updated_at TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_intel_memory_continuity
  • continuity_state
  • updated_at
 SQL 
CREATE INDEX idx_intel_memory_continuity
ON intel_memory (continuity_state, updated_at)
Drop
idx_intel_memory_decision
  • last_decision
  • updated_at
 SQL 
CREATE INDEX idx_intel_memory_decision
ON intel_memory (last_decision, updated_at)
Drop
idx_intel_memory_entity_theme
  • entity_key
  • theme_key
  • updated_at
 SQL 
CREATE INDEX idx_intel_memory_entity_theme
ON intel_memory (entity_key, theme_key, updated_at)
Drop
idx_intel_memory_followup
  • followup_status
  • updated_at
 SQL 
CREATE INDEX idx_intel_memory_followup
ON intel_memory (followup_status, updated_at)
Drop
idx_intel_memory_seen
  • last_seen_at
  • updated_at
 SQL 
CREATE INDEX idx_intel_memory_seen
ON intel_memory (last_seen_at, updated_at)
Drop
idx_intel_memory_uncertainty
  • uncertainty_state
  • updated_at
 SQL 
CREATE INDEX idx_intel_memory_uncertainty
ON intel_memory (uncertainty_state, updated_at)
Drop
idx_intel_memory_updated updated_at SQL 
CREATE INDEX idx_intel_memory_updated
ON intel_memory (updated_at)
Drop
sqlite_autoindex_intel_memory_1 story_key ✓ SQL
-- no sql found --
 Drop