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": 43836, "message_id": "A5F51BE8680E4DAC3C0E1358F519F6CF", "sender": "bot", "message_type": "video", "content": "", "created_at": "2026-06-15T16:11:31.409105", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12085/download", "media_mime_type": "video/mp4"}, {"id": 43837, "message_id": "A59EEFF2878CDBB4DF9651FAEEC3BECA", "sender": "bot", "message_type": "video", "content": "", "created_at": "2026-06-15T16:11:33.561822", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12086/download", "media_mime_type": "video/mp4"}, {"id": 43838, "message_id": "A5CDC11D02F6EFF220730630D7A5A3AB", "sender": "bot", "message_type": "video", "content": "", "created_at": "2026-06-15T16:11:34.339527", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12087/download", "media_mime_type": "video/mp4"}, {"id": 43856, "message_id": "3EB0F8115D9440E6332BE3", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*GHARMOUT Youssef*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *jeudi 18 juin 2026* à *18: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لديكم موعد مع ** يوم *الخميس 18 يونيو 2026* على الساعة *18:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-15T16:19:50.365706", "media_url": null, "media_mime_type": null}, {"id": 43941, "message_id": "3EB0F92FC7EBCFC07F42DB", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *5000,00* dirhams (*Espèce*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *+6395,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-06-15T17:48:27.940379", "media_url": null, "media_mime_type": null}, {"id": 43942, "message_id": "3EB0D672D0269B1F436B28", "sender": "bot", "message_type": "document", "content": "2026061518473630.pdf", "created_at": "2026-06-15T17:48:42.766206", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12132/download", "media_mime_type": "application/pdf"}, {"id": 44905, "message_id": "3EB068B7DBC171ACD27604", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*GHARMOUT Youssef*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *jeudi 18 juin 2026* à *18: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لديكم موعد مع ** يوم *الخميس 18 يونيو 2026* على الساعة *18:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-17T15:02:27.045638", "media_url": null, "media_mime_type": null}, {"id": 45037, "message_id": "3EB0F29B97520682FC7AD0", "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 is an illustrated promotional or confirmation graphic for Tanger Bay Dental Center. At the top, there is a logo featuring a stylized tooth with the text 'TANGER BAY DENTAL CENTER.' Below the logo, there are two blue banners. The first reads 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' with a green checkmark, and the second reads 'CHEZ TANGER BAY DENTAL CENTER.' The main visual is a large, smiling, cartoon-like tooth giving a thumbs up, holding a calendar page with a prominent green checkmark. The background is lightly blurred but suggests a dental operatory with a dental chair 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 DENTAL CENTER\",\n    \"VOTRE RENDEZ-VOUS\n\nUser message context: Salut *GHARMOUT Youssef*👋\r\nNous vous confirmons votre rendez-vous avec *DR OUSSAMA MOUALLEM*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *jeudi 18 juin 2026*\r\n🕘 Heure : *18: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-18T07:52:35.890596", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12428/download", "media_mime_type": "image/jpeg"}, {"id": 45188, "message_id": "3EB0DE79821EEC06AD1F39", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*GHARMOUT Youssef*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *lundi 22 juin 2026* à *16: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لديكم موعد مع ** يوم *الأثنين 22 يونيو 2026* على الساعة *16:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-18T11:56:54.810545", "media_url": null, "media_mime_type": null}, {"id": 46842, "message_id": "3EB04CC1212A6A49D0F7E9", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*GHARMOUT Youssef*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *lundi 22 juin 2026* à *16: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لديكم موعد مع ** يوم *الأثنين 22 يونيو 2026* على الساعة *16:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-22T14:38:26.267395", "media_url": null, "media_mime_type": null}, {"id": 46871, "message_id": "2A375D878342AAFBBEAD", "sender": "user", "message_type": "text", "content": "Salem , j’arrive dans 15 min 🙏", "created_at": "2026-06-22T15:03:27.766438", "media_url": null, "media_mime_type": null}, {"id": 46872, "message_id": "bot_2A375D878342AAFBBEAD_1947", "sender": "bot", "message_type": "text", "content": "Bonjour Youssef, merci pour l'information ! Votre rendez-vous avec Dr Oussama Mouallem aujourd'hui à 16h00 est bien noté. À tout à l'heure au centre 😊", "created_at": "2026-06-22T15:03:51.684672", "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 3882 in training_review_items