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": 36237, "message_id": "bot_3A432B0A0833D327E485_5952", "sender": "bot", "message_type": "text", "content": "Thank you Mohamed Amine Karraz for your details.", "created_at": "2026-05-28T21:19:44.085086", "media_url": null, "media_mime_type": null}, {"id": 36238, "message_id": "bot_3A432B0A0833D327E485_9864", "sender": "bot", "message_type": "text", "content": "Just to let you know, the clinic is closed on Sunday.", "created_at": "2026-05-28T21:19:44.139975", "media_url": null, "media_mime_type": null}, {"id": 36239, "message_id": "bot_3A432B0A0833D327E485_5192", "sender": "bot", "message_type": "text", "content": "Would you like to book your appointment for Saturday morning instead, or do you prefer another day?", "created_at": "2026-05-28T21:19:44.214909", "media_url": null, "media_mime_type": null}, {"id": 36240, "message_id": "bot_3A432B0A0833D327E485_2182", "sender": "bot", "message_type": "text", "content": "And could you please tell me the reason for your visit?", "created_at": "2026-05-28T21:19:44.268728", "media_url": null, "media_mime_type": null}, {"id": 36241, "message_id": "bot_3AE0B52AEED98116B1D4_6126", "sender": "bot", "message_type": "text", "content": "No problem Mohamed Amine Karraz 😊 Could you please tell me the reason for your visit, and if you have a preferred time on Saturday morning?", "created_at": "2026-05-28T21:19:58.428602", "media_url": null, "media_mime_type": null}, {"id": 36242, "message_id": "bot_3AE0B52AEED98116B1D4_5489", "sender": "bot", "message_type": "text", "content": "Once I have these details, I’ll notify the team to contact you for confirmation.", "created_at": "2026-05-28T21:19:58.490842", "media_url": null, "media_mime_type": null}, {"id": 36243, "message_id": "bot_3AE0B52AEED98116B1D4_4796", "sender": "bot", "message_type": "text", "content": "Please note: your appointment will only be confirmed after our team contacts you directly 🙏🏻", "created_at": "2026-05-28T21:19:58.547146", "media_url": null, "media_mime_type": null}, {"id": 36244, "message_id": "3A7C1D5375724A7966EF", "sender": "user", "message_type": "text", "content": "Saturday morning is good", "created_at": "2026-05-28T21:20:07.290814", "media_url": null, "media_mime_type": null}, {"id": 36245, "message_id": "bot_3A7C1D5375724A7966EF_5544", "sender": "bot", "message_type": "text", "content": "Thank you Mohamed Amine Karraz!", "created_at": "2026-05-28T21:20:17.970684", "media_url": null, "media_mime_type": null}, {"id": 36246, "message_id": "bot_3A7C1D5375724A7966EF_2170", "sender": "bot", "message_type": "text", "content": "Could you please let me know the reason for your visit (for example: détartrage, consultation, douleur, etc.)?", "created_at": "2026-05-28T21:20:18.027940", "media_url": null, "media_mime_type": null}, {"id": 36247, "message_id": "bot_3A7C1D5375724A7966EF_594", "sender": "bot", "message_type": "text", "content": "This will help the team prepare for your appointment.", "created_at": "2026-05-28T21:20:18.078529", "media_url": null, "media_mime_type": null}, {"id": 36248, "message_id": "bot_3A7C1D5375724A7966EF_7340", "sender": "bot", "message_type": "text", "content": "Once I have this last detail, I’ll send your request to the team.", "created_at": "2026-05-28T21:20:18.131718", "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 2870 in training_review_items