CREATE TABLE threads (
thread_id TEXT PRIMARY KEY,
source TEXT NOT NULL,
-- 'slack'
team_id TEXT,
channel_id TEXT,
user_id TEXT,
scope TEXT,
-- dm|slack_thread|channel|user_channel
current_episode_id TEXT,
last_inbound_event_id TEXT,
last_inbound_message_id TEXT,
-- slack ts
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 (current_episode_id) REFERENCES episodes(id) ON DELETE SET NULL DEFERRABLE INITIALLY DEFERRED
)