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": 10564, "message_id": "3A0D6AA518322DEABED6", "sender": "user", "message_type": "text", "content": "Mr tarik", "created_at": "2026-04-02T10:37:11.177052", "media_url": null, "media_mime_type": null}, {"id": 10565, "message_id": "bot_3A0D6AA518322DEABED6_1262", "sender": "bot", "message_type": "text", "content": "مرحبا سي Tarik 😊 باش نكملو معاك، ممكن تقول ليا شنو العلاج أو الخدمة اللي محتاج، وفين الوقت اللي مناسبك إن شاء الله؟", "created_at": "2026-04-02T10:37:23.910898", "media_url": null, "media_mime_type": null}, {"id": 10566, "message_id": "3A683034E705BC40BBD7", "sender": "user", "message_type": "text", "content": "I want to make an appointment", "created_at": "2026-04-02T10:37:35.689661", "media_url": null, "media_mime_type": null}, {"id": 10567, "message_id": "bot_3A683034E705BC40BBD7_4102", "sender": "bot", "message_type": "text", "content": "Thank you Mr Tarik! Could you please tell me the type of dental care or treatment you need, and your preferred day or time for the appointment? This will help our team assist you as quickly as possible.", "created_at": "2026-04-02T10:37:47.759243", "media_url": null, "media_mime_type": null}, {"id": 10568, "message_id": "3A8E695E549688781AE7", "sender": "user", "message_type": "text", "content": "For now to begin detatrage", "created_at": "2026-04-02T10:38:17.552575", "media_url": null, "media_mime_type": null}, {"id": 10569, "message_id": "bot_3A8E695E549688781AE7_9007", "sender": "bot", "message_type": "text", "content": "Thank you! What day and time would suit you best for your détartrage appointment? Our clinic is open Monday to Friday from 09:00 to 19:00, and Saturday from 09:00 to 14:00.", "created_at": "2026-04-02T10:38:33.078910", "media_url": null, "media_mime_type": null}, {"id": 10570, "message_id": "3A13E56FEBE6716B5902", "sender": "user", "message_type": "text", "content": "Today I think if possible", "created_at": "2026-04-02T10:38:56.345640", "media_url": null, "media_mime_type": null}, {"id": 10574, "message_id": "bot_3A13E56FEBE6716B5902_4480", "sender": "bot", "message_type": "text", "content": "Thank you Mr Tarik, your request for a détartrage appointment today has been sent to our team. They will contact you soon to confirm the exact time.\n\nPlease note: your appointment will only be confirmed after our team contacts you directly 🙏🏻", "created_at": "2026-04-02T10:39:09.323348", "media_url": null, "media_mime_type": null}, {"id": 10575, "message_id": "3AE3BE6CDFBE8E065187", "sender": "user", "message_type": "text", "content": "How long does it take the detetrage", "created_at": "2026-04-02T10:39:36.767972", "media_url": null, "media_mime_type": null}, {"id": 10576, "message_id": "bot_3AE3BE6CDFBE8E065187_350", "sender": "bot", "message_type": "text", "content": "A détartrage appointment usually takes between 30 and 45 minutes, but it can vary depending on your case 😊", "created_at": "2026-04-02T10:39:49.198098", "media_url": null, "media_mime_type": null}, {"id": 10577, "message_id": "3AB8CBBBAB02CDB6C27D", "sender": "user", "message_type": "text", "content": "Ok thank you\nI will be waiting for your call", "created_at": "2026-04-02T10:40:28.436710", "media_url": null, "media_mime_type": null}, {"id": 10578, "message_id": "bot_3AB8CBBBAB02CDB6C27D_363", "sender": "bot", "message_type": "text", "content": "Thank you, Mr Tarik! Our team will contact you soon. Have a great day 😊", "created_at": "2026-04-02T10:40:39.559767", "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 607 in training_review_items