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_photo",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "The image shows two views of removable dental prostheses, likely implant-supported overdentures. The upper view (top) appears to be a maxillary overdenture, featuring pink acrylic material mimicking gums, artificial anterior teeth, and four visible implant attachment housings spaced across the denture base. A metallic framework is visible on the interior surface. The lower view (bottom) is a mandibular overdenture with two visible implant attachment housings, spaced in the anterior region, and areas showing signs of wear or underlying structure exposure. Both prostheses show no significant staining or damage on the external surfaces. In the center, there is a logo and text that partially obscure the image.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "none",
    "teeth_condition": [],
    "gum_condition": "Not directly visible as only the prostheses are shown, but the prosthetic gum portion appears intact and pink without significant discoloration.",
    "bone_level": null,
    "root_canals": null,
    "restorations_visible": [
      "Four implant attachment housings in the maxillary prosthesis, two in the mandibular prosthesis",
      "Artificial teeth present in the maxillary overdenture"
    ],
    "

User message context: ```json
{
  "visible_domain": "dental_photo",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "The image consists of two clinical photographs showing dental prosthetic devices, presumably upper and lower complete dentures with implant attachments. The upper image shows the internal (intaglio) surface of a maxillary denture with four visible metallic housing attachments, designed to fit onto dental implants. Two anterior prosthetic teeth are partially visible. There is a metallic reinforcement bar in the center. The lower image shows the internal surface of a mandibular denture with two visible implant housings and some metallic reinforcement in the structure. Both prostheses appear clean, made of pink acrylic resin to resemble gum tissue, with the attachments colored blue-green. A watermark with the text 'MIBO CENTRO ODONTOLÓGICO INTEGRAL AVANZADO' is present across the center, partially obstructing both images. The background is entirely black, focusing attention on the prostheses.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "upper_anterior",
        "observation": "Two anterior teeth are present in the upper denture and appear intact",
        "severity_signal": "none"
      }
    ],
    "gum_condition": "Not directly visible; the pink

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