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": "dental_xray",
  "image_quality": {
    "score": "moderate",
    "issues": ["partial_view", "medium_resolution", "photo_of_xray_printout", "background_distractions"]
  },
  "description": "Panoramic dental X-ray image printed on paper, captured as a photo. The X-ray shows full upper and lower jaws. There are significant dental prosthetics/implants visible: multiple implants placed in both the upper and lower arches, supporting extensive fixed restorations or bridges. Natural teeth do not appear to be present. No obvious native root anatomy visible, with what appears to be complete edentulism replaced by implant-supported fixed prostheses. The image background includes a blue fabric, cardboard, and several jars/containers, indicating a non-clinical setting. There is a visible printed date at the bottom: 'Date d'acquisition 23/02/2026 18:09'.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "none",
    "teeth_condition": [],
    "gum_condition": "Not visible on X-ray.",
    "bone_level": "Alveolar bone ridges are visible. No obvious signs of severe bone loss adjacent to implants, but fine details are limited due to the print/photo quality.",
    "root_canals": "Not applicable; no native teeth present.",

User message context: ```json
{
  "visible_domain": "dental_xray",
  "image_quality": {
    "score": "moderate",
    "issues": ["partial_view", "moderate contrast", "background objects visible"]
  },
  "description": "This is a printed panoramic dental X-ray image photographed on top of a cluttered surface (with towel and household jars visible in the background). The X-ray displays the entire upper and lower jaws. Multiple dental implants are visible: in the upper jaw, at least six implant fixtures are present supporting a full-arch prosthesis; in the lower jaw, at least four implant fixtures are visible, also with a fixed prosthesis. Most, if not all, natural teeth appear to be missing and are replaced by prosthetic components. There are high-density metallic restorations and some areas of less clear bone definition around the implants due to the radiopacity of the materials. At the right border of the image there is a radiopaque round object, resembling a radiographic marker or artifact. The date "23/02/2026 18:09" is visible at the bottom.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "none",
    "teeth_condition": [],
    "gum_condition": "Not directly visible due to the nature of panoramic X-ray and extensive metallic prostheses.",
    "bone_level": "Bone levels difficult to assess precisely due to extensive prost

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