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": 40427, "message_id": "3EB03FE5E01075357F2A7A", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*BAKKOURI Hayat*\r\nVous avez Rendez Vous avec *Dr. RIAD GUENNOUNI* le *mardi 09 juin 2026* à *17: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*BAKKOURI*\r\nلديكم موعد مع ** يوم *الثلاثاء 9 يونيو 2026* على الساعة *17:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-08T14:27:19.720879", "media_url": null, "media_mime_type": null}, {"id": 40448, "message_id": "3EB0E4175FD707AB302A24", "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 shows a dental-themed digital graphic. In the foreground, there is a cartoon-style tooth character with a smiling face, eyebrows, black eyes, and a wide mouth. The tooth is holding a small notepad with a large green check mark on it, and is giving a thumbs up with its other hand. In the background, a blurred dental clinic environment is visible, including a dental chair and equipment. At the top, there is a blue gradient overlay with the logo of 'Tanger Bay Dental Center' consisting of a stylized tooth and the text 'TANGER BAY DENTAL CENTER'. Below this, there are two blue rectangular captions in French: 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' with a green check mark, and 'CHEZ TANGER BAY DENTAL CENTER'. The overall design conveys a message of appointment confirmation at the dental center.\",\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\n\nUser message context: Salut *BAKKOURI Hayat*👋\r\nNous vous confirmons votre rendez-vous avec *Dr. RIAD GUENNOUNI*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *mardi 09 juin 2026*\r\n🕘 Heure : *17: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-08T15:05:28.607688", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11230/download", "media_mime_type": "image/jpeg"}, {"id": 40469, "message_id": "AC26897C778E3D552DBB9D33028303D6", "sender": "user", "message_type": "text", "content": "Bien noté c'est confirmé pour demain inchallah", "created_at": "2026-06-08T16:09:14.711915", "media_url": null, "media_mime_type": null}, {"id": 40884, "message_id": "3EB0CBC023766B5AE81278", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*BAKKOURI Hayat*\r\nVous avez Rendez Vous avec *Dr. RIAD GUENNOUNI* le *mardi 09 juin 2026* à *17: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*BAKKOURI*\r\nلديكم موعد مع ** يوم *الثلاثاء 9 يونيو 2026* على الساعة *17:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-09T14:41:08.109944", "media_url": null, "media_mime_type": null}, {"id": 40902, "message_id": "AC46071CFA9D931F62611FDBE4FEEEB0", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija:\n\n\"السلام عليكم ألالا، كيديرة مزيان؟ عافاك قبيلة صونيتي عليا على حساب نكونفيرمي ليك الـ rendez-vous وقلت ليك اه، دابا راه كاع ما ساليت من الخدمة، ما غاديش نقدر أنني نوصل مع الـ 5. إلا كان ممكن عافاك تعطيني شي وقيتة أخرى فوسط la semaine وسمحي ليا عافاك بزاف، ما ساليتش من الخدمة والله ما ساليت باش نقدر نلحق لـ 5.\"", "created_at": "2026-06-09T15:08:10.985295", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11340/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 40903, "message_id": "bot_AC46071CFA9D931F62611FDBE4FEEEB0_1990", "sender": "bot", "message_type": "text", "content": "مرحبا Hayat 😊 شكراً بزاف على التوضيح.", "created_at": "2026-06-09T15:08:38.769837", "media_url": null, "media_mime_type": null}, {"id": 40904, "message_id": "bot_AC46071CFA9D931F62611FDBE4FEEEB0_3558", "sender": "bot", "message_type": "text", "content": "فهمت أنك ما غاديش تقدري توصلي مع الـ 5 اليوم بسبب الخدمة، وبغيتي تبدلي الموعد لوقت آخر وسط الأسبوع.", "created_at": "2026-06-09T15:08:38.832554", "media_url": null, "media_mime_type": null}, {"id": 40905, "message_id": "bot_AC46071CFA9D931F62611FDBE4FEEEB0_9618", "sender": "bot", "message_type": "text", "content": "باش نكمل معاك، واش ممكن تعطيني الوقت اللي يناسبك أكثر وسط هاد السيمانة؟ كذلك إذا عندك شي تفضيل بالنسبة للنهار أو الساعة، قوليها ليا.", "created_at": "2026-06-09T15:08:38.900406", "media_url": null, "media_mime_type": null}, {"id": 40906, "message_id": "bot_AC46071CFA9D931F62611FDBE4FEEEB0_5265", "sender": "bot", "message_type": "text", "content": "غادي نبلغ الفريق بطلبك وغادي يتواصلوا معاك إن شاء الله.", "created_at": "2026-06-09T15:08:38.967511", "media_url": null, "media_mime_type": null}, {"id": 40907, "message_id": "bot_AC46071CFA9D931F62611FDBE4FEEEB0_5906", "sender": "bot", "message_type": "text", "content": "دير فبالك أن الموعد غادي يتأكد غير بعد ما يتواصل معاك الفريق مباشرة 🙏🏻", "created_at": "2026-06-09T15:08:39.032032", "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 3325 in training_review_items