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": 13845, "message_id": "3ABC377CF6D15A9C6318", "sender": "user", "message_type": "text", "content": "Bonjour", "created_at": "2026-04-11T08:43:32.054585", "media_url": null, "media_mime_type": null}, {"id": 13847, "message_id": "bot_3ABC377CF6D15A9C6318_2977", "sender": "bot", "message_type": "text", "content": "Bonjour 😊 Bienvenue au Centre Dentaire Tanger Bay, cabinet du Dr Haitham Boutaib. Comment puis-je vous aider ?", "created_at": "2026-04-11T08:43:45.348378", "media_url": null, "media_mime_type": null}, {"id": 13849, "message_id": "3AD8ED46F03B6F465363", "sender": "user", "message_type": "voice", "content": "[Voice message] Sure! Here is the transcription of the audio, featuring a mix of Moroccan Darija and French:\n\n\"السلام عليكم، عافاك خاصني un rendez-vous le samedi prochain، ماشي اليوم، samedi prochain، euh، si c'était possible pour une petite consultation.\"\n\n**Transliteration (Latin Script):**\n\"Salam oualikoum, afak khasni un rendez-vous le samedi prochain, machi lyoum, samedi prochain, euh, si c'était possible pour une petite consultation.\"", "created_at": "2026-04-11T08:44:23.103929", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3579/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 13851, "message_id": "bot_3AD8ED46F03B6F465363_7623", "sender": "bot", "message_type": "text", "content": "مرحبا! 😊 باش نتأكد من طريقة كتابة الإسم، واخا تكتبوه ليا؟ وأيضا إذا ممكن تأكد ليا واش الموعد خاص بك أو بشي حد آخر.", "created_at": "2026-04-11T08:44:40.783339", "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 946 in training_review_items