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": 12751, "message_id": "ACD2D9A66521473F6EA59FED48A186FC", "sender": "user", "message_type": "text", "content": "👍🙏", "created_at": "2026-04-08T17:20:05.519904", "media_url": null, "media_mime_type": null}, {"id": 13086, "message_id": "3EB0F7EF32BD36656F1945", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *3000,00* dirhams (*Espèce*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *-600,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-04-09T12:44:07.084209", "media_url": null, "media_mime_type": null}, {"id": 13087, "message_id": "3EB0C053F35EB693D4D5BF", "sender": "bot", "message_type": "document", "content": "2026040913435657.pdf", "created_at": "2026-04-09T12:44:28.822079", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3336/download", "media_mime_type": "application/pdf"}, {"id": 13092, "message_id": "3EB0752AF931D78FDFA044", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*GMIRA  Faouzia *\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *samedi 11 avril 2026* à *12: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لديكم موعد مع ** يوم *السبت 11 أبريل 2026* على الساعة *12:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-09T12:58:36.811495", "media_url": null, "media_mime_type": null}, {"id": 13643, "message_id": "3EB0523E69592413E73C2B", "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 with a dental theme. In the foreground, there is a large cartoon tooth character with a smiling face, black eyes, and raised eyebrows. The tooth is holding a small flip calendar or appointment card with a green check mark on it, indicating confirmation. The character is giving a thumbs-up gesture. The background appears to be the interior of a dental clinic, with blurred-out elements including a dental chair and other dental furniture in shades of light blue and white. At the top of the image, the logo for 'Tanger Bay Dental Center' is visible, consisting of a stylized tooth outline and text. There are two blue banners with white text across the upper half: 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' (your appointment is confirmed) with a green check mark icon, and 'CHEZ TANGER BAY DENTAL CENTER'. The overall color theme is calming and professional.\",\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\nUser message context: Salut *GMIRA  Faouzia *👋\r\nNous vous confirmons votre rendez-vous avec *DR OUSSAMA MOUALLEM*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *samedi 11 avril 2026*\r\n🕘 Heure : *12: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-10T15:05:35.360706", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3504/download", "media_mime_type": "image/jpeg"}, {"id": 13668, "message_id": "3EB0895F7B67CC7BA08491", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*GMIRA  Faouzia *\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *samedi 11 avril 2026* à *12: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لديكم موعد مع ** يوم *السبت 11 أبريل 2026* على الساعة *12:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-10T15:13:29.967937", "media_url": null, "media_mime_type": null}, {"id": 13728, "message_id": "AC63E60BF5E5F33377283C363C57E84D", "sender": "user", "message_type": "text", "content": "👍🙏🙏", "created_at": "2026-04-10T16:44:02.716523", "media_url": null, "media_mime_type": null}, {"id": 13729, "message_id": "AC841BD997B058AF08863DB33717D2C6", "sender": "user", "message_type": "text", "content": "Bien entendu,je serai là inchallah", "created_at": "2026-04-10T16:44:26.057153", "media_url": null, "media_mime_type": null}, {"id": 14078, "message_id": "3EB064650E42A7C5388B6C", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *3100,00* dirhams (*Espèce*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *+2500,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-04-11T13:40:44.007062", "media_url": null, "media_mime_type": null}, {"id": 14079, "message_id": "3EB066256C9AC82584DF58", "sender": "bot", "message_type": "document", "content": "2026041114403016.pdf", "created_at": "2026-04-11T13:41:11.868007", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/3649/download", "media_mime_type": "application/pdf"}, {"id": 15468, "message_id": "AC7F3F74956AF53CCE77497C0D3F802C", "sender": "user", "message_type": "text", "content": "+212 661-303609,voici le numéro de Sakina. Merci.", "created_at": "2026-04-14T11:37:52.573529", "media_url": null, "media_mime_type": null}, {"id": 15469, "message_id": "bot_AC7F3F74956AF53CCE77497C0D3F802C_9668", "sender": "bot", "message_type": "text", "content": "Merci beaucoup pour le numéro de Sakina. L’équipe reste à votre service pour toute question ou besoin supplémentaire إن شاء الله. Si vous souhaitez prendre un rendez-vous ou avez une demande particulière, n’hésitez pas à me le dire !", "created_at": "2026-04-14T11:38:13.986708", "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 1129 in training_review_items