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": 23421, "message_id": "3AC497650084652D409E", "sender": "user", "message_type": "text", "content": "Fennich Soufiane", "created_at": "2026-05-04T14:42:57.692146", "media_url": null, "media_mime_type": null}, {"id": 23425, "message_id": "bot_3AC497650084652D409E_9543", "sender": "bot", "message_type": "text", "content": "مرحبا Soufiane 😊 وصل الطلب ديالك، والفريق غادي يتواصلوا معاك باش يأكدو الموعد إن شاء الله.\nدير فبالك أن الموعد غادي يتأكد غير بعد ما يتواصل معاك الفريق مباشرة 🙏🏻", "created_at": "2026-05-04T14:43:14.261697", "media_url": null, "media_mime_type": null}, {"id": 23426, "message_id": "3EB0C0F63327BFA05074C1", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*FENNICH SOUFIANE*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *jeudi 07 mai 2026* à *18:15* .\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لديكم موعد مع ** يوم *الخميس 7 ماي 2026* على الساعة *18:15*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-05-04T14:43:54.976995", "media_url": null, "media_mime_type": null}, {"id": 23515, "message_id": "A5B6640AF3F6AA9A40D17DCE8A72A42F", "sender": "bot", "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\"Safia, bghit ngoulek ra l'docteur galik ra ma3ndekch gha soussa whda, ra 3ndek soussat houma. Bash matjich m3owla 3la soussa whda, hitash khasso ihyedlik ga3 dok sousat.\"\n\n**English Translation (for context):**\n\"Safia, I wanted to tell you that the doctor said you don't have just one cavity, you have several cavities. So don't come expecting (to treat) just one cavity, because he has to remove all of those cavities for you.\"", "created_at": "2026-05-04T15:41:34.688984", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/6599/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 23517, "message_id": "3A5F850EE8C928FD027A", "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 (Transcription):**\n\"Salam aleykoum, safi khti makayn mouchkil, makayn mouchkil. Mouhim kifma siftti f'l message, t-tmanya w... setta w qsem. Setta w qsem nhar l'khemis. Yallah khti tbarek Allah elik.\"\n\n**Translation (for context):**\n\"Peace be upon you. Okay sister, no problem, no problem. Anyway, as you sent in the message, eight and... six and five (6:05). Six and five (6:05) on Thursday. Alright sister, may God bless you (take care).\"", "created_at": "2026-05-04T15:42:16.276683", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/6600/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 23519, "message_id": "A55FA6FC2469C905909314D4CD4D7312", "sender": "bot", "message_type": "voice", "content": "[Voice message] صافي، واخا، مرحبا، ماشي سوق، ستة وربع، مرحبا، على الراس والعين، مرحبا بك.", "created_at": "2026-05-04T15:42:43.549653", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/6601/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 23520, "message_id": "3AA2FD560C3E89A2FDCE", "sender": "user", "message_type": "text", "content": "D’accr", "created_at": "2026-05-04T15:43:14.656923", "media_url": null, "media_mime_type": null}, {"id": 24881, "message_id": "3EB0B2EC3E7B429D56CF1E", "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 confirmation graphic for Tanger Bay Dental Center. The background shows a blurred dental office chair and typical dental equipment, indicating a clinical setting. In the foreground, there is an illustrated anthropomorphic tooth character with a smiling face, holding a calendar or notepad with a green check mark, giving a thumbs up. At the top, a logo (stylized tooth with Arabic/English text 'Tanger Bay Dental Center') is visible. Prominent blue banners contain confirmation text.\",\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    \"CHEZ TANGER BAY DENTAL CENTER\"\n  ],\n  \"possible_concerns\": [],\n  \"\n\nUser message context: Salut *FENNICH SOUFIANE*👋\r\nNous vous confirmons votre rendez-vous avec *Dr. Haitham Boutaib*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *jeudi 07 mai 2026*\r\n🕘 Heure : *18:15*\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-05-06T15:09:27.493158", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/7086/download", "media_mime_type": "image/jpeg"}, {"id": 24883, "message_id": "3AF9A71CDE9418198E57", "sender": "user", "message_type": "text", "content": "Oui", "created_at": "2026-05-06T15:09:45.411376", "media_url": null, "media_mime_type": null}, {"id": 38040, "message_id": "3A37B8A1D0674A521D98", "sender": "user", "message_type": "text", "content": "Salam bghit rendez-vous nhar sbt 3la wd les bagues", "created_at": "2026-06-02T14:05:21.661409", "media_url": null, "media_mime_type": null}, {"id": 38041, "message_id": "A542F5BB4B37F7D6028BBD4417F3C33D", "sender": "bot", "message_type": "text", "content": "Bonjour et bienvenue au Cabinet dentaire Tanger Bay \nمرحبا بكم فـ عيادة طنجة باي لطب الأسنان.\n\n Merci de nous indiquer en quoi nous pouvons vous aider afin que notre équipe puisse vous orienter au mieux.\nمن فضلكم، أخبرونا كيف يمكننا مساعدتكم لكي يتمكن فريقنا من توجيهكم بشكل مناسب\n\n📍 Localisation : https://maps.app.goo.gl/ZCXz3sMZkhk9diph7\n🌐 Site web : www.tangerbay.ma\n📧 Email :\ntangerbay01@gmail.com\n\n✅ Notre équipe vous répondra dans les plus brefs délais.\nسيقوم فريقنا بالرد عليكم في أقرب وقت ممكن", "created_at": "2026-06-02T14:05:22.310561", "media_url": null, "media_mime_type": null}, {"id": 38043, "message_id": "bot_3A37B8A1D0674A521D98_4201", "sender": "bot", "message_type": "text", "content": "شكراً بزاف على الترحيب والمعلومات! إذا محتاجين أي مساعدة أو عندكم سؤال على الخدمات أو المواعيد، أنا هنا نعاونكوم 😊\n\nواش كاين شي حاجة معينة بغيتو تستفسرو عليها اليوم؟", "created_at": "2026-06-02T14:05:56.055570", "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 3043 in training_review_items