SQLite Web: app.db

id

Primary key. INTEGER

conversation_id

INTEGER NOT NULL

message_id

TEXT NOT NULL

sender

TEXT NOT NULL

message_type

TEXT NOT NULL (default 'text'

content

[Image analysis] Image description: ```json
{
  "visible_domain": "document",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "The image shows a digital transaction receipt with a black background and text in white and gray. The transaction amount is 500.00 DH. The receipt is for a dentist named 'Haytam Dentiste.' It includes reference details, the transaction type, sender and beneficiary information, sender account number, beneficiary RIB, amount, transaction status, initiation and execution dates, and the reason for the transfer. The status is marked as 'Executed.' Most fields use standard French banking transaction terms.",
  "dental_observations": {
    "applicable": false,
    "teeth_present": "unclear",
    "teeth_condition": [],
    "gum_condition": "",
    "bone_level": null,
    "root_canals": null,
    "restorations_visible": [],
    "missing_teeth": "",
    "alignment": "",
    "calculus_plaque": "",
    "periapical_areas": "",
    "other_findings": ""
  },
  "text_visible": [
    "500,00 DH",
    "Haytam Dentiste",
    "Référence",
    "354145082",
    "Type du virement",
    "Standard",
    "Emetteur",
    "MME MACHAR KAOUTAR",
    "Compte émetteur",

User message context: ```json
{
  "visible_domain": "document",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "The image captures a digital screenshot or photo of a money transfer confirmation. The document is in French, with a dark background and white text, showing details of a bank transfer. It records a payment of 500,00 DH to 'Haytam Dentiste'. The document includes a transaction reference, type of transfer, sender and recipient details, account numbers, status, dates of initiation and execution (both on 13/04/2026), and the reason for the transfer, which is 'Avence Dentiste'.",
  "dental_observations": {
    "applicable": false,
    "teeth_present": "unclear",
    "teeth_condition": [],
    "gum_condition": "",
    "bone_level": null,
    "root_canals": null,
    "restorations_visible": [],
    "missing_teeth": "",
    "alignment": "",
    "calculus_plaque": "",
    "periapical_areas": "",
    "other_findings": ""
  },
  "text_visible": [
    "500,00 DH",
    "Haytam Dentiste",
    "Référence",
    "354145082",
    "Type du virement",
    "Standard",
    "Emetteur",
    "MME MACHAR KAOUTAR",

TEXT

media_url

TEXT

media_mime_type

TEXT

chatbot_id

INTEGER NOT NULL

created_at

TEXT NOT NULL

status

TEXT (default 'sent'

delivered_at

TEXT

read_at

TEXT

sender_user_id

TEXT

metadata

TEXT

app.db — messages

Update row 15106 in messages