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": 7098, "message_id": "ACA0AFB1AD94ABBF4925EF376A52DA17", "sender": "user", "message_type": "text", "content": "اسم عبدالحي حسون", "created_at": "2026-03-26T16:26:41.752692", "media_url": null, "media_mime_type": null}, {"id": 7099, "message_id": "AC03E77626A9D929CE72C1DD67D44A36", "sender": "user", "message_type": "text", "content": "LB 214638", "created_at": "2026-03-26T16:26:54.885423", "media_url": null, "media_mime_type": null}, {"id": 7100, "message_id": "bot_AC03E77626A9D929CE72C1DD67D44A36_9741", "sender": "bot", "message_type": "text", "content": "شكرا السي عبدالحي حسون على المعلومات. إذا كان عندك أي استفسار آخر أو تحتاج لأي مساعدة إضافية، أنا هنا رهن الإشارة ديالك. 😊", "created_at": "2026-03-26T16:27:04.570360", "media_url": null, "media_mime_type": null}, {"id": 7103, "message_id": "ACD5DAB32DFC34522B8A1A33A5F031D6", "sender": "user", "message_type": "text", "content": "تريخ ازدياد 1995 /20/12", "created_at": "2026-03-26T16:28:14.480550", "media_url": null, "media_mime_type": null}, {"id": 7104, "message_id": "bot_ACD5DAB32DFC34522B8A1A33A5F031D6_403", "sender": "bot", "message_type": "text", "content": "شكرا على المعلومات الإضافية، السي عبدالحي. إذا كان عندك أي استفسار آخر أو تحتاج لأي مساعدة، لا تتردد في التواصل معي. 😊", "created_at": "2026-03-26T16:28:28.593515", "media_url": null, "media_mime_type": null}, {"id": 7131, "message_id": "A5334DD15F7A5F941A3ED0C2EB67F34B", "sender": "bot", "message_type": "text", "content": "Safi akhay", "created_at": "2026-03-26T17:08:07.957583", "media_url": null, "media_mime_type": null}, {"id": 7137, "message_id": "A5300A977F0CC35BBEA6EEE56C91B297", "sender": "bot", "message_type": "voice", "content": "[Voice message] هي بالنسبة للرونديڤو إن شاء الله نهار السبت، صافي؟\n\n**Latin script:**\nHey, b-nisba l-rendez-vous in-sha'Allah nhar sebt, safi?", "created_at": "2026-03-26T17:16:22.149886", "media_url": "/api/v1/chatbots/41/knowledge-bases/media/files/1450/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 7138, "message_id": "AC9D2C1DE17FFC09A51AC0D3ADDFCC4D", "sender": "user", "message_type": "text", "content": "<reply_to>[Audio Message]</reply_to> Sf wakha", "created_at": "2026-03-26T17:16:51.502975", "media_url": null, "media_mime_type": null}, {"id": 7139, "message_id": "ACCD286C7D38D9F105A89EF2C6E1B9B7", "sender": "user", "message_type": "text", "content": "Kheti", "created_at": "2026-03-26T17:16:53.552192", "media_url": null, "media_mime_type": null}, {"id": 7140, "message_id": "ACCE57E3086FC1E98CCBB27EC63E65E5", "sender": "user", "message_type": "text", "content": "Xmin sa3a", "created_at": "2026-03-26T17:16:58.298895", "media_url": null, "media_mime_type": null}, {"id": 7141, "message_id": "A5644A41703540DFFEB8313A6EB65AB4", "sender": "bot", "message_type": "text", "content": "Aji m3a 1:30H", "created_at": "2026-03-26T17:17:13.002012", "media_url": null, "media_mime_type": null}, {"id": 7142, "message_id": "bot_ACCE57E3086FC1E98CCBB27EC63E65E5_6170", "sender": "bot", "message_type": "text", "content": "مرحبا السي عبدالحي، بالنسبة للرونديڤو نهار السبت، واش كاين شي وقت محدد اللي كيناسبك؟ قولي الوقت اللي كتشوفه مناسب ليك باش نبلغ الفريق ونتاصلو بيك لتأكيد الموعد إن شاء الله. 😊", "created_at": "2026-03-26T17:17:23.415559", "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 254 in training_review_items