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 is a collage with two distinct intraoral dental prosthesis views on a black background, with a central overlay of a clinic logo 'MiBO CENTRO ODONTOLÓGICO INTEGRAL AVANZADO.' The top photo shows a maxillary (upper) full-arch prosthesis with four visible abutment areas (likely for implant attachments), an integrated metal framework, and a set of artificial anterior teeth. The bottom photo shows a mandibular (lower) full-arch prosthesis also with four abutment attachment housings, and no visible teeth (the prosthesis is tissue-borne, designed for use with implants). Both prostheses show areas designed to interface with dental implants, evident by the round attachment housings. The pink acrylic base mimics gum tissue, with some wear and embedded metallic/white areas where abutments would lock. The background is clear and uncluttered.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "none",
    "teeth_condition": [],
    "gum_condition": "Gum tissue not visible; only pink acrylic portions of the prostheses are visible, designed to mimic the mucosa.",
    "bone_level": null,
    "root_canals": null

User message context: ```json
{
  "visible_domain": "dental_photo",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "The image is composed of two clinical photos showing upper and lower full-arch dental prostheses, likely implant-supported overdentures. Both prostheses are pink in color with visible metallic components and attachment housings for implants (four visible on the upper, two on the lower). The prostheses show artificial teeth in the anterior region of the upper arch with pink acrylic base mimicking gum tissue. No natural teeth are present in the prostheses themselves. Some areas show white blocks suggesting reinforcements or past repairs. The logo 'MIBO Centro Odontológico Integral Avanzado' is prominently overlaid between the two photos, partially obscuring the middle of the upper prosthesis. Background is black, providing good contrast.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "none",
    "teeth_condition": [],
    "gum_condition": "Artificial pink gum base; appears clean and well-adapted to the prosthesis base. No natural gum is visible, only prosthetic tissue.",
    "bone_level": null,
    "root_canals": null,
    "restorations_visible": [
      "Implant components visible (attachment housings, likely locator or similar)",
      "Metal reinforcement bar visible in the upper 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 8525 in messages