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": 10521, "message_id": "bot_3ABCBD5E45BD70A7F7BD_7373", "sender": "bot", "message_type": "text", "content": "Merci beaucoup pour votre confirmation Samar 😊\n\nNous vous attendrons demain, vendredi 3 avril à 11:00 إن شاء الله. Si jamais vous avez un empêchement, n'hésitez pas à contacter la réception au 060022263.\n\nÀ très bientôt au Centre Dentaire Tanger Bay !", "created_at": "2026-04-02T09:51:38.548651", "media_url": null, "media_mime_type": null}, {"id": 10877, "message_id": "3EB0FA67601EF2035A0C11", "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 features a digitally created, smiling cartoon tooth character with expressive eyes and eyebrows. The tooth is holding a notepad with a large green check mark and is giving a thumbs-up gesture. The background is a blurred dental clinic setting, with dental chairs and equipment faintly visible, suggesting a professional environment. At the top, the logo 'TANGER BAY DENTAL CENTER' is present, which includes a stylized tooth and the clinic name below it. There are two large, bolded blue banners. The first states 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' with a green check mark, and the second says 'CHEZ TANGER BAY DENTAL CENTER'. The overall color scheme is light and clinical, mainly blues and whites.\",\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    \"other_findings\": null\n  },\n\nUser message context: Salut *EL FARZAZI  Samar*👋\r\nNous vous confirmons votre rendez-vous avec *Dr. Haitham Boutaib*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *vendredi 03 avril 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-04-02T15:03:51.500557", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2615/download", "media_mime_type": "image/jpeg"}, {"id": 11312, "message_id": "3EB0C09CFE5E5F9D65EDB3", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *1400,00* dirhams (*TPE*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *+1000,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-04-03T11:09:26.616374", "media_url": null, "media_mime_type": null}, {"id": 11313, "message_id": "3EB0A8D53BFEED451FBC1C", "sender": "bot", "message_type": "document", "content": "2026040312092332.pdf", "created_at": "2026-04-03T11:09:39.271775", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2752/download", "media_mime_type": "application/pdf"}, {"id": 11324, "message_id": "3EB066BA95FD84AA208F71", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*EL FARZAZI BENTATOU Samar*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *jeudi 09 avril 2026* à *15: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لديكم موعد مع ** يوم *الخميس 9 أبريل 2026* على الساعة *15:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-03T11:13:20.968935", "media_url": null, "media_mime_type": null}, {"id": 11325, "message_id": "A568ECC5F756E89E54B533CDEFD192A3", "sender": "bot", "message_type": "document", "content": "conseil post operatoire copy_250728_110705.pdf", "created_at": "2026-04-03T11:14:34.643738", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2754/download", "media_mime_type": "application/pdf"}, {"id": 11326, "message_id": "A530FC8986FE9E1BC096062BF29ADCE7", "sender": "bot", "message_type": "video", "content": "", "created_at": "2026-04-03T11:14:44.134426", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2755/download", "media_mime_type": "video/mp4"}, {"id": 11327, "message_id": "A51EF4B49FAA34C77CD282F3A2F3A84F", "sender": "bot", "message_type": "video", "content": "", "created_at": "2026-04-03T11:14:54.564572", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2756/download", "media_mime_type": "video/mp4"}, {"id": 11328, "message_id": "A52F10875EDEA4F52DFFDD61C49F87CA", "sender": "bot", "message_type": "video", "content": "sardolo hta had videos o khbeoohm endkom", "created_at": "2026-04-03T11:14:55.038766", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2757/download", "media_mime_type": "video/mp4"}, {"id": 11329, "message_id": "A54131897ED25088CF03C5B84D73BC04", "sender": "bot", "message_type": "video", "content": "", "created_at": "2026-04-03T11:14:55.044987", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2758/download", "media_mime_type": "video/mp4"}, {"id": 11888, "message_id": "3A7832A5A464D666FF90", "sender": "user", "message_type": "text", "content": "3afak khti", "created_at": "2026-04-04T11:46:21.100531", "media_url": null, "media_mime_type": null}, {"id": 11889, "message_id": "bot_3A7832A5A464D666FF90_5749", "sender": "bot", "message_type": "text", "content": "Bonjour ! 😊 Je suis là pour vous aider. Pouvez-vous préciser ce dont vous avez besoin ou votre question concernant les vidéos ?", "created_at": "2026-04-04T11:46:39.911213", "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 761 in training_review_items