SQLite Web: app.db

id

Primary key. INTEGER

chatbot_id

INTEGER NOT NULL

conversation_id

INTEGER NOT NULL

bot_message_id

INTEGER NOT NULL

user_message_id

INTEGER

context_window_json

[{"id": 37420, "message_id": "AC7DEBB8ADB352A8B696590D0C46F10F", "sender": "user", "message_type": "voice", "content": "", "created_at": "2026-06-01T10:54:52.553399", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/10460/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 37423, "message_id": "AC80F1B9A9D34C451266332CA32395F8", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-06-01T10:56:08.647554", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/10463/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 37428, "message_id": "AC95115806F16EF76AC5EA063350A265", "sender": "user", "message_type": "voice", "content": "", "created_at": "2026-06-01T10:57:25.204747", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/10466/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 37430, "message_id": "ACE513A68FE551D46F62A33E2CEEE339", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-06-01T10:58:50.813089", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/10467/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 37432, "message_id": "AC829F287D3B81250919680609CC90DC", "sender": "user", "message_type": "text", "content": "ok", "created_at": "2026-06-01T10:59:11.163773", "media_url": null, "media_mime_type": null}, {"id": 37433, "message_id": "AC937D11BF4116A4A12898AE3B0A188F", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-06-01T10:59:32.529366", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/10469/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 37434, "message_id": "AC82AF897B44AD1C5BDC3BBCACEC79AB", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-06-01T10:59:35.341970", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/10470/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 37435, "message_id": "AC67300E11EC4BF95D2B0121411506CF", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-06-01T10:59:50.846861", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/10471/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 37438, "message_id": "AC0F38ABFA23CE14C6183A2C21FFA470", "sender": "user", "message_type": "voice", "content": "", "created_at": "2026-06-01T11:01:19.716976", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/10472/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 37441, "message_id": "AC645F649B30676A261BEE5B3CE24F1C", "sender": "bot", "message_type": "text", "content": "Marhba", "created_at": "2026-06-01T11:04:43.546455", "media_url": null, "media_mime_type": null}, {"id": 40371, "message_id": "AC98F53DA47AEC1E12B0F3B7FEDA2D35", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in both Arabic script (as commonly written in Morocco) and Latin script:\n\n**Arabic Script:**\nماما ما غانقدرش نجاوب، غدوة عندي امتحان، دونك ما يمكنش ليا غدوة.\n\n**Latin Script (Darija/French mix):**\nMama ma ghan9dersh njawb, ghadwa 3andi mti7an, donc ma ymkench liya ghadwa.\n\n**English Translation (for context):**\n\"Mom, I won't be able to answer, tomorrow I have an exam, so it won't be possible for me tomorrow.\"", "created_at": "2026-06-08T12:34:01.739763", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/11202/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 40372, "message_id": "bot_AC98F53DA47AEC1E12B0F3B7FEDA2D35_6518", "sender": "bot", "message_type": "text", "content": "الفريق غادي يتواصلوا بيكوم بهاد الموضوع إن شاء الله 🙏🏻", "created_at": "2026-06-08T12:34:19.385011", "media_url": null, "media_mime_type": null}]

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

app.db — training_review_items

Update row 3276 in training_review_items