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": "non_dental",
  "image_quality": {
    "score": "moderate",
    "issues": ["blur", "partial_view"]
  },
  "description": "The image is taken from inside a car, showing a highway/road with at least two lanes and a concrete median barrier on the right side. The photo is oriented forward through the windshield with part of the car's dashboard and steering wheel visible at the bottom. On the dashboard, an illuminated speedometer is displayed, showing a speed of 102 (likely km/h). There is moderate reflection and glare, possibly from the sun, particularly on the left side of the image. The road ahead is clear, with only a few cars visible—one car is directly in front in the same lane, and another is farther ahead. The sky is partly cloudy with a mix of light and darker clouds, and the sun appears to be low, perhaps early morning or late afternoon. The surroundings include trees and vegetation on both sides, with a sign and billboard visible in the distance but not readable. The temperature shown on the dashboard reads 13°C, and the time appears to be 06:56.",
  "dental_observations": {
    "applicable": false,
    "teeth_present": "unclear",
    "teeth_condition": [],
    "gum_condition": "",
    "bone_level": null,
    "root_canals": null,

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