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

```json
{
  "visible_domain": "oral_photo",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "The image shows a close-up of the lower part of a person's face, focusing on the mouth in a smile. Both upper and lower teeth are visible, with the upper lip withdrawn. The upper and lower anterior teeth are clearly shown, and there is a yellow outline over the upper teeth and gums, likely indicating a marking or highlighting. The gums and surrounding lips are visible, with natural lip color. The lower facial hair and mustache are present. The background is not visible. At the bottom, a phone number (+212 705-135623) and the text 'Voeg onderschrift toe...' are overlaid, with an interface element suggesting the image comes from a messaging or social media app.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "all",
    "teeth_condition": [
      {
        "location": "front_upper",
        "observation": "Central and lateral incisors appear well-formed, no obvious caries or fractures. Slight color variation among the anterior teeth.",
        "severity_signal": "none"
      },
      {
        "location": "upper_left canine-premolar area",
        "observation": "Crowding is visible, with some teeth slightly overlapping.",
        "severity_signal": "m

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