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": 40960, "message_id": "3ADAF28ECB0FE0D7BE1C", "sender": "user", "message_type": "text", "content": "Visit is for composit bonding", "created_at": "2026-06-09T15:53:56.175369", "media_url": null, "media_mime_type": null}, {"id": 40961, "message_id": "bot_3ADAF28ECB0FE0D7BE1C_7577", "sender": "bot", "message_type": "text", "content": "Thank you, Shafaqat Ali.", "created_at": "2026-06-09T15:54:08.257163", "media_url": null, "media_mime_type": null}, {"id": 40962, "message_id": "bot_3ADAF28ECB0FE0D7BE1C_2951", "sender": "bot", "message_type": "text", "content": "Which day suits you better for the consultation—25th or 26th?", "created_at": "2026-06-09T15:54:08.330685", "media_url": null, "media_mime_type": null}, {"id": 40963, "message_id": "bot_3ADAF28ECB0FE0D7BE1C_647", "sender": "bot", "message_type": "text", "content": "And do you prefer morning or afternoon?", "created_at": "2026-06-09T15:54:08.397737", "media_url": null, "media_mime_type": null}, {"id": 40964, "message_id": "bot_3ADAF28ECB0FE0D7BE1C_7852", "sender": "bot", "message_type": "text", "content": "Once you let me know, our team will contact you to confirm your appointment.", "created_at": "2026-06-09T15:54:08.465488", "media_url": null, "media_mime_type": null}, {"id": 40965, "message_id": "bot_3ADAF28ECB0FE0D7BE1C_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:54:08.534080", "media_url": null, "media_mime_type": null}, {"id": 40966, "message_id": "3A7183D7C9E6B7F8FF28", "sender": "user", "message_type": "text", "content": "26", "created_at": "2026-06-09T15:54:21.524436", "media_url": null, "media_mime_type": null}, {"id": 40970, "message_id": "3ABB7A912CFD031568D9", "sender": "user", "message_type": "text", "content": "Morning", "created_at": "2026-06-09T15:54:32.966160", "media_url": null, "media_mime_type": null}, {"id": 40971, "message_id": "bot_3ABB7A912CFD031568D9_7161", "sender": "bot", "message_type": "text", "content": "Thank you, Shafaqat Ali!", "created_at": "2026-06-09T15:54:42.264668", "media_url": null, "media_mime_type": null}, {"id": 40972, "message_id": "bot_3ABB7A912CFD031568D9_2139", "sender": "bot", "message_type": "text", "content": "Your request for a composite bonding consultation on the morning of the 26th has been sent to our team.", "created_at": "2026-06-09T15:54:42.330173", "media_url": null, "media_mime_type": null}, {"id": 40973, "message_id": "bot_3ABB7A912CFD031568D9_5150", "sender": "bot", "message_type": "text", "content": "They will contact you soon to confirm your appointment.", "created_at": "2026-06-09T15:54:42.383578", "media_url": null, "media_mime_type": null}, {"id": 40974, "message_id": "bot_3ABB7A912CFD031568D9_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:54:42.437934", "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 3333 in training_review_items