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": 3356, "message_id": "A56976F3F09DBD0C5F624121937E25E9", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-03-12T11:23:26.094018", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/301/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 3357, "message_id": "A54AAFE5103B21ABD41718F6F7470949", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-03-12T11:23:50.873805", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/302/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 3576, "message_id": "3AAC62C20A041B8BBB7F", "sender": "user", "message_type": "text", "content": "Bonjour , khrajat li ln bali je vais l’envoyer daba", "created_at": "2026-03-12T16:20:21.550058", "media_url": null, "media_mime_type": null}, {"id": 3577, "message_id": "bot_3AAC62C20A041B8BBB7F_9233", "sender": "bot", "message_type": "text", "content": "Bonjour 😊 Je suis là pour vous aider. Pourriez-vous me donner plus de détails sur ce que vous souhaitez envoyer ou si vous avez besoin d'aide avec autre chose ?", "created_at": "2026-03-12T16:20:32.109483", "media_url": null, "media_mime_type": null}, {"id": 3578, "message_id": "4AC5638632C162F00AC7", "sender": "user", "message_type": "image", "content": "", "created_at": "2026-03-12T16:22:07.968140", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/356/download", "media_mime_type": "image/jpeg"}, {"id": 3579, "message_id": "bot_4AC5638632C162F00AC7_1026", "sender": "bot", "message_type": "text", "content": "Merci pour l'information, Mademoiselle Sanaa Jabiri. Je vais transmettre les détails de votre virement à l'équipe du Centre Dentaire Tanger Bay. Si vous avez besoin d'une confirmation ou d'une assistance supplémentaire, n'hésitez pas à me le faire savoir. 😊", "created_at": "2026-03-12T16:22:21.118200", "media_url": null, "media_mime_type": null}, {"id": 3588, "message_id": "3EB0E51B6D7B12389E361F", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *1000,00* dirhams (*Virement*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *-10000,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-03-12T16:37:30.297426", "media_url": null, "media_mime_type": null}, {"id": 3589, "message_id": "3EB0D2E8F65B7E1ACA1429", "sender": "bot", "message_type": "document", "content": "2026031216371092.pdf", "created_at": "2026-03-12T16:37:43.359340", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/359/download", "media_mime_type": "application/pdf"}, {"id": 7154, "message_id": "3EB066B8C88816B4F8FA03", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*JABIRI  Sanaa*\r\nVous avez Rendez Vous avec *Dr. RIAD GUENNOUNI* le *samedi 28 mars 2026* à *10: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لديكم موعد مع ** يوم *السبت 28 مارس 2026* على الساعة *10:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-03-26T17:53:15.763391", "media_url": null, "media_mime_type": null}, {"id": 7513, "message_id": "3EB05485D6D16A66F9DB73", "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 an animated tooth character with a smiling expression, holding a small notepad with a green checkmark, symbolizing confirmation. The background appears to be a blurred dental office setting, possibly with dental chairs and equipment visible, but out of focus. At the top of the image, there is a logo of Tanger Bay Dental Center, which includes a stylized tooth and the text 'TANGER BAY DENTAL CENTER'. Below the logo, the text 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' followed by a green checkmark icon is visible, indicating that an appointment is confirmed. Below this, there is another line of text that reads 'CHEZ TANGER BAY DENTAL CENTER'.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"none\",\n    \"teeth_condition\": [],\n    \"gum_condition\": null,\n    \"bone_level\": null,\n    \"root_canals\": null,\n    \"restorations_visible\": [],\n    \"missing_teeth\": \"none\",\n    \"alignment\": null,\n    \"calculus_plaque\": null,\n    \"periapical_areas\": null,\n    \"other_findings\": null\n  },\n  \"text_visible\": [\n    \"\n\nUser message context: Salut *JABIRI  Sanaa*👋\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 : *10: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-03-27T15:03:19.704647", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1569/download", "media_mime_type": "image/jpeg"}, {"id": 7551, "message_id": "3A2AC59740EE6B653E72", "sender": "user", "message_type": "text", "content": "Oui", "created_at": "2026-03-27T15:13:11.445653", "media_url": null, "media_mime_type": null}, {"id": 7553, "message_id": "bot_3A2AC59740EE6B653E72_9478", "sender": "bot", "message_type": "text", "content": "Parfait 😊 Votre rendez-vous est confirmé le samedi 28 mars 2026 à 10:00 chez Tanger Bay Dental Center. À bientôt إن شاء الله 🙏🏻", "created_at": "2026-03-27T15:13:37.124780", "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 268 in training_review_items