Query

event_store.db — attention_candidates

Could not fetch row with primary-key 88616.

Could not fetch row with primary-key 407278.

Could not fetch row with primary-key 406998.

Could not fetch row with primary-key 155871.

Could not fetch row with primary-key 87041.

Could not fetch row with primary-key 407287.

Could not fetch row with primary-key 408641.

SQL

CREATE TABLE attention_candidates  (
  id TEXT PRIMARY KEY,
  status TEXT NOT NULL DEFAULT 'pending' CHECK (status IN (
    'pending','gated','dispatched','superseded','expired'
  )),
  kind TEXT NOT NULL,
  reason TEXT NOT NULL,
  score REAL NOT NULL DEFAULT 0.0,
  target_entity TEXT,
  urgency_hint TEXT,
  ttl TEXT,
  source_daemon TEXT NOT NULL,
  source_ref_kind TEXT NOT NULL,
  source_ref_id TEXT NOT NULL,
  dedupe_key TEXT NOT NULL,
  title TEXT,
  body TEXT,
  why_now TEXT,
  cta_json TEXT,
  delivery_channel_hint TEXT,
  thread_id TEXT,
  reason_trace_json TEXT,
  score_breakdown_json TEXT,
  source_event_id TEXT NOT NULL,
  gated_reason TEXT,
  gated_rules_json TEXT,
  next_eligible_at TEXT,
  dispatched_event_id TEXT,
  dispatched_at TEXT,
  superseded_by 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'))
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
status TEXT Rename | Drop
kind TEXT Rename | Drop
reason TEXT Rename | Drop
score REAL Rename | Drop
target_entity TEXT ✓ Rename | Drop
urgency_hint TEXT ✓ Rename | Drop
ttl TEXT ✓ Rename | Drop
source_daemon TEXT Rename | Drop
source_ref_kind TEXT Rename | Drop
source_ref_id TEXT Rename | Drop
dedupe_key TEXT Rename | Drop
title TEXT ✓ Rename | Drop
body TEXT ✓ Rename | Drop
why_now TEXT ✓ Rename | Drop
cta_json TEXT ✓ Rename | Drop
delivery_channel_hint TEXT ✓ Rename | Drop
thread_id TEXT ✓ Rename | Drop
reason_trace_json TEXT ✓ Rename | Drop
score_breakdown_json TEXT ✓ Rename | Drop
source_event_id TEXT Rename | Drop
gated_reason TEXT ✓ Rename | Drop
gated_rules_json TEXT ✓ Rename | Drop
next_eligible_at TEXT ✓ Rename | Drop
dispatched_event_id TEXT ✓ Rename | Drop
dispatched_at TEXT ✓ Rename | Drop
superseded_by TEXT ✓ Rename | Drop
created_at TEXT Rename | Drop
updated_at TEXT Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_attention_candidates_dedupe dedupe_key ✓ SQL 
CREATE UNIQUE INDEX idx_attention_candidates_dedupe
ON attention_candidates (dedupe_key)
Drop
idx_attention_candidates_kind_status
  • kind
  • status
  • created_at
 SQL 
CREATE INDEX idx_attention_candidates_kind_status
ON attention_candidates (kind, status, created_at)
Drop
idx_attention_candidates_status_score
  • status
  • score
  • created_at
 SQL 
CREATE INDEX idx_attention_candidates_status_score
ON attention_candidates (status, score DESC, created_at)
Drop
idx_attention_candidates_target_entity
  • target_entity
  • status
 SQL 
CREATE INDEX idx_attention_candidates_target_entity
ON attention_candidates (target_entity, status)
Drop
sqlite_autoindex_attention_candidates_1 id ✓ SQL
-- no sql found --
 Drop