event_store.db — signals

• actions
• approvals
• commitments
• constraints
• dead_letters
• decisions
• deliveries
• effects
• entities
• entity_aliases
• entity_tags
• episode_context_index
• episodes
• event_subjects
• events
• fact_sources
• facts
• inbox_items
• inbox_links
• jobs
• leader_leases
• links
• memory_items
• memory_journal
• memory_state
• pending_interactions
• proposal_sources
• proposals
• reminders
• schedules
• schema_migrations
• signal_fps
• signals
• slack_deliveries
• source_cursors
• sources
• sqlite_sequence
• stream_cursors
• threads
• watchers

Toggle helper tables

• Structure
• Content
• Query
• Insert
• Drop
• Import
• Export

CREATE TABLE signals  (
  id TEXT PRIMARY KEY,
  event_id TEXT NOT NULL UNIQUE,
  -- NEW: 1:1 backing event for replayability
  watcher_id TEXT,
  -- NEW: optional provenance hook
  signal_type TEXT NOT NULL,
  value TEXT NOT NULL,
  threshold TEXT,
  direction TEXT,
  severity TEXT,
  window TEXT,
  source TEXT NOT NULL,
  reason_trace TEXT,
  dedupe_key TEXT NOT NULL,
  throttle_s INTEGER DEFAULT 0,
  created_at TEXT NOT NULL DEFAULT (strftime('%Y-%m-%dT%H:%M:%fZ','now')),
  FOREIGN KEY (event_id) REFERENCES events(id) ON DELETE RESTRICT DEFERRABLE INITIALLY DEFERRED,
  FOREIGN KEY (watcher_id) REFERENCES watchers(id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED
)

CREATE INDEX idx_signals_created_at
ON signals(created_at DESC)

CREATE UNIQUE INDEX idx_signals_dedupe
ON signals (dedupe_key)

CREATE INDEX idx_signals_source_at
ON signals (source, created_at)

CREATE INDEX idx_signals_type_at
ON signals (signal_type, created_at)

CREATE INDEX idx_signals_watcher_at
ON signals (watcher_id, created_at)