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": 4219, "message_id": "3AEA4580B74429A2862A", "sender": "user", "message_type": "text", "content": "Oui", "created_at": "2026-03-13T16:49:16.645031", "media_url": null, "media_mime_type": null}, {"id": 4220, "message_id": "bot_3AEA4580B74429A2862A_5046", "sender": "bot", "message_type": "text", "content": "Parfait ! Comment puis-je vous assister aujourd'hui ? Avez-vous des questions sur nos services, ou souhaitez-vous prendre un rendez-vous ? 😊", "created_at": "2026-03-13T16:49:26.562801", "media_url": null, "media_mime_type": null}, {"id": 4562, "message_id": "3EB0F43A4A9572CBD667A1", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *4400,00* dirhams (*Espèce*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *+5400,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-03-14T13:24:57.771707", "media_url": null, "media_mime_type": null}, {"id": 4563, "message_id": "3EB06A5D62583B2B860153", "sender": "bot", "message_type": "document", "content": "2026031413243993.pdf", "created_at": "2026-03-14T13:25:10.851931", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/778/download", "media_mime_type": "application/pdf"}, {"id": 4611, "message_id": "A5E02A952BB30C36C5E987EB6BD84AE4", "sender": "bot", "message_type": "image", "content": "", "created_at": "2026-03-14T14:33:09.991902", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/784/download", "media_mime_type": "image/jpeg"}, {"id": 7187, "message_id": "A557CA824F91A761CD38DBEBB2BA7BB8", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio:\n\n**Arabic Script (Darija/French mix):**\n\"السلام عليكم ريم، كيدايرة مزيانة بخير؟ ريم قولي فوقاش تكوني ديسبونيبل نهار السبت باش ناخد لورونديفو.\"\n\n**Latin Script:**\n\"Salam alaykoum Rim, kidayra mzyana bikhir? Rim goli fouqach tkouni disponible nhar sebt bach nakhod le rendez-vous.\"\n\n**English Translation (for context):**\n\"Peace be upon you, Rim. How are you? Good? Fine? Rim, tell me when you will be available on Saturday to take the appointment.\"", "created_at": "2026-03-26T18:20:14.927786", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1460/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 7233, "message_id": "3A37EDC628765CE40DC1", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in both Arabic and Latin scripts:\n\n### **Arabic Script**\nالسلام، صا فا؟ بخير؟ كيبقيتي؟ مزيانة؟\nأه، صراحة، le plus tôt possible، ماكرهتش زعما مع التسعود نسالي.\nفهمتي؟ تسعود، تسعود ونص. المهم مع الصباح.\n\n### **Latin Script**\nSalam, ça va? Be-khir? Ki bqiti? Mezyana? \nEuh, saraha, le plus tôt possible, ma krahtsh zaama ma'a t-tes'oud n-sali. \nFhemt? Tes'oud, tes'oud u ness. Mohim ma'a s-sbah.", "created_at": "2026-03-26T19:25:15.809452", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1481/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 7307, "message_id": "3EB0CD8D824B6D20C96A1F", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*HADDIOUI Rym *\r\nVous avez Rendez Vous avec *DR ALAMI MUSTAPHA* le *samedi 28 mars 2026* à *09:45* .\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لديكم موعد مع ** يوم *السبت 28 مارس 2026* على الساعة *09:45*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-03-27T08:24:32.603745", "media_url": null, "media_mime_type": null}, {"id": 7310, "message_id": "3A23CD4E018EFCF3BDD6", "sender": "user", "message_type": "text", "content": "Ok merci", "created_at": "2026-03-27T08:27:52.491949", "media_url": null, "media_mime_type": null}, {"id": 7511, "message_id": "3EB0988693A832FBCAB230", "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 cartoon-like illustration of a tooth character with a smiling face. The tooth is holding a small calendar with a checkmark on it, indicating a confirmed appointment. The background is a dental clinic setting, slightly blurred, with a dental chair visible. The image is overlaid with text in French, and there is a logo at the top.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"none\",\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 EST CONFIRMÉ\",\n    \"CHEZ TANGER BAY DENTAL CENTER\"\n  ],\n  \"possible_concerns\": [],\n  \"service_candidates\": [],\n  \"no_apparent_issue\": {\n    \"value\": true,\n    \"reason\": \"The image is promotional and contains no clinical content.\"\n  },\n\nUser message context: Salut *HADDIOUI Rym *👋\r\nNous vous confirmons votre rendez-vous avec *DR ALAMI MUSTAPHA*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *samedi 28 mars 2026*\r\n🕘 Heure : *09:45*\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-03-27T15:03:06.591785", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/1568/download", "media_mime_type": "image/jpeg"}, {"id": 7733, "message_id": "3A1514FED4A73D0682F3", "sender": "user", "message_type": "text", "content": "Oui", "created_at": "2026-03-27T19:28:27.060693", "media_url": null, "media_mime_type": null}, {"id": 7734, "message_id": "bot_3A1514FED4A73D0682F3_4666", "sender": "bot", "message_type": "text", "content": "Parfait, HADDIOUI Rym! 😊 Votre rendez-vous avec DR ALAMI MUSTAPHA est bien confirmé pour le samedi 28 mars 2026 à 09:45 chez Tanger Bay Dental Center. À bientôt إن شاء الله 🙏🏻", "created_at": "2026-03-27T19:29:02.030597", "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 322 in training_review_items