Query
CREATE TABLE follow_up_classifications (
id INTEGER PRIMARY KEY AUTOINCREMENT,
chatbot_id INTEGER NOT NULL,
conversation_id INTEGER NOT NULL,
should_send INTEGER NOT NULL,
reason TEXT,
classified_at TEXT NOT NULL,
FOREIGN KEY (chatbot_id) REFERENCES chatbots(id) ON DELETE CASCADE,
FOREIGN KEY (conversation_id) REFERENCES conversations(id) ON DELETE CASCADE
)