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": 13148, "message_id": "bot_ACC97C57D81F24C86DA849C87D4F9087_7823", "sender": "bot", "message_type": "text", "content": "صراحة معنديش دراية بالموضوع، ولكن غادي نبلغ الفريق الطبي ديالنا وغادي يتواصلوا معكوم في أقرب وقت. واخا تعطيني الإسم الكامل ديالك؟", "created_at": "2026-04-09T14:14:11.567934", "media_url": null, "media_mime_type": null}, {"id": 13149, "message_id": "A51F1270977186FF72CF503D6CFB7F5B", "sender": "bot", "message_type": "voice", "content": "[Voice message] بالطبع، إليك تفريغ المقطع الصوتي:\n\n\"السلام عليكم، بخير مزيان؟ الصحة لاباس؟ مرحبا. فكرني ف السمية ديالك عافاك.\"", "created_at": "2026-04-09T14:14:48.651650", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3359/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 13150, "message_id": "AC3F04150DE1DABDAB434BF2FAC26256", "sender": "user", "message_type": "text", "content": "محمد بوركب", "created_at": "2026-04-09T14:15:07.870478", "media_url": null, "media_mime_type": null}, {"id": 13151, "message_id": "A555D2182F8002D7283C6E810EB62A5F", "sender": "bot", "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 (Transliteration):**\n\"Marhba bik a Si Mohammed, ghedda inchaAllah aandek rendez-vous fl'achia m'a lkhamsa, hnaya nsennawk inchaAllah mennaha nchoufou lek lmochkil.\"\n\n**Language breakdown:**\n*   **Marhba bik a Si Mohammed:** Welcome, Mr. Mohammed.\n*   **Ghedda inchaAllah:** Tomorrow, God willing.\n*   **Aandek rendez-vous:** You have an appointment (French word used in Darija).\n*   **Fl'achia m'a lkhamsa:** In the afternoon at five.\n*   **Hnaya nsennawk:** We will be waiting for you.\n*   **Mennaha nchoufou lek lmochkil:** So we can see/fix the problem for you.", "created_at": "2026-04-09T14:15:25.122349", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3360/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 13152, "message_id": "ACC46ECC9CA2FFC178227ECBF31D85FA", "sender": "user", "message_type": "text", "content": "اك انشاء الله", "created_at": "2026-04-09T14:15:57.127604", "media_url": null, "media_mime_type": null}, {"id": 13179, "message_id": "3EB0F1829811713023BE28", "sender": "bot", "message_type": "image", "content": "[Image analysis] Image description: ```json\n{\n  \"visible_domain\": \"non_dental\",\n  \"image_quality\": {\n    \"score\": \"good\",\n    \"issues\": []\n  },\n  \"description\": \"The image is a promotional or informational graphic for Tanger Bay Dental Center. At the top, there is a white dental logo consisting of a stylized tooth outline and the words 'TANGER BAY DENTAL CENTER.' Below this, a blue banner with white capital letters reads 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' followed by a green check mark. Another blue banner beneath says 'CHEZ TANGER BAY DENTAL CENTER.' The foreground prominently features a large, animated, cartoon-style anthropomorphic tooth with a smiling face, black eyes, raised eyebrows, and a thumbs-up gesture. The tooth is holding a small spiral notepad depicting a check box with a green check mark. The background appears to show an out-of-focus dental clinic with dental chair and equipment, but no real people are present.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"unclear\",\n    \"teeth_condition\": [],\n    \"gum_condition\": null,\n    \"bone_level\": null,\n    \"root_canals\": null,\n    \"restorations_visible\": [],\n    \"missing_teeth\": null,\n    \"alignment\": null,\n    \"calculus_plaque\": null,\n    \"periapical_areas\": null\n\nUser message context: Salut *BOURAGBA Mohamed*👋\r\nNous vous confirmons votre rendez-vous avec *DR OUSSAMA MOUALLEM*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *vendredi 10 avril 2026*\r\n🕘 Heure : *17:00*\r\n📍 Adresse : Résidence Borj Khalij 3, Étage 5, App. 197 – Avenue Mohammed VI, Tanger (près de Café Sky17)\r\n📞 Pour toute question : 06 60 02 22 63\r\n✅ Merci de nous confirmer votre présence en répondant « OUI » à ce message\r\n\r\n⚠️ IMPORTANT : Veuillez noter que si nous ne recevons pas votre confirmation votre rendez-vous sera malheureusement considéré comme annulé automatiquement. \r\nMerci de votre compréhension.", "created_at": "2026-04-09T15:03:33.276438", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3374/download", "media_mime_type": "image/jpeg"}, {"id": 13435, "message_id": "3EB07A6ED04B094E5FB1BC", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*BOURAGBA Mohamed*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *vendredi 10 avril 2026* à *17: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لديكم موعد مع ** يوم *الجمعة 10 أبريل 2026* على الساعة *17:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-10T08:42:07.452639", "media_url": null, "media_mime_type": null}, {"id": 13682, "message_id": "A5CF75E115E06FCD87D9EBD567423781", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio:\n\n**Arabic Script (Darija):**\n\"السلام عليكم محمد، كيف نتي مزيان؟ بخير؟ محمد عندك رونديفو اليوم مع الخمسة. فرد عليا أخاي لله، لا، على حساب أنا خديت ليك موعد.\"\n\n**Transliteration (Latin Script):**\n\"Salam o3alaykom Mohamed, kif nti mzyan? Bikhir? Mohamed 3ndek rendez-vous lyoum m3a l-khmsa. Fa rred 3liya a khay llah, la, 3la hsab ana khdit lik maw3id.\"\n\n**Translation (For context):**\n\"Peace be upon you Mohamed, how are you, good? Fine? Mohamed, you have an appointment today at five. So get back to me please, because I have booked an appointment for you.\"", "created_at": "2026-04-10T15:30:34.127179", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3509/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 13685, "message_id": "A5A7BE1EC98ABF76AE92AF4C632FEF51", "sender": "bot", "message_type": "text", "content": "?", "created_at": "2026-04-10T15:47:03.081712", "media_url": null, "media_mime_type": null}, {"id": 13686, "message_id": "A5384461D1067FBD2BDD5F810075DFE0", "sender": "bot", "message_type": "text", "content": "????", "created_at": "2026-04-10T15:48:04.134824", "media_url": null, "media_mime_type": null}, {"id": 13687, "message_id": "AC1ACADBE8DA9EFA4CEFFF2C4B9006D2", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio:\n\n**Arabic Script:**\nالسلام أستاذ، صافي دابا شوية ونكون عندك إن شاء الله، صافي؟\n\n**Latin Script:**\nSalam ostad, safi daba chwiya w nkoun andek incha'Allah, safi?", "created_at": "2026-04-10T15:49:41.426143", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3512/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 13688, "message_id": "bot_AC1ACADBE8DA9EFA4CEFFF2C4B9006D2_2983", "sender": "bot", "message_type": "text", "content": "مرحبا بيك محمد 😊", "created_at": "2026-04-10T15:50:29.810195", "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 939 in training_review_items