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": 32235, "message_id": "meta_echo_495384013668010_wamid.HBgMMjEyNzI2ODM2NjE4FQIAERgWM0VCMEFBQTBBNTIyOTA1MTIyOTUzMwA=", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*BRAHIMI Yassine*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *jeudi 21 mai 2026* à *11: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لديكم موعد مع ** يوم *الخميس 21 ماي 2026* على الساعة *11:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-05-19T11:45:23.142619", "media_url": null, "media_mime_type": null}, {"id": 32255, "message_id": "meta_495384013668010_wamid.HBgMMjEyNzI2ODM2NjE4FQIAEhgUM0E4NEJGRTI1MDhDNzY0NDcwMjYA", "sender": "user", "message_type": "text", "content": "Merci", "created_at": "2026-05-19T11:56:37.433728", "media_url": null, "media_mime_type": null}, {"id": 32256, "message_id": "bot_meta_495384013668010_wamid.HBgMMjEyNzI2ODM2NjE4FQIAEhgUM0E4NEJGRTI1MDhDNzY0NDcwMjYA_9659", "sender": "bot", "message_type": "text", "content": "Avec plaisir, merci à vous 🙏🏻", "created_at": "2026-05-19T11:58:01.608893", "media_url": null, "media_mime_type": null}, {"id": 33038, "message_id": "meta_echo_495384013668010_wamid.HBgMMjEyNzI2ODM2NjE4FQIAERgWM0VCMEU1M0JBQkQ2NDI0NDE2OUY0QwA=", "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 informational graphic for Tanger Bay Dental Center. It shows a cartoon-style anthropomorphic tooth with a smiling face, holding a notepad with a large green checkmark, indicating confirmation. The tooth figure has large eyes, eyebrows, is giving a thumbs-up, and appears friendly and approachable. In the background, there is a blurred clinical room with dental equipment and a dental chair, suggesting a dental office environment. At the top, there is a logo of a stylized tooth with the text 'TANGER BAY DENTAL CENTER' below. Prominent blue banners across the center of the image display the text: 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' with a checkmark symbol, and 'CHEZ TANGER BAY DENTAL CENTER' underneath.\",\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\n\nUser message context: Salut *BRAHIMI Yassine*👋\r\nNous vous confirmons votre rendez-vous avec *DR OUSSAMA MOUALLEM*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *jeudi 21 mai 2026*\r\n🕘 Heure : *11: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-05-20T15:03:15.587866", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/9490/download", "media_mime_type": "image/jpeg"}, {"id": 33039, "message_id": "meta_495384013668010_wamid.HBgMMjEyNzI2ODM2NjE4FQIAEhgUM0E2NEUxNTgzMDA4MDY5Njc1NjQA", "sender": "user", "message_type": "text", "content": "Oui", "created_at": "2026-05-20T15:03:34.859324", "media_url": null, "media_mime_type": null}, {"id": 33126, "message_id": "meta_echo_495384013668010_wamid.HBgMMjEyNzI2ODM2NjE4FQIAERgWM0VCMENGNEM0NDgyRjJCNUE2NDkzMAA=", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*BRAHIMI Yassine*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *jeudi 21 mai 2026* à *11: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لديكم موعد مع ** يوم *الخميس 21 ماي 2026* على الساعة *11:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-05-20T16:33:25.435718", "media_url": null, "media_mime_type": null}, {"id": 33912, "message_id": "3EB0EA0787399B022D816C", "sender": "bot", "message_type": "text", "content": "Bonjour BRAHIMI Lounes", "created_at": "2026-05-22T11:07:28.236898", "media_url": null, "media_mime_type": null}, {"id": 35147, "message_id": "3EB083C0F7C858490395F4", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*BRAHIMI Lounes*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *lundi 25 mai 2026* à *11: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**\r\nلديكم موعد مع ** يوم *الأثنين 25 ماي 2026* على الساعة *11:30*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-05-25T09:16:10.005789", "media_url": null, "media_mime_type": null}, {"id": 35201, "message_id": "3EB0FCA6C9923012BE2264", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*BRAHIMI Lounes*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *lundi 25 mai 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لديكم موعد مع ** يوم *الأثنين 25 ماي 2026* على الساعة *12:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-05-25T10:46:00.623744", "media_url": null, "media_mime_type": null}, {"id": 36599, "message_id": "3AC45021ED80757BC67E", "sender": "user", "message_type": "text", "content": "Salam je peut avoir la date du prochain rendez-vous s’il vous plait", "created_at": "2026-05-29T20:09:42.537006", "media_url": null, "media_mime_type": null}, {"id": 36600, "message_id": "bot_3AC45021ED80757BC67E_7109", "sender": "bot", "message_type": "text", "content": "Bonjour 😊 Votre prochain rendez-vous avec Dr Oussama Mouallem est prévu le lundi 25 mai 2026 à 12:00.", "created_at": "2026-05-29T20:10:00.154276", "media_url": null, "media_mime_type": null}, {"id": 36601, "message_id": "bot_3AC45021ED80757BC67E_4604", "sender": "bot", "message_type": "text", "content": "Si vous avez besoin de modifier ou d’annuler, n’hésitez pas à contacter la réception au 060022263 ou 0539948014.", "created_at": "2026-05-29T20:10:00.208500", "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 2909 in training_review_items