CREATE TABLE signal_fps (
fp TEXT PRIMARY KEY,
status TEXT NOT NULL CHECK (status IN ('new','open','fired','throttled','suppressed','failed')),
signal_type TEXT,
signal_id TEXT,
watcher_id 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')),
FOREIGN KEY (signal_id) REFERENCES signals(id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED,
FOREIGN KEY (watcher_id) REFERENCES watchers(id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED
)