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": 11908, "message_id": "3EB0BE489C7E64445E3E73", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*EL IDRISSI Ilham*\r\nVous avez Rendez Vous avec *DR ALAMI MUSTAPHA* le *samedi 18 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لديكم موعد مع ** يوم *السبت 18 أبريل 2026* على الساعة *12:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-04T12:05:15.699843", "media_url": null, "media_mime_type": null}, {"id": 11918, "message_id": "3EB056ECC2FF94A538B9F6", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *1000,00* dirhams (*Virement*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *-10000,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-04-04T12:07:29.017172", "media_url": null, "media_mime_type": null}, {"id": 11919, "message_id": "3EB0599A60FCBBF8BFCDC3", "sender": "bot", "message_type": "document", "content": "2026040413072626.pdf", "created_at": "2026-04-04T12:07:41.864395", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/2965/download", "media_mime_type": "application/pdf"}, {"id": 18460, "message_id": "3EB0091E0345694CFDB443", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*EL IDRISSI Ilham*\r\nVous avez Rendez Vous avec *DR ALAMI MUSTAPHA* le *samedi 25 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لديكم موعد مع ** يوم *السبت 25 أبريل 2026* على الساعة *12:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-24T12:21:29.298642", "media_url": null, "media_mime_type": null}, {"id": 18595, "message_id": "ACF232E65D98AF35D26FBE29D8F4BDCC", "sender": "user", "message_type": "text", "content": "Ok", "created_at": "2026-04-24T14:26:08.654230", "media_url": null, "media_mime_type": null}, {"id": 18641, "message_id": "3EB0FCD644CC36C0AC9D41", "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 dental-themed promotional graphic. There is a large cartoon tooth with a smiling face, large eyes, and eyebrows. The tooth is holding a small calendar or checklist with a green check mark, and it is giving a thumbs-up gesture. In the background, a dental office setting is visible but out of focus, showing elements like a dental chair and cabinets. At the top of the image, there is a logo with the text 'Tanger Bay Dental Center' below a stylized tooth graphic. Overlay text in French reads: 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' with a green checkmark, and below it, 'CHEZ TANGER BAY DENTAL CENTER'. Overall, the scene is bright, modern, and welcoming in tone, with a blue and white color scheme.\",\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\nUser message context: Salut *EL IDRISSI Ilham*👋\r\nNous vous confirmons votre rendez-vous avec *DR ALAMI MUSTAPHA*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *samedi 25 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-24T15:05:35.387957", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/5168/download", "media_mime_type": "image/jpeg"}, {"id": 18651, "message_id": "AC85DC2BA702AD5A635E66D3F3BEA3A0", "sender": "user", "message_type": "text", "content": "Oui", "created_at": "2026-04-24T15:12:42.628967", "media_url": null, "media_mime_type": null}, {"id": 19111, "message_id": "AC102B26C151B43C4108FE96FDE7FF88", "sender": "user", "message_type": "text", "content": "Je suis en retard de 15min", "created_at": "2026-04-25T10:52:59.358110", "media_url": null, "media_mime_type": null}, {"id": 19125, "message_id": "A5939C65938935029ADDFFE2A47094FB", "sender": "bot", "message_type": "voice", "content": "[Voice message] السلام عليكم، بخير؟ المهم خيي، حاول ما تعطّلش كتر.", "created_at": "2026-04-25T11:03:56.725386", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/5339/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 19301, "message_id": "AC8E74FB48F0A776B82B7C456DB89A45", "sender": "user", "message_type": "document", "content": "AvisOperationInstantanePDF-5.pdf", "created_at": "2026-04-25T20:17:14.891299", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/5411/download", "media_mime_type": "application/pdf"}, {"id": 19744, "message_id": "ACD72852E1A1B11348589014736B39BD", "sender": "user", "message_type": "text", "content": "<reply_to>[Document]</reply_to> Bjr voilà le reçu de virement", "created_at": "2026-04-27T11:04:44.151474", "media_url": null, "media_mime_type": null}, {"id": 19749, "message_id": "bot_ACD72852E1A1B11348589014736B39BD_1367", "sender": "bot", "message_type": "text", "content": "Bonjour Ilham 😊 Merci d'avoir envoyé le reçu de virement. J'ai transmis votre document à l'équipe pour vérification, ils vont vous recontacter très bientôt إن شاء الله 🙏🏻", "created_at": "2026-04-27T11:05:13.167570", "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 1500 in training_review_items