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": "dental_xray",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "The image is a lateral cephalometric tracing labeled as 'WebCeph Analysis.' It contains a lateral skull profile (blue tracing of hard and soft tissue), multiple superimposed angular and linear measurements in red and green, and a corresponding list of cephalometric parameters on the left. The craniofacial skeleton, maxilla, mandible, teeth positions, and some soft tissue contours are traced. Multiple reference lines and measured angles are drawn between cranial, dental, and soft tissue landmarks. No dental caries, restorations, or gross anatomical abnormalities are visible, as this is a tracing and not an actual X-ray image. Several specific measurement values are shown on the tracing (e.g., 113.6°, 79.4°, 160.8, etc.), corresponding to the parameters on the left.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "unclear",
    "teeth_condition": [
      {
        "location": "unclear",
        "observation": "Individual teeth are not specifically traced or labeled; only incisor positions related to cephalometric reference lines are inferred.",
        "severity_signal": "unclear"
      }
    ],
    "gum_condition": "Not visible

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