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": 44098, "message_id": "AC963AC1C8AFA66EBF7ED6283FEAB074", "sender": "user", "message_type": "voice", "content": "", "created_at": "2026-06-16T09:18:55.905900", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12158/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 44111, "message_id": "A5EAF1AE1E770E5B2EEA8C3180BCF1AD", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-06-16T09:32:35.121178", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12168/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 44208, "message_id": "ACEA26168E4A196D76E737A4F8FE8ACE", "sender": "user", "message_type": "text", "content": "Mardi atkon disponible", "created_at": "2026-06-16T09:42:35.431657", "media_url": null, "media_mime_type": null}, {"id": 44210, "message_id": "A5348DDD9F48AD0688FF39565F627488", "sender": "bot", "message_type": "text", "content": "Marhba", "created_at": "2026-06-16T09:49:46.555819", "media_url": null, "media_mime_type": null}, {"id": 44211, "message_id": "A54D631799B248986E3272EBB8C52994", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-06-16T09:49:51.385998", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12169/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 44213, "message_id": "AC94CA80E652F3EE4341B9F1402F6D11", "sender": "user", "message_type": "text", "content": "L mama", "created_at": "2026-06-16T10:01:04.176456", "media_url": null, "media_mime_type": null}, {"id": 44215, "message_id": "A5828ACED5C6BEA435BCABAFB4D34507", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-06-16T10:05:09.792110", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12170/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 44225, "message_id": "AC4971127660A8A8555F45497B9348D2", "sender": "user", "message_type": "voice", "content": "", "created_at": "2026-06-16T10:27:42.841631", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12176/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 44282, "message_id": "A5BC16FD6F5F79D78A39B5CC0DB142FA", "sender": "bot", "message_type": "voice", "content": "", "created_at": "2026-06-16T11:24:22.017557", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12201/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 48382, "message_id": "AC32E0CAF6EB20EA28461D9C09272555", "sender": "user", "message_type": "text", "content": "Salam", "created_at": "2026-06-25T10:30:41.283566", "media_url": null, "media_mime_type": null}, {"id": 48383, "message_id": "AC8BCC5C4090B2E1D9CE3409C0BD69D4", "sender": "user", "message_type": "text", "content": "Hbiba sifti li localisation 3afak", "created_at": "2026-06-25T10:30:49.436148", "media_url": null, "media_mime_type": null}, {"id": 48384, "message_id": "bot_AC8BCC5C4090B2E1D9CE3409C0BD69D4_6116", "sender": "bot", "message_type": "text", "content": "Centre Dentaire Tanger Bay كاين ف Avenue Mohammed VI، Résidence Borj Khalij Tanger 3، étage 5، appartement numéro 197، طنجة  \nhttps://maps.app.goo.gl/RCzcJXSXvgMzrRMFA\n\nإلى احتاجيتي شي توضيح آخر أنا هنا! 😊", "created_at": "2026-06-25T10:31:05.186985", "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 4001 in training_review_items