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": 13989, "message_id": "A5194BBE0AA6B43656A7AE05E900FC03", "sender": "bot", "message_type": "text", "content": "Ok", "created_at": "2026-04-11T12:10:50.430060", "media_url": null, "media_mime_type": null}, {"id": 13990, "message_id": "A5DC1C4CDCA12C9F3C4DED9B74EC41AE", "sender": "bot", "message_type": "text", "content": "I will see with the doctor", "created_at": "2026-04-11T12:10:57.776281", "media_url": null, "media_mime_type": null}, {"id": 13991, "message_id": "3A8A42A265D7198DBAC0", "sender": "user", "message_type": "text", "content": "Ok", "created_at": "2026-04-11T12:11:06.995024", "media_url": null, "media_mime_type": null}, {"id": 14521, "message_id": "A54C3010DB652DC70A31C917BA907784", "sender": "bot", "message_type": "text", "content": "Hello Thomas how are you", "created_at": "2026-04-12T21:32:33.997722", "media_url": null, "media_mime_type": null}, {"id": 14522, "message_id": "A51FFBDE282C8D17B81B114B99019010", "sender": "bot", "message_type": "text", "content": "Can you come this Saturday", "created_at": "2026-04-12T21:32:47.732178", "media_url": null, "media_mime_type": null}, {"id": 14523, "message_id": "A5C31D7E872DA547E103168E19A449DA", "sender": "bot", "message_type": "text", "content": "Morning", "created_at": "2026-04-12T21:32:54.218774", "media_url": null, "media_mime_type": null}, {"id": 14524, "message_id": "3AB57C4E4FE348EA0C29", "sender": "user", "message_type": "text", "content": "Hi, im doing good im not sure but i can tell you later in the week if o am free Saturday", "created_at": "2026-04-12T21:34:01.383891", "media_url": null, "media_mime_type": null}, {"id": 14525, "message_id": "3A72BFCA9EAFA6E7648F", "sender": "user", "message_type": "text", "content": "I know for sure I will be free Tuesday", "created_at": "2026-04-12T21:34:17.776341", "media_url": null, "media_mime_type": null}, {"id": 14527, "message_id": "3A8002A095ECBA8E1A0D", "sender": "user", "message_type": "text", "content": "But maybe Saturday I am free I will text you", "created_at": "2026-04-12T21:34:31.640232", "media_url": null, "media_mime_type": null}, {"id": 14528, "message_id": "A51462106128826E7755B50243EF3930", "sender": "bot", "message_type": "text", "content": "Ok", "created_at": "2026-04-12T21:35:06.447528", "media_url": null, "media_mime_type": null}, {"id": 21520, "message_id": "3A1B5F00068405E393A9", "sender": "user", "message_type": "text", "content": "Hi, I may be free if there is availability on Saturday", "created_at": "2026-04-30T19:39:45.379108", "media_url": null, "media_mime_type": null}, {"id": 21521, "message_id": "bot_3A1B5F00068405E393A9_5473", "sender": "bot", "message_type": "text", "content": "Thank you for your message! 😊 Would you prefer a morning or afternoon slot on Saturday? If you let me know your full name as well, I can pass your request to the team to check availability and get back to you.\n\nPlease note: your appointment will only be confirmed after our team contacts you directly 🙏🏻", "created_at": "2026-04-30T19:39:59.053718", "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 1623 in training_review_items