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] ```json
{
  "visible_domain": "dental_photo",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "The image shows a dental cast (study model) of the upper jaw, held by a gloved hand. The cast includes teeth and gingival contours, with some teeth marked with dark blue or black pen on the occlusal surfaces. There is a pink-shaded artificial tooth (possibly indicating an edentulous area or prosthetic marker) visible toward the center. The cast has the word 'crochet' written on its side in pen. The background shows a computer keyboard and a wooden desk surface. There is also a plastic bag partially in the frame.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "front_upper",
        "observation": "Presence of a pink-colored artificial tooth or wax-up among natural or model teeth, suggesting space maintenance or pending prosthetic work.",
        "severity_signal": "moderate"
      },
      {
        "location": "upper_left",
        "observation": "At least two teeth marked with blue/black pen, possibly indicating preparation or planned attachment areas, one with wear or preparation visible.",
        "severity_signal": "mild"
      },
      {
        "location": "upper_right",

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