SQLite Web: event

story_key

Primary key. TEXT

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'))

event_store.db — intel_memory

Insert row into intel_memory