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": 40294, "message_id": "ACF07161A2DE41B94C6124BF99FC1480", "sender": "user", "message_type": "text", "content": "Mohamed elhmidi", "created_at": "2026-06-08T10:31:14.177175", "media_url": null, "media_mime_type": null}, {"id": 40298, "message_id": "bot_ACF07161A2DE41B94C6124BF99FC1480_7898", "sender": "bot", "message_type": "text", "content": "شكرا Mohamed 😊 غادي نبلغ الفريق الطبي ديالنا وغادي يتواصلوا معكوم في أقرب وقت إن شاء الله بخصوص موعد الاستشارة.\n\nدير فبالك أن الموعد غادي يتأكد غير بعد ما يتواصل معاك الفريق مباشرة 🙏🏻", "created_at": "2026-06-08T10:31:27.632098", "media_url": null, "media_mime_type": null}, {"id": 40299, "message_id": "AC4D6AB754460747FF65849608AEA8FF", "sender": "user", "message_type": "text", "content": "غد او بعد غد", "created_at": "2026-06-08T10:31:31.960931", "media_url": null, "media_mime_type": null}, {"id": 40309, "message_id": "A5C2FD69DCDF7808B79B31988939D2EF", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija and French (as spoken):\n\n**Arabic Script:**\n\"السلام عليكم، كيف تيتي؟ مزيان؟ بخير؟ الصحة لاباس؟ واخا، عندك غدا إن شاء الله رنديفو (RDV) ديال كونسيلطاسيون (consultation) مع الدكتور، وإن شاء الله يا ربي غدا في العشية. صافي؟ واخا.\"\n\n**Latin Script (Darija/French mix):**\n\"Salam o alaikom, kif titi? Mezian? Bikher? Seha labas? Wakha, 3ndek gheda inch’Allah RDV dyal consultation m3a dktour, w inch’Allah ya rebi gheda f l’3chiya. Safi? Wakha.\"\n\n**Translation (for context):**\n\"Peace be upon you, how are you? Good? Well? Is your health okay? Okay, you have a consultation appointment with the doctor tomorrow, God willing. It will be tomorrow afternoon, God willing. Is that okay? All right.\"", "created_at": "2026-06-08T10:48:15.688229", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11187/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 40312, "message_id": "ACB0B60FC396241016EEE7B3CBA62724", "sender": "user", "message_type": "text", "content": "Mohamed elhmidi", "created_at": "2026-06-08T10:50:10.940044", "media_url": null, "media_mime_type": null}, {"id": 40319, "message_id": "3EB0F1346B041869DC8E2E", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*ELHMIDI Mohamed*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *mardi 09 juin 2026* à *16:30* .\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*ELHMIDI*\r\nلديكم موعد مع ** يوم *الثلاثاء 9 يونيو 2026* على الساعة *16:30*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-08T10:53:17.184053", "media_url": null, "media_mime_type": null}, {"id": 40355, "message_id": "AC12D84D2FC45CF103534974231C982F", "sender": "user", "message_type": "text", "content": "Ok", "created_at": "2026-06-08T11:55:05.555313", "media_url": null, "media_mime_type": null}, {"id": 40446, "message_id": "3EB0231AE0B59EE26A6FED", "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 advertisement or announcement. In the foreground is a cartoon, anthropomorphic tooth character with a smiling face, big eyes, and eyebrows. The tooth is holding a notepad featuring a large green check mark and giving a thumbs-up gesture. In the background, there is an out-of-focus dental chair and equipment, hinting at a dental clinic setting. At the top of the image, the logo for 'Tanger Bay Dental Center' is visible, featuring the outline of a tooth and the text 'Tanger Bay Dental Center'. Central text in bold white letters on a blue background reads 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' with a green check mark. Below it is another blue bar with the text 'CHEZ TANGER BAY DENTAL CENTER'. The image uses a predominately blue and white color palette and is clean and promotional in style.\",\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    \"\n\nUser message context: Salut *ELHMIDI Mohamed*👋\r\nNous vous confirmons votre rendez-vous avec *DR OUSSAMA MOUALLEM*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *mardi 09 juin 2026*\r\n🕘 Heure : *16:30*\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:04:49.007214", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/11228/download", "media_mime_type": "image/jpeg"}, {"id": 40455, "message_id": "AC935F7EDF60B03C903A14C3A4602276", "sender": "user", "message_type": "text", "content": "Ok", "created_at": "2026-06-08T15:42:52.168551", "media_url": null, "media_mime_type": null}, {"id": 40456, "message_id": "AC559B86564EA9AFA452120423E933F2", "sender": "user", "message_type": "text", "content": "Oui", "created_at": "2026-06-08T15:42:52.382342", "media_url": null, "media_mime_type": null}, {"id": 40920, "message_id": "ACD49A072C1FF2659B73DB81C84C7E5F", "sender": "user", "message_type": "text", "content": "Salam ana Jay merci", "created_at": "2026-06-09T15:33:58.153771", "media_url": null, "media_mime_type": null}, {"id": 40921, "message_id": "bot_ACD49A072C1FF2659B73DB81C84C7E5F_5809", "sender": "bot", "message_type": "text", "content": "مرحبا بيكوم 😊 نتسناوكوم اليوم إن شاء الله. إذا احتاجيتو شي حاجة أخرى، حنا رهن الإشارة.", "created_at": "2026-06-09T15:34:25.526893", "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 3327 in training_review_items