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": 39549, "message_id": "3EB01EBF4FA749678A78D7", "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 shows a digital illustration in a dental clinic context. There is a cartoon tooth character with big eyes and a smiling mouth, holding a small calendar or note with a green checkmark. The tooth is giving a thumbs up. In the background, there is a blurred dental office with a dental chair, cabinets, and equipment. At the top, there is a dental logo with the text 'TANGER BAY DENTAL CENTER.' The text ‘VOTRE RENDEZ-VOUS EST CONFIRMÉ’ is prominently shown, along with 'CHEZ TANGER BAY DENTAL CENTER.' The illustration uses soft, light blue colors and is inviting and friendly in tone. No real people, real teeth, or clinical findings are visible.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"unclear\",\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\n\nUser message context: Salut *HAKIMA Kaddiri*👋\r\nNous vous confirmons votre rendez-vous avec *DR OUSSAMA MOUALLEM*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *samedi 06 juin 2026*\r\n🕘 Heure : *11: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-06-05T18:09:39.945018", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11011/download", "media_mime_type": "image/jpeg"}, {"id": 39689, "message_id": "3EB08C6893191B9AA58513", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*HAKIMA Kaddiri*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *samedi 06 juin 2026* à *11: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*HAKIMA*\r\nلديكم موعد مع ** يوم *السبت 6 يونيو 2026* على الساعة *11:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-06T09:02:10.604364", "media_url": null, "media_mime_type": null}, {"id": 39768, "message_id": "3EB0437FAAFEA1E1C8B1CB", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *400,00* dirhams (*Espèce*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *-0,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-06-06T11:10:19.284105", "media_url": null, "media_mime_type": null}, {"id": 39769, "message_id": "3EB02EF9EA93A87DCC148A", "sender": "bot", "message_type": "document", "content": "2026060612090408.pdf", "created_at": "2026-06-06T11:10:41.174306", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11082/download", "media_mime_type": "application/pdf"}, {"id": 39770, "message_id": "3EB0E67C12FE6B4C8ECBBA", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*KADDIRI  Hakima*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *lundi 08 juin 2026* à *11:30* .\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لديكم موعد مع ** يوم *الأثنين 8 يونيو 2026* على الساعة *11:30*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-06T11:11:52.307762", "media_url": null, "media_mime_type": null}, {"id": 39789, "message_id": "3EB0F554E36AFD816FA318", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *400,00* dirhams (*TPE*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *-0,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-06-06T11:41:22.512249", "media_url": null, "media_mime_type": null}, {"id": 39790, "message_id": "3EB053E721A8F2464882D9", "sender": "bot", "message_type": "document", "content": "2026060612404272.pdf", "created_at": "2026-06-06T11:41:46.102812", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11087/download", "media_mime_type": "application/pdf"}, {"id": 40286, "message_id": "3A8DAD1BD8215E9E3B9F", "sender": "user", "message_type": "voice", "content": "[Voice message] Sure! Here is the transcription of the audio in Moroccan Darija:\n\n\"السلام عليكم ورحمة الله، بنتي أنا بغيت نقول ليك حنا راه جايين في الطريق، شوية د الزحام في الطريق، ها حنا جايين، صافي؟ ونتلاقاو عندكم إن شاء الله بإذن الله.\"\n\n**Latin Script Transcription:**\n\"Assalamu alaykum wa rahmatullah, benti ana bghit ngoul lik hna rah jayin f triq, chwiya d zham f triq, ha hna jayin, safi? O ntlaqaw andkoum insha'Allah bi'idni Allah.\"", "created_at": "2026-06-08T09:54:32.286463", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11183/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 40287, "message_id": "bot_3A8DAD1BD8215E9E3B9F_9305", "sender": "bot", "message_type": "text", "content": "مرحبا بيكوم، شكراً على الإخبار 😊 نتسناوكوم على خير إن شاء الله. الطريق السلامة!", "created_at": "2026-06-08T09:54:55.112759", "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 3268 in training_review_items