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": 16683, "message_id": "A58BD13A7630ED6098D1431E3DCE8CB1", "sender": "user", "message_type": "text", "content": "Bonjour", "created_at": "2026-04-16T11:51:37.770566", "media_url": null, "media_mime_type": null}, {"id": 16684, "message_id": "bot_A58BD13A7630ED6098D1431E3DCE8CB1_4237", "sender": "bot", "message_type": "text", "content": "Bonjour 😊 Bienvenue au Centre Dentaire Dr DINANI Hicham. Comment puis-je vous aider ?", "created_at": "2026-04-16T11:51:51.687051", "media_url": null, "media_mime_type": null}, {"id": 16685, "message_id": "A521E211D41444AD2D103BDE15C039C5", "sender": "user", "message_type": "voice", "content": "[Voice message] Here is the transcription of the audio in Moroccan Darija and French:\n\n\"السلام سي عصام بخير كولشي مزيان؟ C'est possible عافاك تبدل ليا la date ديال هاد l'ordonnance؟ حيت أنا كنت فـ déplacement وكولشي وماساليتش باش ندفع لوراق وماهزيتهمش معايا، يالاه جيت ندفعهم اليوم قالوليا راه سالا، حيت هادا فيه le 13 أنا مانتبهتش كاع.\"", "created_at": "2026-04-16T11:53:44.122763", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/4447/download", "media_mime_type": "audio/ogg; codecs=opus"}, {"id": 16686, "message_id": "A5FF5EF66A2B9B6D915CBB70E1F8BD25", "sender": "user", "message_type": "image", "content": "[Image analysis] (a) **Type of image:**  \nThis appears to be a **prescription document** related to dental care, not a dental photo, x-ray, ID, or unrelated image.\n\n(b) **Description (if dental photo):**  \nNot applicable — this is not a dental photo.\n\n(c) **Visible text (OCR):**  \n```\nCabinet dentaire Dr. DINANI\nINPE : 104175096 - IF : 18782657 - ICE : 001646846000055 - TP : 26127\n\nSalé, le 13/02/2026\n\nMOUSSAOUI MARYAM\n\nBIOTIC PLUS 1 / 125 G / MG (POUDRE POUR SUSPENSION BUVABLE)\n\n1 sachet 2 F/J PDT 7 j\n\nDr DINANI HICHAM\n\nPHARMACIE COUD EL MARJOUH\nM. HANINE EL KASSAR\nHABITA 2 - HAY SALAM SALÉ\nTEL: 0537 82 94 64 - INP: 1029504\n\n(BIOTIC PLUS 1/125mg)\npoudre pour suspension 97.2/1.08 g/54ml\n6 118600 191023\n```\n(Some text is partially faded or blocked by fingers.)\n\n(d) **Flag:**  \n- **NO diagnostic terms used**\n- **NO suggestions of conditions**\n- **NO treatment", "created_at": "2026-04-16T11:53:48.748835", "media_url": "/api/v1/chatbots/40/knowledge-bases/media/files/4448/download", "media_mime_type": "image/jpeg"}, {"id": 16687, "message_id": "bot_A5FF5EF66A2B9B6D915CBB70E1F8BD25_217", "sender": "bot", "message_type": "text", "content": "واخا سي عصام، باش نقدر نبلغ الفريق الطبي ديالنا بخصوص تغيير تاريخ هاد l'ordonnance، ممكن تعطيني الإسم الكامل ديالك؟", "created_at": "2026-04-16T11:54:18.884305", "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 1255 in training_review_items