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": 5579, "message_id": "bot_3AC0242EBC28258254D3_9162", "sender": "bot", "message_type": "text", "content": "Pendant le mois de Ramadan, nous sommes ouverts tous les jours de 10:00 à 16:00. Si vous avez besoin d'autres informations ou si vous souhaitez prendre rendez-vous, n'hésitez pas à me le faire savoir ! 😊", "created_at": "2026-03-17T01:17:48.691863", "media_url": null, "media_mime_type": null}, {"id": 5580, "message_id": "3A1F9F9A172B172ECA99", "sender": "user", "message_type": "text", "content": "Après Ramadan", "created_at": "2026-03-17T01:18:45.469180", "media_url": null, "media_mime_type": null}, {"id": 5581, "message_id": "bot_3A1F9F9A172B172ECA99_7875", "sender": "bot", "message_type": "text", "content": "Après le Ramadan, nos horaires normaux sont les suivants :\n\n- Lundi à Vendredi : 09:00 à 19:00\n- Samedi : 09:00 à 14:00\n- Dimanche : Fermé\n\nSi vous avez d'autres questions ou si vous souhaitez prendre rendez-vous, je suis là pour vous aider ! 😊", "created_at": "2026-03-17T01:18:57.260610", "media_url": null, "media_mime_type": null}, {"id": 5582, "message_id": "3ABB75C48AEC2D3B763F", "sender": "user", "message_type": "text", "content": "La première semaine Inchaallah après Ramadan je passe au centre Inchaallah", "created_at": "2026-03-17T01:33:45.298069", "media_url": null, "media_mime_type": null}, {"id": 5583, "message_id": "bot_3ABB75C48AEC2D3B763F_9970", "sender": "bot", "message_type": "text", "content": "Parfait ! Nous serons ravis de vous accueillir au Centre Dentaire Tanger Bay la première semaine après le Ramadan. Si vous souhaitez fixer un rendez-vous précis ou si vous avez besoin d'autres informations, n'hésitez pas à me le faire savoir. À très bientôt Inchaallah ! 😊", "created_at": "2026-03-17T01:33:56.106383", "media_url": null, "media_mime_type": null}, {"id": 5584, "message_id": "3A07788B254E01B453A1", "sender": "user", "message_type": "text", "content": "Merci", "created_at": "2026-03-17T01:34:20.789699", "media_url": null, "media_mime_type": null}, {"id": 5585, "message_id": "bot_3A07788B254E01B453A1_7457", "sender": "bot", "message_type": "text", "content": "Avec plaisir ! Si vous avez d'autres questions ou besoin d'assistance, n'hésitez pas à me contacter. À bientôt et prenez soin de vous ! 😊", "created_at": "2026-03-17T01:34:31.316421", "media_url": null, "media_mime_type": null}, {"id": 5596, "message_id": "A5186E0F37C91FCCCA66E7D4067C6972", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-03-17T08:53:03.130671", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1037/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 8820, "message_id": "A5F3016D5AD9E1BD4FD68D380295DFA6", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in both Arabic and Latin scripts:\n\n**Arabic Script:**\nالسلام سي العلمي، صافا لاباس عليك؟ كنتمنى تكون مزيان بخير. فوقاش تكون ديسبونيبل باش ناخدو رانديفو (RDV) مع الدكتور؟\n\n**Latin Script:**\nSalam Si El Alami, ça va labas aalik? Kantmenna tkoun mzyane bkheir. Fouqach tkoun disponible bach nakhdou rdv m3a docteur?", "created_at": "2026-03-30T11:57:21.148679", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1951/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 8846, "message_id": "3A087184B666528209A1", "sender": "user", "message_type": "voice", "content": "[Voice message] السلام عليكم، أختي رانا ميسيون، رانا خارجين للبحر، رانا فلازون سيد (la zone sud)، في الجنوب. أون فوا (une fois) نطلع أختي للشمال، وديك الساعة نطراسى معاك. حيت أنا خدام في البحرية الملكية، ماكنتراصاوش. وشكراً، الله يجازيك بخير، نهارك مبروك.", "created_at": "2026-03-30T12:05:01.369500", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1958/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 8847, "message_id": "A5A153F3241A8840058258DD9A623E4D", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-03-30T12:05:29.247994", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1959/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 8848, "message_id": "bot_3A087184B666528209A1_3685", "sender": "bot", "message_type": "text", "content": "وعليكم السلام ورحمة الله، شكراً على التوضيح وعلى كلامك الطيب 😊\n\nوقت ما طلعتو للشمال وكنت متوفر، مرحبا بيكوم فCentre Dentaire Tanger Bay. تقدر تتواصل معانا وقتما بغيتو باش نحجزو ليكوم موعد مع الدكتور إن شاء الله.\n\nنهارك مبروك والله يسهل عليكوم فخدمتكم!", "created_at": "2026-03-30T12:05:36.334972", "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 466 in training_review_items