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": 38279, "message_id": "3BAA1E39A48DF6E50563", "sender": "user", "message_type": "text", "content": "I have returned to Tangier", "created_at": "2026-06-03T09:47:44.030312", "media_url": null, "media_mime_type": null}, {"id": 38280, "message_id": "bot_3BAA1E39A48DF6E50563_7778", "sender": "bot", "message_type": "text", "content": "Welcome back! 😊 How can I assist you today? Do you need to book an appointment or do you have a specific request?", "created_at": "2026-06-03T09:47:55.541871", "media_url": null, "media_mime_type": null}, {"id": 38281, "message_id": "3B3FA133F082BE8C7A64", "sender": "user", "message_type": "text", "content": "Could we book an appointment for tomorrow morning?", "created_at": "2026-06-03T09:47:59.672407", "media_url": null, "media_mime_type": null}, {"id": 38282, "message_id": "bot_3B3FA133F082BE8C7A64_5216", "sender": "bot", "message_type": "text", "content": "Of course! Could you please provide your full name and let me know the reason for your visit? This will help us prepare your appointment for tomorrow morning.", "created_at": "2026-06-03T09:48:12.139729", "media_url": null, "media_mime_type": null}, {"id": 38283, "message_id": "3B8B6B6122BA4E983D53", "sender": "user", "message_type": "text", "content": "Robert Laszlo", "created_at": "2026-06-03T09:49:01.636384", "media_url": null, "media_mime_type": null}, {"id": 38284, "message_id": "bot_3B8B6B6122BA4E983D53_895", "sender": "bot", "message_type": "text", "content": "Thank you, Robert. Could you please tell me the reason for your visit tomorrow morning? This will help us organize your appointment properly.", "created_at": "2026-06-03T09:49:13.600810", "media_url": null, "media_mime_type": null}, {"id": 38285, "message_id": "3BBD187808D94A86BCAB", "sender": "user", "message_type": "text", "content": "Reason for my visit to get work done on my teeth based on my prior treatment plan", "created_at": "2026-06-03T09:49:15.808291", "media_url": null, "media_mime_type": null}, {"id": 38289, "message_id": "bot_3BBD187808D94A86BCAB_5726", "sender": "bot", "message_type": "text", "content": "Thank you, Robert!", "created_at": "2026-06-03T09:49:28.714179", "media_url": null, "media_mime_type": null}, {"id": 38290, "message_id": "bot_3BBD187808D94A86BCAB_5579", "sender": "bot", "message_type": "text", "content": "Your request for a follow-up appointment tomorrow morning based on your prior treatment plan has been sent to the team.", "created_at": "2026-06-03T09:49:28.781949", "media_url": null, "media_mime_type": null}, {"id": 38291, "message_id": "bot_3BBD187808D94A86BCAB_3586", "sender": "bot", "message_type": "text", "content": "They will contact you soon to confirm the exact time.", "created_at": "2026-06-03T09:49:28.850174", "media_url": null, "media_mime_type": null}, {"id": 38292, "message_id": "bot_3BBD187808D94A86BCAB_2967", "sender": "bot", "message_type": "text", "content": "Please note: your appointment will only be confirmed after our team contacts you directly 🙏🏻", "created_at": "2026-06-03T09:49:28.917040", "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 3074 in training_review_items