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": 39794, "message_id": "3EB0D1FBBC3F6C2D2D315A", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*ETTIJER ABDELKHALEK*\r\nVous avez Rendez Vous avec *DR OUSSAMA MOUALLEM* le *mercredi 10 juin 2026* à *11:00* .\r\nEn cas d'empêchement, veuillez contacter la réception \r\n*060022263 / 0539948014*\r\nMerci pour votre attention.\r\n\r\n.مرحبًا\r\n**\r\nلديكم موعد مع ** يوم *الأربعاء 10 يونيو 2026* على الساعة *11:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-06T12:06:36.968511", "media_url": null, "media_mime_type": null}, {"id": 43657, "message_id": "A5D7FDAC67E279F06999144B973283DC", "sender": "bot", "message_type": "text", "content": "Je ne suis pas disponible. Ça va ?", "created_at": "2026-06-15T12:09:00.400569", "media_url": null, "media_mime_type": null}, {"id": 43833, "message_id": "AC9BA35ADDCFDF53A55595051DD71DC2", "sender": "user", "message_type": "text", "content": "Bonjour, toujours J'attend votre réponse ? Rendez vous. Merci", "created_at": "2026-06-15T16:10:36.884465", "media_url": null, "media_mime_type": null}, {"id": 43845, "message_id": "A528D7CE6DE5484B8283FC1597990273", "sender": "bot", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija (using Arabic script):\n\n**السلام عليكم سي خالد، كيداير بخير؟ كون هاني، أنا غانعطيك rendez-vous. أنا سولت كاع les techniciens خدامين ف les PC، يساليوا أنا غانعطيك rendez-vous. أنا كنشوف ليك زعما شي وقيت فهاد السيمانة هادي.**\n\n***\n\n**Transliteration (Latin Script):**\n*السلام عليكم (Assalamu alaykum) si Khalid, ki dayer bekhir? Kon hani, ana ghan'3tik rendez-vous. Ana swwelt ga3 les techniciens khaddamin f les PC, isaliw ana ghan'3tik rendez-vous. Ana kanchouf lik za3ma chi wqit f had s-semana hadi.*", "created_at": "2026-06-15T16:14:06.213799", "media_url": "/api/v1/chatbots/46/knowledge-bases/media/files/12089/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 43852, "message_id": "3EB0592EA977E221FAA4A5", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*ETTIJER ABDELKHALEK*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *jeudi 18 juin 2026* à *17:00* .\r\nEn cas d'empêchement, veuillez contacter la réception \r\n*060022263 / 0539948014*\r\nMerci pour votre attention.\r\n\r\n.مرحبًا\r\n**\r\nلديكم موعد مع ** يوم *الخميس 18 يونيو 2026* على الساعة *17:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-15T16:17:58.449439", "media_url": null, "media_mime_type": null}, {"id": 43866, "message_id": "AC58A644EE7166199F8F8B6A12B775E0", "sender": "user", "message_type": "text", "content": "Ok merci", "created_at": "2026-06-15T16:26:38.321420", "media_url": null, "media_mime_type": null}, {"id": 44894, "message_id": "3EB006EEC9C2BA9DD1E02D", "sender": "bot", "message_type": "text", "content": "Bonjour \r\n*ETTIJER ABDELKHALEK*\r\nVous avez Rendez Vous avec *Dr. Haitham Boutaib* le *jeudi 18 juin 2026* à *17:00* .\r\nEn cas d'empêchement, veuillez contacter la réception \r\n*060022263 / 0539948014*\r\nMerci pour votre attention.\r\n\r\n.مرحبًا\r\n**\r\nلديكم موعد مع ** يوم *الخميس 18 يونيو 2026* على الساعة *17:00*  ﮶    \r\nفي حالة وجود عائق يرجى الاتصال بمكتب الاستقبال\r\n*060022263 / 0539948014*\r\nشكرا لتفهمكم", "created_at": "2026-06-17T15:00:04.952158", "media_url": null, "media_mime_type": null}, {"id": 44896, "message_id": "AC52E5742FAB0921DB213B0A7D498AD7", "sender": "user", "message_type": "text", "content": "Oui", "created_at": "2026-06-17T15:00:31.012583", "media_url": null, "media_mime_type": null}, {"id": 44898, "message_id": "bot_AC52E5742FAB0921DB213B0A7D498AD7_2321", "sender": "bot", "message_type": "text", "content": "Merci pour votre confirmation !", "created_at": "2026-06-17T15:01:03.388014", "media_url": null, "media_mime_type": null}, {"id": 44899, "message_id": "bot_AC52E5742FAB0921DB213B0A7D498AD7_5239", "sender": "bot", "message_type": "text", "content": "Votre rendez-vous avec Dr Haitham Boutaib est bien noté pour jeudi 18 juin 2026 à 17h00.", "created_at": "2026-06-17T15:01:03.425757", "media_url": null, "media_mime_type": null}, {"id": 44900, "message_id": "bot_AC52E5742FAB0921DB213B0A7D498AD7_6042", "sender": "bot", "message_type": "text", "content": "Si jamais vous avez un empêchement, n'hésitez pas à contacter la réception au 060022263 ou 0539948014.", "created_at": "2026-06-17T15:01:03.462711", "media_url": null, "media_mime_type": null}, {"id": 44901, "message_id": "bot_AC52E5742FAB0921DB213B0A7D498AD7_2987", "sender": "bot", "message_type": "text", "content": "À bientôt !", "created_at": "2026-06-17T15:01:03.499754", "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 3707 in training_review_items