SQLite Web: event

narrative_id

Primary key. TEXT

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

Cancel

event_store.db — intel_narratives