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": "This is a high-resolution intraoral photo showing the mandibular (lower) anterior teeth and premolars from a lingual (inside the mouth) view. The image clearly displays the gums, teeth surfaces, and a lingual fixed retainer wire bonded to the lingual surfaces of the six front teeth. There is visible calculus and/or staining along the cervical margins of the teeth, notably near the retainer. The gums appear generally healthy with some mild redness near the interproximal spaces. All visible teeth appear intact, and no gross caries or fractures are noted. A dental mirror is used to aid retraction and provide visibility of the teeth and wire. No visible text or identifying marks are present.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "front_lower",
        "observation": "Lingual fixed retainer (metal wire) bonded from canine to canine; some yellow-brown discoloration/staining and calculus at the cervical (gum line) margin of the teeth, especially near retainer",
        "severity_signal": "mild"
      },
      {
        "location": "lower_left",
        "observation": "Premolar

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