CREATE TABLE training_review_items (
id INTEGER PRIMARY KEY AUTOINCREMENT,
chatbot_id INTEGER NOT NULL,
conversation_id INTEGER NOT NULL,
bot_message_id INTEGER NOT NULL,
user_message_id INTEGER,
context_window_json TEXT NOT NULL,
bot_answer TEXT NOT NULL,
label TEXT,
corrected_answer TEXT,
reviewed_by INTEGER,
reviewed_at TEXT,
status TEXT NOT NULL DEFAULT 'pending',
created_at TEXT NOT NULL,
updated_at TEXT,
synced_to_examples INTEGER NOT NULL DEFAULT 0,
synced_at TEXT,
expected_answer TEXT,
steps_of_thinking TEXT,
tool_called TEXT,
FOREIGN KEY (chatbot_id) REFERENCES chatbots(id) ON DELETE CASCADE,
FOREIGN KEY (conversation_id) REFERENCES conversations(id) ON DELETE CASCADE,
FOREIGN KEY (bot_message_id) REFERENCES messages(id) ON DELETE CASCADE,
FOREIGN KEY (user_message_id) REFERENCES messages(id) ON DELETE SET NULL,
FOREIGN KEY (reviewed_by) REFERENCES users(id) ON DELETE SET NULL,
UNIQUE(chatbot_id, bot_message_id)
)