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": 15879, "message_id": "bot_AC6389977E8DB1C3FA9AEBC4BB65173D_4487", "sender": "bot", "message_type": "text", "content": "مرحبا 😊 باش نسجلو الطلب ديالكوم، ممكن تكتبو ليا الإسم الكامل ديالكوم؟\n\nNote : Votre rendez-vous sera validé uniquement après confirmation directe de notre part 🙏🏻", "created_at": "2026-04-15T06:18:46.003418", "media_url": null, "media_mime_type": null}, {"id": 15880, "message_id": "AC0EC47A0A83A9410ED5B590DC782383", "sender": "user", "message_type": "text", "content": "جمال الدين السعداوي", "created_at": "2026-04-15T06:19:39.347467", "media_url": null, "media_mime_type": null}, {"id": 15881, "message_id": "A57EF11DCB8177787160A12262FD8170", "sender": "bot", "message_type": "voice", "content": "[Voice message] هذا هو التفريغ الكامل للمقطع الصوتي بالدارجة المغربية:\n\n\"السلام عليكم سي صابر، كيف داير؟ لاباس عليك؟ مزيان؟ بخير؟ سي صابر هاني في الكابيني، نشوف لأجندا ونقولك فوقاش تجي، صافي؟\"", "created_at": "2026-04-15T07:41:10.640192", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4148/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 15883, "message_id": "AC52491235801307CD2A14D917A006B8", "sender": "user", "message_type": "text", "content": "Chokran", "created_at": "2026-04-15T08:02:46.844450", "media_url": null, "media_mime_type": null}, {"id": 15896, "message_id": "A517C1FC167681205614A0D5F37E3314", "sender": "bot", "message_type": "text", "content": "Salam alikom thi m3a 10 wla 10h30", "created_at": "2026-04-15T08:20:53.440736", "media_url": null, "media_mime_type": null}, {"id": 15897, "message_id": "A5032C845D9177463A22CE7F1D557A76", "sender": "bot", "message_type": "text", "content": "?", "created_at": "2026-04-15T08:20:55.953550", "media_url": null, "media_mime_type": null}, {"id": 15899, "message_id": "3EB07982134CF68A009882", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*SAADAOUI Jamal eddine*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *jeudi 16 avril 2026* à *12: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لديكم موعد مع ** يوم *الخميس 16 أبريل 2026* على الساعة *12:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-15T08:23:28.843942", "media_url": null, "media_mime_type": null}, {"id": 16208, "message_id": "3EB06FBB40F9151DCC7D82", "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 dental-themed graphic for a dental center. Central in the foreground is a large, anthropomorphic cartoon tooth with a smiling face, dark eyes, and raised eyebrows. The tooth is holding a calendar or checklist that displays a large green checkmark, symbolizing confirmation. Its other hand gives a thumbs-up gesture. In the background, there is an out-of-focus dental clinic setting: a dental chair and equipment can be seen. The top portion of the image displays a logo consisting of a stylized tooth shape with the text 'TANGER BAY DENTAL CENTER' underneath it. Two prominent blue horizontal bars feature in the upper-middle section: the first says 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' with a green checkmark, and the second line reads 'CHEZ TANGER BAY DENTAL CENTER'. The overall color palette is light and clean, with blue and ivory tones.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"unclear\",\n    \"teeth_condition\": [],\n    \"gum_condition\": \"\",\n    \"bone_level\": null,\n    \"root_canals\": null,\n    \"restorations_visible\": [],\n    \"missing_teeth\": \"\",\n    \"alignment\": \"\",\n\nUser message context: Salut *SAADAOUI Jamal eddine*👋\r\nNous vous confirmons votre rendez-vous avec *DR OUSSAMA MOUALLEM*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *jeudi 16 avril 2026*\r\n🕘 Heure : *12: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-04-15T15:03:45.518551", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/4262/download", "media_mime_type": "image/jpeg"}, {"id": 16242, "message_id": "3EB0392AFE9C993519E6D7", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*SAADAOUI Jamal eddine*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *jeudi 16 avril 2026* à *12: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لديكم موعد مع ** يوم *الخميس 16 أبريل 2026* على الساعة *12:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-15T15:25:44.848404", "media_url": null, "media_mime_type": null}, {"id": 16425, "message_id": "3EB0DE206DD7845B0957A7", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*SAADAOUI Jamal eddine*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *jeudi 16 avril 2026* à *12: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لديكم موعد مع ** يوم *الخميس 16 أبريل 2026* على الساعة *12:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-04-15T17:43:26.895946", "media_url": null, "media_mime_type": null}, {"id": 16750, "message_id": "ACFD7A29A90FF49E8432182C95D0A549", "sender": "user", "message_type": "text", "content": "Salam", "created_at": "2026-04-16T12:42:40.749266", "media_url": null, "media_mime_type": null}, {"id": 16751, "message_id": "bot_ACFD7A29A90FF49E8432182C95D0A549_4758", "sender": "bot", "message_type": "text", "content": "وعليكم السلام ورحمة الله، مرحبا بيكوم أستاذ SAADAOUI Jamal eddine 😊 الموعد ديالكوم مع الدكتور OUSSAMA MOUALLEM تأكد ليوم الخميس 16 أبريل على الساعة 12:00. إذا محتاجين شي حاجة أخرى أنا رهن الإشارة ديالكوم.", "created_at": "2026-04-16T12:43:05.747889", "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 1262 in training_review_items