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": 11260, "message_id": "3EB0BAB48AA87F323B41C6", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*MVUMBI YOUSSOUF*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *lundi 06 avril 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لديكم موعد مع ** يوم *الأثنين 6 أبريل 2026* على الساعة *10:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-03T09:51:12.563897", "media_url": null, "media_mime_type": null}, {"id": 11261, "message_id": "3EB0B3BCE259EE42E27B8F", "sender": "bot", "message_type": "document", "content": "_radios_MVUMBI YOUSSOUF_20260403_10521356.pdf", "created_at": "2026-04-03T09:52:32.023211", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2737/download", "media_mime_type": "application/pdf"}, {"id": 11262, "message_id": "3EB0FCC00A924C9E55E1BA", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *700,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-04-03T09:53:11.264732", "media_url": null, "media_mime_type": null}, {"id": 11263, "message_id": "3EB0E640A720C5D82B31B0", "sender": "bot", "message_type": "document", "content": "2026040310530830.pdf", "created_at": "2026-04-03T09:53:24.017226", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2738/download", "media_mime_type": "application/pdf"}, {"id": 12312, "message_id": "3EB0593B705C6685D7197A", "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 digital illustration depicting a smiling cartoon tooth with expressive eyes, eyebrows, a mouth, and a thumbs-up gesture. The tooth is holding a spiral notepad with a large green checkmark on it, symbolizing confirmation. In the background, there is a blurred scene of a dental clinic, with a dental chair and equipment visible but not in focus. At the top, there is branding with the logo 'TANGER BAY DENTAL CENTER' featuring a stylized tooth icon. Overlay text in French reads: 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' (translation: YOUR APPOINTMENT IS CONFIRMED) with a green checkmark, and below it, 'CHEZ TANGER BAY DENTAL CENTER' (translation: AT TANGER BAY DENTAL CENTER). The overall color scheme is light blue and white, conveying a clean and friendly clinic atmosphere.\",\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\nUser message context: Salut *MVUMBI YOUSSOUF*👋\r\nNous vous confirmons votre rendez-vous avec *DR OUSSAMA MOUALLEM*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *lundi 06 avril 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-04-05T10:38:07.577087", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3094/download", "media_mime_type": "image/jpeg"}, {"id": 12340, "message_id": "ACA08FCDFE406A7B32376EAA9F60F0C3", "sender": "user", "message_type": "text", "content": "Oui", "created_at": "2026-04-05T10:43:56.781768", "media_url": null, "media_mime_type": null}, {"id": 12342, "message_id": "bot_ACA08FCDFE406A7B32376EAA9F60F0C3_6431", "sender": "bot", "message_type": "text", "content": "Merci beaucoup pour votre confirmation, MVUMBI YOUSSOUF 😊\n\nVotre rendez-vous du lundi 06 avril 2026 à 10:00 avec Dr Oussama Mouallem est bien confirmé chez Tanger Bay Dental Center.\n\nSi vous avez la moindre question ou besoin d’aide, n’hésitez pas à nous contacter. À très bientôt !", "created_at": "2026-04-05T10:44:31.920286", "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 802 in training_review_items