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": 7457, "message_id": "A528FC8BAA21EB5DC82C1AAB2BF88B5B", "sender": "bot", "message_type": "text", "content": "Smagli 5 min n3aytlk", "created_at": "2026-03-27T13:58:45.040374", "media_url": null, "media_mime_type": null}, {"id": 7458, "message_id": "3A45E047E543344FF622", "sender": "user", "message_type": "text", "content": "‏أوك", "created_at": "2026-03-27T13:58:59.584250", "media_url": null, "media_mime_type": null}, {"id": 7521, "message_id": "3EB092B87B1791D4FBE684", "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 depicts a digital illustration featuring a smiling cartoon tooth character holding a notepad with a green checkmark symbol. The background appears to be an interior dental clinic setting with dental equipment. There is a logo at the top showing a stylized tooth with the text 'TANGER BAY DENTAL CENTER'. Below are two text lines in French, 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' and 'CHEZ TANGER BAY DENTAL CENTER', each highlighted by blue banners.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"none\",\n    \"teeth_condition\": [],\n    \"gum_condition\": \"\",\n    \"bone_level\": null,\n    \"root_canals\": null,\n    \"restorations_visible\": [],\n    \"missing_teeth\": \"\",\n    \"alignment\": \"\",\n    \"calculus_plaque\": \"\",\n    \"periapical_areas\": \"\",\n    \"other_findings\": \"\"\n  },\n  \"text_visible\": [\n    \"TANGER BAY DENTAL CENTER\",\n    \"VOTRE RENDEZ-VOUS EST CONFIRMÉ\",\n    \"CHEZ TANGER BAY DENTAL CENTER\"\n  ],\n  \"possible_concerns\": [],\n  \"service_candidates\": [],\n\nUser message context: Salut *EL BEGHDADI Soufiane*👋\r\nNous vous confirmons votre rendez-vous avec *DR ALAMI MUSTAPHA*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *samedi 28 mars 2026*\r\n🕘 Heure : *11:45*\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-03-27T15:04:12.389852", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1573/download", "media_mime_type": "image/jpeg"}, {"id": 7530, "message_id": "3A201269DD326742D491", "sender": "user", "message_type": "text", "content": "11:45 mxi 12:45 safi", "created_at": "2026-03-27T15:05:20.476133", "media_url": null, "media_mime_type": null}, {"id": 7666, "message_id": "3A1AE8810470C3C55469", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija (Arabic and Latin scripts):\n\n### **Arabic Script**\nعافاك فاش قبيلة ملي هضرت معاك، قلتي لي مع ال 12 و 45. ودبا قريت هنايا الميساج اللي صردتي لي 11 و 45. واش نجي في ال 11 و 45 أولا مع ال 12 و 45؟ عافاك وخا تجاوبني؟\n\n### **Latin Script**\nAfak fach qbila melli hdert m’ak, qolti li m’a l-12 u khmsa u rb’in. U daba qrit hnaya l-message li sardti li 11 u khmsa u rb’in. Wash nji f l-11 u khmsa u rb’in awla m’a l-12 u khmsa u rb’in? Afak wakha tjawbni?\n\n### **English Translation (for context)**\n\"Please, when I spoke to you earlier, you told me at 12:45. And now I’ve read here in the message you sent me 11:45. Should I come at 11:45 or at 12:45? Please, can you answer me?\"", "created_at": "2026-03-27T16:29:09.329467", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1605/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 7667, "message_id": "bot_3A1AE8810470C3C55469_5766", "sender": "bot", "message_type": "text", "content": "مرحبا! 😊 كنعتدر على اللبس. الموعد ديالك مع *DR ALAMI MUSTAPHA* هو في الحقيقة على الساعة *11:45* يوم السبت 28 مارس 2026. نتسناوكوم إن شاء الله في الوقت المحدد. إذا كان عندك شي سؤال آخر، مرحبا بك!", "created_at": "2026-03-27T16:29:44.519487", "media_url": null, "media_mime_type": null}, {"id": 7668, "message_id": "A5A558DC27B39E7449B53C2F87A435F2", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija:\n\n**Arabic Script:**\n\"ختي كي جيتي لمدينة بخير؟ آه حتى لـ 11:45، آه سمحي لي، أنا غلطت بغيت نقول لك حتى لـ 11:45 وقلت لك حتى لـ 12:45.\"\n\n**Latin Script (Transliteration):**\n\"Khti ki jiti lmdina bikher? Ah hta l 11:45, ah smhi li, ana ghlat bghit ngoul lk hta l 11:45 w glt lk hta l 12:45.\"", "created_at": "2026-03-27T16:30:09.586443", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1606/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 7669, "message_id": "3A418A3B9968BB1DDA62", "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:**\nSafi khti, wakha. Ziana, mzyana. Hayt m3a lwe7da makaynach, yak? Ana makrahtch koun kant m3a lwe7da, sa3a makaynach, safi insha'Allah. Yallah khti.\n\n**English Translation (for context):**\n\"Alright sister, okay. Good, good. Since at one o'clock she’s not there, right? I wouldn’t have minded if it were at one o'clock, but since she's not there, okay, God willing. Bye sister.\"", "created_at": "2026-03-27T16:30:42.553075", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1607/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 7675, "message_id": "A5CDF68508A2711F351AD8CACF17E238", "sender": "bot", "message_type": "text", "content": "Marhba bik", "created_at": "2026-03-27T16:47:02.140582", "media_url": null, "media_mime_type": null}, {"id": 7676, "message_id": "A525695F0128B24EBE5A3775FDDE72CC", "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 (Transcription):**\n\"Lah wallah ma kayna 3ndi 3amra, qasaman bi lah.\"\n\n**Translation (for context):**\n\"No, I swear to God, I don't have it full, I swear by God.\"", "created_at": "2026-03-27T16:47:21.517851", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1608/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 7677, "message_id": "3AED509366A3A39743C7", "sender": "user", "message_type": "text", "content": "اها صفي احبيبتي", "created_at": "2026-03-27T16:47:57.794212", "media_url": null, "media_mime_type": null}, {"id": 7679, "message_id": "bot_3AED509366A3A39743C7_2234", "sender": "bot", "message_type": "text", "content": "مرحبا بك! 😊 إذا كان عندك أي استفسار آخر أو محتاجة شي حاجة، أنا هنا رهن الإشارة ديالك. نهارك مبروك!", "created_at": "2026-03-27T16:48:32.844265", "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 306 in training_review_items