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": 38071, "message_id": "AC8D504D1903DBD76A1FEBF1226DFDD3", "sender": "user", "message_type": "text", "content": "Oui", "created_at": "2026-06-02T15:13:40.890968", "media_url": null, "media_mime_type": null}, {"id": 38072, "message_id": "AC491C68D93CDF6E027B70036C88FCC1", "sender": "user", "message_type": "text", "content": "OUI", "created_at": "2026-06-02T15:13:56.165069", "media_url": null, "media_mime_type": null}, {"id": 38078, "message_id": "A56944A57C411F89CE2855A3EBCF9890", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in both Arabic and Latin scripts:\n\n**Arabic Script:**\nالسلام عليكم مدام، بخير مزيانة؟ الصحة لاباس؟ غدا إن شاء الله مع العشرة، صافي؟\n\n**Latin Script:**\nSalamu alaykom Madame, bikhir mzyana? Saha labas? Ghedda in sha Allah m’a l'achra, safi?", "created_at": "2026-06-02T15:25:32.465956", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10621/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 38143, "message_id": "AC053C5F1B22A3FE42DC395A796B58C1", "sender": "user", "message_type": "text", "content": "Ok", "created_at": "2026-06-02T16:18:19.386457", "media_url": null, "media_mime_type": null}, {"id": 38301, "message_id": "3EB0260495E393021E5F21", "sender": "bot", "message_type": "text", "content": "Centre Dentaire *( Dr. Boutaib Haitham )* \r\na le plaisir de vous informer que votre paiement de *900,00* dirhams (*Espèce*) a bien été reçu.\r\n \r\nVotre situation à la date d'aujourd'hui est de *-0,00* dirhams.\r\nNous restons toujours à votre service.\r\n\r\nMerci", "created_at": "2026-06-03T09:56:17.773492", "media_url": null, "media_mime_type": null}, {"id": 38302, "message_id": "3EB059BC5298A64C4C9E3C", "sender": "bot", "message_type": "document", "content": "2026060310554321.pdf", "created_at": "2026-06-03T09:56:33.907801", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10677/download", "media_mime_type": "application/pdf"}, {"id": 38463, "message_id": "3EB015858D18FFE3E03569", "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 digital promotional graphic showing a smiling cartoon tooth character holding a small notepad with a large green checkmark. The tooth is positioned in the foreground and is giving a thumbs up gesture with its left 'hand.' In the background, there is a blurred setting resembling a dental office, with a dental chair and typical clinic furnishings faintly visible. The upper part of the image has the logo and name 'Tanger Bay Dental Center' featuring a stylized tooth and wave icon. The main text is displayed in white and blue highlighted bars and reads, 'VOTRE RENDEZ-VOUS EST CONFIRMÉ' with a green checkmark icon next to it, followed by 'CHEZ TANGER BAY DENTAL CENTER.' The overall color scheme is light blue and white, creating a clean and professional dental clinic atmosphere.\",\n  \"dental_observations\": {\n    \"applicable\": false,\n    \"teeth_present\": \"unclear\",\n    \"teeth_condition\": [],\n    \"gum_condition\": \"unclear\",\n    \"bone_level\": null,\n    \"root_canals\": null,\n    \"restorations_visible\": [],\n    \"missing_teeth\": \"unclear\",\n    \"alignment\": \"unclear\",\n    \"calculus_plaque\": \"unc\n\nUser message context: Salut *SAFAE Elghazali*👋\r\nNous vous confirmons votre rendez-vous avec *DR OUSSAMA MOUALLEM*  chez Tanger Bay Dental Center 🦷\r\n\r\n📅 Date : *jeudi 04 juin 2026*\r\n🕘 Heure : *18: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-03T15:06:15.111454", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/10715/download", "media_mime_type": "image/jpeg"}, {"id": 38465, "message_id": "AC62126FDB3572E6F2CB00FB82461079", "sender": "user", "message_type": "text", "content": "Ok", "created_at": "2026-06-03T15:09:30.288470", "media_url": null, "media_mime_type": null}, {"id": 38466, "message_id": "ACAC06A74160523FA2CD8FCF3A6C4FF8", "sender": "user", "message_type": "text", "content": "Oui", "created_at": "2026-06-03T15:09:32.840573", "media_url": null, "media_mime_type": null}, {"id": 40282, "message_id": "3EB01EF52C2C061AD21476", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*SAFAE Elghazali*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *lundi 08 juin 2026* à *16:45* .\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لديكم موعد مع ** يوم *الأثنين 8 يونيو 2026* على الساعة *16:45*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-08T09:39:56.336835", "media_url": null, "media_mime_type": null}, {"id": 40283, "message_id": "AC81EDD5E44B743DA14070A2A6E6253D", "sender": "user", "message_type": "text", "content": "Ok", "created_at": "2026-06-08T09:40:20.536842", "media_url": null, "media_mime_type": null}, {"id": 40284, "message_id": "bot_AC81EDD5E44B743DA14070A2A6E6253D_3273", "sender": "bot", "message_type": "text", "content": "Merci Safae, votre présence est bien notée pour vos rendez-vous. Si besoin de modifier ou d’annuler, n’hésitez pas à nous informer. À bientôt chez Tanger Bay Dental Center 😊", "created_at": "2026-06-08T09:40:53.732811", "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 3267 in training_review_items