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": 11129, "message_id": "3ACA0956AA840B9709E8", "sender": "user", "message_type": "text", "content": "Salam!", "created_at": "2026-04-02T21:52:02.676668", "media_url": null, "media_mime_type": null}, {"id": 11130, "message_id": "A5EAF2E0AE3F447E7916ECD2A463F2E4", "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-04-02T21:52:04.337585", "media_url": null, "media_mime_type": null}, {"id": 11131, "message_id": "bot_3ACA0956AA840B9709E8_2509", "sender": "bot", "message_type": "text", "content": "Merci beaucoup et bienvenue encore une fois 😊 Si vous avez besoin d’aide ou d’information, n’hésitez pas à préciser votre demande. Nous sommes à votre écoute !", "created_at": "2026-04-02T21:52:16.167473", "media_url": null, "media_mime_type": null}, {"id": 11132, "message_id": "3AF0837AC8B4F54A8F01", "sender": "user", "message_type": "text", "content": "Hello doctor!\nI hope you are doing well. I'm planning to visit my home country (around May or June )and I would like to schedule a dental appointment with you. I currently have multiple cavities affecting all my sides of my mouth upper left upper right lower left and lower right based on my previous consultation. I might need several root canal treatment. I also believe that one two sides. I might need dental bridge around 3 teeth each. and on the other side at least two teeth may require root canal treatment and restoration.\nSince I’ll be staying there forb25 days! I would like to know if it possible to complete all the necessary treatment within this time frame. It is very important for me to finish everything during this visit , as I will not be able to return again soon! \nCould you please let me know you availability and whether this treatment plan can be provide more details or previous records. \nThank you very much and looking forward to your response.", "created_at": "2026-04-02T22:09:31.952669", "media_url": null, "media_mime_type": null}, {"id": 11133, "message_id": "bot_3AF0837AC8B4F54A8F01_5703", "sender": "bot", "message_type": "text", "content": "Thank you for your detailed message and for reaching out. I understand how important it is for you to complete all your dental treatments during your stay.\n\nTo best assist you, could you please share your full name and your preferred dates for the appointment (around May or June)? This will help our team review your case and check the availability for a comprehensive treatment plan.\n\nPlease note: your appointment and treatment plan will only be confirmed after our team contacts you directly 🙏🏻\n\nIf you have any previous dental records or X-rays, feel free to send them here—they can help the doctor prepare for your visit.", "created_at": "2026-04-02T22:09:46.289173", "media_url": null, "media_mime_type": null}, {"id": 11134, "message_id": "3A865D71F90F3E156C42", "sender": "user", "message_type": "text", "content": "Imane Bensaid \nI’ll confirm the dates once I’ll get the response from you about the possibility", "created_at": "2026-04-02T22:14:43.300928", "media_url": null, "media_mime_type": null}, {"id": 11138, "message_id": "bot_3A865D71F90F3E156C42_5901", "sender": "bot", "message_type": "text", "content": "Thank you Imane for the details. I’ve sent your request to our team so they can review your case and check if the full treatment can be completed within your 25-day stay. They will contact you directly to discuss your options and confirm availability.\n\nPlease note: your appointment and treatment plan will only be confirmed after our team contacts you directly 🙏🏻\n\nIf you have any dental records or X-rays, you can send them here to help the doctor prepare.", "created_at": "2026-04-02T22:14:59.890248", "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 690 in training_review_items