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": 40947, "message_id": "3A1DD5E12094C914873A", "sender": "user", "message_type": "text", "content": "I’ll be in Tangier for 2 days", "created_at": "2026-06-09T15:51:58.995750", "media_url": null, "media_mime_type": null}, {"id": 40948, "message_id": "3A6B588133AD613636E3", "sender": "user", "message_type": "text", "content": "25 and 26", "created_at": "2026-06-09T15:52:10.013746", "media_url": null, "media_mime_type": null}, {"id": 40949, "message_id": "bot_3A6B588133AD613636E3_2926", "sender": "bot", "message_type": "text", "content": "Thank you for the details!", "created_at": "2026-06-09T15:52:18.701747", "media_url": null, "media_mime_type": null}, {"id": 40950, "message_id": "bot_3A6B588133AD613636E3_8156", "sender": "bot", "message_type": "text", "content": "To help you book a consultation on the 25th or 26th, could you please share your full name?", "created_at": "2026-06-09T15:52:18.766604", "media_url": null, "media_mime_type": null}, {"id": 40951, "message_id": "bot_3A6B588133AD613636E3_505", "sender": "bot", "message_type": "text", "content": "This will allow our team to contact you and confirm your appointment.", "created_at": "2026-06-09T15:52:18.834252", "media_url": null, "media_mime_type": null}, {"id": 40952, "message_id": "bot_3A6B588133AD613636E3_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-09T15:52:18.900400", "media_url": null, "media_mime_type": null}, {"id": 40953, "message_id": "3A8ED4C8D4C63BDF4BCC", "sender": "user", "message_type": "text", "content": "Shafaqat ali", "created_at": "2026-06-09T15:53:08.454392", "media_url": null, "media_mime_type": null}, {"id": 40954, "message_id": "bot_3A8ED4C8D4C63BDF4BCC_7161", "sender": "bot", "message_type": "text", "content": "Thank you, Shafaqat Ali!", "created_at": "2026-06-09T15:53:19.966712", "media_url": null, "media_mime_type": null}, {"id": 40955, "message_id": "bot_3A8ED4C8D4C63BDF4BCC_1905", "sender": "bot", "message_type": "text", "content": "Could you please confirm if the reason for your visit is a consultation for composite bonding on a chipped tooth?", "created_at": "2026-06-09T15:53:20.019524", "media_url": null, "media_mime_type": null}, {"id": 40956, "message_id": "bot_3A8ED4C8D4C63BDF4BCC_9774", "sender": "bot", "message_type": "text", "content": "Also, do you prefer the 25th or the 26th, and if you have a preferred time of day (morning or afternoon)?", "created_at": "2026-06-09T15:53:20.083641", "media_url": null, "media_mime_type": null}, {"id": 40957, "message_id": "bot_3A8ED4C8D4C63BDF4BCC_4833", "sender": "bot", "message_type": "text", "content": "Once I have these details, our team will contact you to confirm your appointment.", "created_at": "2026-06-09T15:53:20.145202", "media_url": null, "media_mime_type": null}, {"id": 40958, "message_id": "bot_3A8ED4C8D4C63BDF4BCC_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-09T15:53:20.199468", "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 3331 in training_review_items