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_xray",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "A panoramic dental X-ray showing a full view of the upper and lower jaws. The teeth are clearly visible with good bone contrast. Measurement indicators are present on the right side of the image.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "all",
    "teeth_condition": [
      {
        "location": "upper_right",
        "observation": "wisdom tooth appears to be impacted, rest of the teeth appear normal",
        "severity_signal": "moderate"
      },
      {
        "location": "upper_left",
        "observation": "wisdom tooth appears to be impacted, rest of the teeth appear normal",
        "severity_signal": "moderate"
      },
      {
        "location": "lower_right",
        "observation": "teeth appear normal without any visible decay",
        "severity_signal": "none"
      },
      {
        "location": "lower_left",
        "observation": "teeth appear normal without any visible decay",
        "severity_signal": "none"
      }
    ],
    "gum_condition": "not visible",
    "bone_level": "bone levels appear normal with no significant bone loss visible",
    "root_canals": "not

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