Query
CREATE TABLE pending_interactions (
id TEXT PRIMARY KEY,
thread_id TEXT NOT NULL,
event_id TEXT,
kind TEXT NOT NULL,
question TEXT NOT NULL,
choices TEXT,
context TEXT,
resolved INTEGER DEFAULT 0,
resolved_at TEXT,
dedupe_key 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 (event_id) REFERENCES events(id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED
)