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": 8095, "message_id": "AC98E35224948BA30A97DBC83ECE087A", "sender": "user", "message_type": "text", "content": "<reply_to> </reply_to> Ok on va la faire", "created_at": "2026-03-28T13:55:46.768549", "media_url": null, "media_mime_type": null}, {"id": 8113, "message_id": "A5571EC0850CF18A2FAB36D32401B7BD", "sender": "bot", "message_type": "text", "content": "Merci", "created_at": "2026-03-28T14:35:54.036954", "media_url": null, "media_mime_type": null}, {"id": 9494, "message_id": "3EB0D7DB009B8A52257987", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*MIRONOV Misho*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *jeudi 02 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لديكم موعد مع ** يوم *الخميس 2 أبريل 2026* على الساعة *10:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-03-31T14:10:45.318592", "media_url": null, "media_mime_type": null}, {"id": 9495, "message_id": "ACA45BA76B8F0406DAB625632117F617", "sender": "user", "message_type": "text", "content": "Ok", "created_at": "2026-03-31T14:12:33.261091", "media_url": null, "media_mime_type": null}, {"id": 10040, "message_id": "3EB050B624695E12DCDC97", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*MIRONOV Misho*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *jeudi 02 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لديكم موعد مع ** يوم *الخميس 2 أبريل 2026* على الساعة *10:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-01T11:45:41.427411", "media_url": null, "media_mime_type": null}, {"id": 10055, "message_id": "AC37C92C830A65D1B77389A6F4AA4E39", "sender": "user", "message_type": "text", "content": "Oui", "created_at": "2026-04-01T11:55:04.792649", "media_url": null, "media_mime_type": null}, {"id": 10114, "message_id": "3EB08E7AD2ADA27D981A76", "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 a promotional or notification graphic for Tanger Bay Dental Center. It features a large cartoon tooth character with a smiling face, giving a thumbs up. The character is holding a small calendar with a large green checkmark on it, signifying confirmation or approval. In the background, a dental clinic room is visible but blurred, showing dental equipment and a dental chair. At the top of the image, there is a stylized tooth logo with 'TANGER BAY DENTAL CENTER' underneath. Two blue banners contain white text: 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' with a checkmark icon, and 'CHEZ TANGER BAY DENTAL CENTER'.\",\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    \"VOT\n\nUser message context: Salut *MIRONOV Misho*👋\r\nNous vous confirmons votre rendez-vous avec *Dr. Haitham Boutaib*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *jeudi 02 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-01T15:02:25.982855", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2391/download", "media_mime_type": "image/jpeg"}, {"id": 10116, "message_id": "AC27043CCEFB539F99600C77D00CCEFC", "sender": "user", "message_type": "text", "content": "Oui", "created_at": "2026-04-01T15:02:43.782994", "media_url": null, "media_mime_type": null}, {"id": 10489, "message_id": "3EB04AA9DD245EF97E2A7A", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *13000,00* dirhams (*Espèce*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *+27900,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-04-02T09:26:11.787231", "media_url": null, "media_mime_type": null}, {"id": 10490, "message_id": "3EB04A820B7E1CCBF5FB86", "sender": "bot", "message_type": "document", "content": "2026040210252887.pdf", "created_at": "2026-04-02T09:26:24.811565", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2531/download", "media_mime_type": "application/pdf"}, {"id": 10719, "message_id": "3EB0ADE2BF573EEB25A1D3", "sender": "user", "message_type": "text", "content": "bonjour. Misho a RDV Demain a quel heure?", "created_at": "2026-04-02T12:35:28.889449", "media_url": null, "media_mime_type": null}, {"id": 10720, "message_id": "bot_3EB0ADE2BF573EEB25A1D3_3503", "sender": "bot", "message_type": "text", "content": "Bonjour 😊\n\nVotre rendez-vous avec Dr Haitham Boutaib est bien confirmé pour demain, jeudi 02 avril 2026 à 10:00, au Centre Dentaire Tanger Bay.\n\nAdresse : Résidence Borj Khalij 3, Étage 5, Appartement 197 – Avenue Mohammed VI, Tanger (près de Café Sky17)\n\nSi vous avez d’autres questions, je reste à votre disposition !", "created_at": "2026-04-02T12:35:54.748067", "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 634 in training_review_items