Query

app.db — training_review_items

SQL

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)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
chatbot_id INTEGER Rename | Drop
conversation_id INTEGER Rename | Drop
bot_message_id INTEGER Rename | Drop
user_message_id INTEGER ✓ Rename | Drop
context_window_json TEXT Rename | Drop
bot_answer TEXT Rename | Drop
label TEXT ✓ Rename | Drop
corrected_answer TEXT ✓ Rename | Drop
reviewed_by INTEGER ✓ Rename | Drop
reviewed_at TEXT ✓ Rename | Drop
status TEXT Rename | Drop
created_at TEXT Rename | Drop
updated_at TEXT ✓ Rename | Drop
synced_to_examples INTEGER Rename | Drop
synced_at TEXT ✓ Rename | Drop
expected_answer TEXT ✓ Rename | Drop
steps_of_thinking TEXT ✓ Rename | Drop
tool_called TEXT ✓ Rename | Drop

Foreign Keys

Column Destination
reviewed_by users.id
user_message_id messages.id
bot_message_id messages.id
conversation_id conversations.id
chatbot_id chatbots.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_training_review_chatbot_id chatbot_id SQL 
CREATE INDEX idx_training_review_chatbot_id
ON training_review_items(chatbot_id)
Drop
idx_training_review_conversation_id conversation_id SQL 
CREATE INDEX idx_training_review_conversation_id
ON training_review_items(conversation_id)
Drop
idx_training_review_created_at created_at SQL 
CREATE INDEX idx_training_review_created_at
ON training_review_items(created_at)
Drop
idx_training_review_status status SQL 
CREATE INDEX idx_training_review_status
ON training_review_items(status)
Drop
sqlite_autoindex_training_review_items_1
  • chatbot_id
  • bot_message_id
 ✓ SQL
-- no sql found --
 Drop