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": 37156, "message_id": "bot_3AC34B65F3EDEA8E14DA_6758", "sender": "bot", "message_type": "text", "content": "The team will confirm the final price with you directly during your visit.", "created_at": "2026-05-31T15:02:46.553299", "media_url": null, "media_mime_type": null}, {"id": 37157, "message_id": "bot_3AC34B65F3EDEA8E14DA_6593", "sender": "bot", "message_type": "text", "content": "If you have any questions or need to adjust your appointment, you can contact the reception at 060022263 or 0539948014.", "created_at": "2026-05-31T15:02:46.616244", "media_url": null, "media_mime_type": null}, {"id": 37160, "message_id": "3A0D6E7E90DE517AD009", "sender": "user", "message_type": "text", "content": "Okay \nThanks", "created_at": "2026-05-31T15:28:09.133202", "media_url": null, "media_mime_type": null}, {"id": 37161, "message_id": "bot_3A0D6E7E90DE517AD009_7756", "sender": "bot", "message_type": "text", "content": "You’re welcome! 😊 If you need anything else, feel free to ask.", "created_at": "2026-05-31T15:28:20.930326", "media_url": null, "media_mime_type": null}, {"id": 37335, "message_id": "A585DC6022E816CE14F8A41702FF1FE4", "sender": "bot", "message_type": "text", "content": "Cleaning 600dh or 800 dh \nTeeth whitening 4000dh by laser", "created_at": "2026-06-01T09:39:51.430830", "media_url": null, "media_mime_type": null}, {"id": 37345, "message_id": "3A2E073FDAD1D8624296", "sender": "user", "message_type": "text", "content": "Is the teeth cleaning airflow?", "created_at": "2026-06-01T10:05:09.524654", "media_url": null, "media_mime_type": null}, {"id": 37346, "message_id": "A513A97A8A6422DE705DEB6F9A235E75", "sender": "bot", "message_type": "text", "content": "Yes", "created_at": "2026-06-01T10:08:18.738025", "media_url": null, "media_mime_type": null}, {"id": 38364, "message_id": "3AD21177DED8C30FF2B2", "sender": "user", "message_type": "text", "content": "Hi. 😊\n\n\nMy friend ( Amina) changed her mind and doesn’t want the appointment.\n\nI want the teeth cleaning only not the whitening.", "created_at": "2026-06-03T11:13:41.513316", "media_url": null, "media_mime_type": null}, {"id": 38368, "message_id": "bot_3AD21177DED8C30FF2B2_9607", "sender": "bot", "message_type": "text", "content": "Thank you for letting us know!", "created_at": "2026-06-03T11:13:55.679797", "media_url": null, "media_mime_type": null}, {"id": 38369, "message_id": "bot_3AD21177DED8C30FF2B2_7126", "sender": "bot", "message_type": "text", "content": "Your request to cancel Amina’s appointment and keep only the teeth cleaning for yourself has been sent to the team.", "created_at": "2026-06-03T11:13:55.743087", "media_url": null, "media_mime_type": null}, {"id": 38370, "message_id": "bot_3AD21177DED8C30FF2B2_5595", "sender": "bot", "message_type": "text", "content": "They will contact you soon to confirm the update.", "created_at": "2026-06-03T11:13:55.810076", "media_url": null, "media_mime_type": null}, {"id": 38371, "message_id": "bot_3AD21177DED8C30FF2B2_5138", "sender": "bot", "message_type": "text", "content": "Please note: your appointment will only be confirmed after our team contacts you directly 🙏🏻", "created_at": "2026-06-03T11:13:55.867623", "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 3086 in training_review_items