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": 47339, "message_id": "3EB0E04FA86445B94AE6D2", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*JABER Bouyahya*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *jeudi 25 juin 2026* à *16:00* .\r\nEn cas d'empêchement, veuillez contacter la réception \r\n*060022263 / 0539948014*\r\nMerci pour votre attention.\r\n\r\n.مرحبًا\r\n**\r\nلديكم موعد مع ** يوم *الخميس 25 يونيو 2026* على الساعة *16:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-23T11:24:32.369481", "media_url": null, "media_mime_type": null}, {"id": 47340, "message_id": "3A3F079FC1C662D781F7", "sender": "user", "message_type": "text", "content": "Ok", "created_at": "2026-06-23T11:25:01.313845", "media_url": null, "media_mime_type": null}, {"id": 47341, "message_id": "bot_3A3F079FC1C662D781F7_1987", "sender": "bot", "message_type": "text", "content": "Merci pour votre retour !", "created_at": "2026-06-23T11:25:23.648097", "media_url": null, "media_mime_type": null}, {"id": 47342, "message_id": "bot_3A3F079FC1C662D781F7_9940", "sender": "bot", "message_type": "text", "content": "Votre rendez-vous avec le Dr Oussama Mouallem est bien noté pour le jeudi 25 juin 2026 à 16h00.", "created_at": "2026-06-23T11:25:23.694060", "media_url": null, "media_mime_type": null}, {"id": 47343, "message_id": "bot_3A3F079FC1C662D781F7_4625", "sender": "bot", "message_type": "text", "content": "Si jamais vous avez un empêchement, n’hésitez pas à contacter la réception au 060022263 ou 0539948014.", "created_at": "2026-06-23T11:25:23.740567", "media_url": null, "media_mime_type": null}, {"id": 47344, "message_id": "bot_3A3F079FC1C662D781F7_869", "sender": "bot", "message_type": "text", "content": "À bientôt et merci pour votre confiance !", "created_at": "2026-06-23T11:25:23.780482", "media_url": null, "media_mime_type": null}, {"id": 47345, "message_id": "3A9E3087BEDBD454B5C0", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija:\n\n**Arabic Script:**\n\"هادشي كامل اللي طرا دابا ما كنفهموش، أنا ما كنهضرش الفرنسية، هضر معايا بالعربية ولا لونكلي.\"\n\n**Latin Script (Transcription):**\n\"Hadshi kamel li tra daba ma kanfhmouch, ana ma kanhdersh l-fransiya, hder m3aya b l-3arbiya wla l-ongli.\"\n\n**English Translation (for context):**\n\"I don't understand all this that just happened, I don't speak French, speak to me in Arabic or English.\"", "created_at": "2026-06-23T11:25:49.637203", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/13104/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 47346, "message_id": "bot_3A9E3087BEDBD454B5C0_2267", "sender": "bot", "message_type": "text", "content": "شكرا على التوضيح!", "created_at": "2026-06-23T11:26:14.482227", "media_url": null, "media_mime_type": null}, {"id": 47347, "message_id": "bot_3A9E3087BEDBD454B5C0_1106", "sender": "bot", "message_type": "text", "content": "غادي نهضر معاك بالعربية.", "created_at": "2026-06-23T11:26:14.540222", "media_url": null, "media_mime_type": null}, {"id": 47348, "message_id": "bot_3A9E3087BEDBD454B5C0_4790", "sender": "bot", "message_type": "text", "content": "عندك موعد مع الدكتور أسامة معلم نهار الخميس 25 يونيو 2026 مع الرابعة ديال العشية (16:00).", "created_at": "2026-06-23T11:26:14.591244", "media_url": null, "media_mime_type": null}, {"id": 47349, "message_id": "bot_3A9E3087BEDBD454B5C0_7585", "sender": "bot", "message_type": "text", "content": "إذا وقع لك شي عائق وماقدرتيش تجي، تقدر تتواصل مع الاستقبال على هاد الرقم: 060022263 أو 0539948014.", "created_at": "2026-06-23T11:26:14.639251", "media_url": null, "media_mime_type": null}, {"id": 47350, "message_id": "bot_3A9E3087BEDBD454B5C0_6126", "sender": "bot", "message_type": "text", "content": "إلا محتاج شي توضيح آخر، أنا هنا معاك!", "created_at": "2026-06-23T11:26:14.698714", "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 3932 in training_review_items