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": 15378, "message_id": "ig_123804667488253_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDYxMTM3NzUzOTk2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTM1NzQ5OTEwMDIzMzgzMDozMjc2NDQxMDYxODY0NTc1NjkzNDUzNDcyOTI4OTQzMzA4OAZDZD_audio", "sender": "user", "message_type": "voice", "content": "[Voice message received but could not be transcribed. Ask the user to resend as text.]", "created_at": "2026-04-14T10:24:24.769884", "media_url": "/api/v1/chatbots/35/knowledge-bases/media/files/3983/download", "media_mime_type": "audio/mp4"}, {"id": 15379, "message_id": "bot_ig_123804667488253_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDYxMTM3NzUzOTk2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTM1NzQ5OTEwMDIzMzgzMDozMjc2NDQxMDYxODY0NTc1NjkzNDUzNDcyOTI4OTQzMzA4OAZDZD_audio_2621", "sender": "bot", "message_type": "text", "content": "Je suis désolé, mais je n'ai pas pu comprendre le message vocal. Pourriez-vous s'il vous plaît le renvoyer sous forme de texte ? Cela m'aidera à mieux vous assister. Merci !", "created_at": "2026-04-14T10:24:38.582746", "media_url": null, "media_mime_type": null}, {"id": 15381, "message_id": "owner_media_1c318ab1002143878a4fd17b1503eb05", "sender": "bot", "message_type": "voice", "content": null, "created_at": "2026-04-14T10:25:11.034753", "media_url": "/api/v1/chatbots/35/knowledge-bases/media/files/3984/download", "media_mime_type": "video/webm"}, {"id": 15386, "message_id": "owner_2b40678f45084c6fb6c3fb9fae4e0c99", "sender": "bot", "message_type": "text", "content": "hi", "created_at": "2026-04-14T10:26:08.661314", "media_url": null, "media_mime_type": null}, {"id": 15387, "message_id": "owner_media_7b77fb64618e47c188e34681381fbf9e", "sender": "bot", "message_type": "image", "content": null, "created_at": "2026-04-14T10:26:34.640939", "media_url": "/api/v1/chatbots/35/knowledge-bases/media/files/3988/download", "media_mime_type": "image/png"}, {"id": 15396, "message_id": "owner_media_df8d9d0a83f244afbeee13f5875917e6", "sender": "bot", "message_type": "voice", "content": null, "created_at": "2026-04-14T10:32:12.666804", "media_url": "/api/v1/chatbots/35/knowledge-bases/media/files/3990/download", "media_mime_type": "video/webm"}, {"id": 15398, "message_id": "owner_media_c12e23b85c464c159f1eceaadb5c1c0f", "sender": "bot", "message_type": "image", "content": null, "created_at": "2026-04-14T10:34:46.926900", "media_url": "/api/v1/chatbots/35/knowledge-bases/media/files/3991/download", "media_mime_type": "image/png"}, {"id": 15411, "message_id": "ig_123804667488253_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDYxMTM3NzUzOTk2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTM1NzQ5OTEwMDIzMzgzMDozMjc2NDQyOTYxNzAxMjYzMjM0ODA3MDI4MDc0NDE0MDgwMAZDZD_audio", "sender": "user", "message_type": "voice", "content": "[Voice message received but could not be transcribed. Ask the user to resend as text.]", "created_at": "2026-04-14T10:41:30.920635", "media_url": "/api/v1/chatbots/35/knowledge-bases/media/files/4001/download", "media_mime_type": "audio/mp4"}, {"id": 15412, "message_id": "bot_ig_123804667488253_aWdfZAG1faXRlbToxOklHTWVzc2FnZAUlEOjE3ODQxNDYxMTM3NzUzOTk2OjM0MDI4MjM2Njg0MTcxMDMwMTI0NDI1OTM1NzQ5OTEwMDIzMzgzMDozMjc2NDQyOTYxNzAxMjYzMjM0ODA3MDI4MDc0NDE0MDgwMAZDZD_audio_2621", "sender": "bot", "message_type": "text", "content": "Je suis désolé, mais je n'ai pas pu comprendre le message vocal. Pourriez-vous s'il vous plaît le renvoyer sous forme de texte ? Cela m'aidera à mieux vous assister. Merci !", "created_at": "2026-04-14T10:41:43.501917", "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 1120 in training_review_items