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": "oral_photo",
  "description": {
    "subject": "A person's mouth",
    "details": {
      "lips": {
        "upper_lip": "visible",
        "lower_lip": "visible",
        "description": "Both lips are partially open, revealing the teeth."
      },
      "teeth": {
        "upper_row": {
          "visible_teeth": "Several teeth visible",
          "appearance": "Teeth appear slightly misaligned and have a slightly yellowish hue."
        },
        "lower_row": {
          "visible_teeth": "Several teeth visible",
          "appearance": "Teeth appear slightly misaligned and have a slightly yellowish hue."
        }
      }
    },
    "context": "The photo is taken indoors with parts of a building visible in the background, indicating it's a casual setting."
  }
}
```

User message context: ```json
{
  "visible_domain": "oral_photo",
  "teeth": {
    "color": "predominantly yellow with some discoloration",
    "alignment": "minor crowding visible in the lower front teeth",
    "gums": "not prominently visible",
    "lips": "partially open, visible part of lower lip has a shiny appearance"
  },
  "context": {
    "indoor_outdoor": "indoor (glass reflection indicates presence in or near a building)",
    "additional_elements": "background includes blurred elements possibly indicating a street scene or urban area"
  }
}
```

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