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": "This image is a promotional flyer for 'Labo Fournitures et Matériel Dentaires' advertising dental supplies and materials under the 'PROMOTION EXPO 2026'. The design is clean and modern, featuring a white and blue background with product images and prices displayed for various dental products, including dental whitening systems, adhesives, bulk-fill composites, bite registration materials, matrix systems, and other consumables. The bottom contains the business address and contact information. Product names, prices, discounts, and descriptive packaging details are visible.",
  "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": [
    "Labo",
    "Fournitures et Matériel Dentaires",
    "PROMOTION EXPO 2026",
    "WHITENESS HP 35% 600Dh",
    "WHITENESS HP MAXX",
    "

User message context: ```json
{
  "visible_domain": "document",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "This image is a promotional flyer for dental supply products, titled 'PROMOTION EXPO 2026.' It is branded with a logo for 'Labo Fournitures et Matériel Dentaires.' The flyer displays various dental materials and tools, each with a product image, name, description, and promotional price. The background is composed of light blue and white geometric patterns. Contact details, address, and phone numbers for the company are visible at the bottom.",
  "dental_observations": {
    "applicable": false,
    "teeth_present": "unclear",
    "teeth_condition": [],
    "gum_condition": null,
    "bone_level": null,
    "root_canals": null,
    "restorations_visible": [],
    "missing_teeth": null,
    "alignment": null,
    "calculus_plaque": null,
    "periapical_areas": null,
    "other_findings": null
  },
  "text_visible": [
    "Labo Fournitures et Matériel Dentaires",
    "PROMOTION EXPO 2026",
    "WHITENESS HP 35% 600Dh",
    "WHITENESS HP MAXX",
    "WHITENESS HP AUTOMIX + ARCFLEX =

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 50205 in messages