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": 35563, "message_id": "AC4EB11EF6F825417E9D85157B9B8A42", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija:\n\n**Arabic Script:**\n\"السلام اختي، بيخير؟ صيفطي ليا داك الدوفي الله يكبر بيك ديال داكشي لي بغيت نصاوب.\"\n\n**Latin Script (Transliteration):**\n\"Salam khti, bikhir? Sifti liya dak el devis Allah ikbar bik dyal dakchi li bghit nsawb.\"\n\n**Language breakdown:**\n*   **Darija:** Most of the sentence.\n*   **French:** \"Devis\" (meaning quote or estimate).", "created_at": "2026-05-26T13:41:05.730627", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10028/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 35570, "message_id": "A5AE29DCE65E840B384996BB11001067", "sender": "bot", "message_type": "text", "content": "Ok", "created_at": "2026-05-26T14:01:16.567105", "media_url": null, "media_mime_type": null}, {"id": 45382, "message_id": "3EB018CF215291C2D5AF14", "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 cheerful cartoon tooth character with facial features (eyes, eyebrows, smiling mouth) giving a thumbs up and holding a small calendar or notepad with a large green checkmark. The background appears to be a dental clinic room, blurred, with a dental chair visible on the left. At the top of the image, a logo resembling a white tooth and the words 'TANGER BAY DENTAL CENTER' are present. Overlaid blue banners contain French text confirming an appointment at 'TANGER BAY DENTAL CENTER.' The overall color scheme is light blue and white, creating a friendly and welcoming atmosphere.\",\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    \"other_findings\": null\n  },\n  \"text_visible\": [\n    \"TANGER BAY DENTAL CENTER\",\n    \"VOTRE RENDEZ-VOUS EST CONFIRMÉ\n\nUser message context: Salut *REDOUANE Azemlal*👋\r\nNous vous confirmons votre rendez-vous avec *Dr. Haitham Boutaib*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *vendredi 19 juin 2026*\r\n🕘 Heure : *16: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-18T15:04:35.895704", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12562/download", "media_mime_type": "image/jpeg"}, {"id": 45398, "message_id": "3EB056A916D343754F9951", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*REDOUANE Azemlal*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *vendredi 19 juin 2026* à *15: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لديكم موعد مع ** يوم *الجمعة 19 يونيو 2026* على الساعة *15:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-18T15:19:40.449448", "media_url": null, "media_mime_type": null}, {"id": 45875, "message_id": "ACF00CF8B5615D1C8D0FCC93734B9F2C", "sender": "user", "message_type": "voice", "content": "[Voice message] هذا هو تفريغ التسجيل الصوتي بالدارجة المغربية:\n\n**\"السلام اختي، بخير، لاباس، كولشي مزيان؟ إيه.. راه غانجي، غدا نعطيك الموعد اللي غانجي فيه، صافي؟ راه غير سافرت لمراكش داكشي علاش، صافي؟\"**", "created_at": "2026-06-19T20:53:07.554614", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12724/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 45876, "message_id": "bot_ACF00CF8B5615D1C8D0FCC93734B9F2C_1598", "sender": "bot", "message_type": "text", "content": "مرحبا أ سي REDOUANE 😊 شكراً بزاف على التواصل ديالك.", "created_at": "2026-06-19T20:54:31.733996", "media_url": null, "media_mime_type": null}, {"id": 45877, "message_id": "bot_ACF00CF8B5615D1C8D0FCC93734B9F2C_9027", "sender": "bot", "message_type": "text", "content": "سجلت بأنك كنتي مسافر لمراكش وغادي تعطي الوقت اللي مناسبك من بعد.", "created_at": "2026-06-19T20:54:31.779678", "media_url": null, "media_mime_type": null}, {"id": 45878, "message_id": "bot_ACF00CF8B5615D1C8D0FCC93734B9F2C_4833", "sender": "bot", "message_type": "text", "content": "يلا بغيت تبدل الموعد أو تلغي، غير خبرنا باش نبلغو الفريق.", "created_at": "2026-06-19T20:54:31.825238", "media_url": null, "media_mime_type": null}, {"id": 45879, "message_id": "bot_ACF00CF8B5615D1C8D0FCC93734B9F2C_9858", "sender": "bot", "message_type": "text", "content": "يلا بغيت تأكد حضورك ولا تبدل الوقت، قولي ليا شنو مناسبك وغادي نبلغ الفريق إن شاء الله.", "created_at": "2026-06-19T20:54:31.865361", "media_url": null, "media_mime_type": null}, {"id": 45880, "message_id": "AC063BD35FDED2893BF5109968DE763A", "sender": "user", "message_type": "text", "content": "سلام اختي يوم الاتنين نحي", "created_at": "2026-06-19T20:55:48.615863", "media_url": null, "media_mime_type": null}, {"id": 45881, "message_id": "bot_AC063BD35FDED2893BF5109968DE763A_6631", "sender": "bot", "message_type": "text", "content": "مرحبا أ سي REDOUANE 😊 بغيت تبدل الموعد ديالك ليوم الاثنين، صحيح؟ واش ممكن تعطيني الوقت اللي مناسبك نهار الاثنين؟\n\nغادي نبلغ الفريق وغادي يتواصلوا معاك إن شاء الله باش يأكدو الموعد الجديد.", "created_at": "2026-06-19T20:56:00.226945", "media_url": null, "media_mime_type": null}, {"id": 45882, "message_id": "bot_AC063BD35FDED2893BF5109968DE763A_5740", "sender": "bot", "message_type": "text", "content": "دير فبالك أن الموعد غادي يتأكد غير بعد ما يتواصل معاك الفريق مباشرة 🙏🏻", "created_at": "2026-06-19T20:56:00.275151", "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 3784 in training_review_items