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
{
  "analysis_version": "1.0",
  "image_quality": {
    "score": 70,
    "issues": ["angle_limited", "partial_view"]
  },
  "visible_domain": "non_dental",
  "observations": [
    {
      "feature": "portrait",
      "evidence": "image shows a person's face from the shoulders up",
      "severity": "none"
    }
  ],
  "possible_concerns": [],
  "service_candidates": [],
  "no_apparent_issue": {
    "value": true,
    "reason": "image does not show dental aspects"
  },
  "recommended_questions": [
    "What exactly concerns you most (color, alignment, pain, gums, other)?",
    "How long has this been present?",
    "Any pain, bleeding, swelling, fever, trauma, or sensitivity?"
  ],
  "needs_additional_inputs": {
    "value": true,
    "requested": [
      "front smile photo in good light",
      "close-up of upper/lower teeth",
      "left and right side views"
    ]
  },
  "urgent_flags": {
    "needs_urgent_human_review": false,
    "signals": []
  },
  "safety_note_for_orchestrator": "AI image assessment only; not a diagnosis."
}
```

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