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": "This is a lateral (profile) cephalometric dental X-ray showing a full side view of the skull, cervical spine, and dental arches. The cranial outline, nasal structures, orbits, maxilla, mandible, temporomandibular joint (TMJ) area, cervical vertebrae, and all teeth are visible. A radiologic scale is present along the right edge. A faint circular artifact is present near the top, possibly due to reflection or external marker. Patient information and radiology center label are visible at the top. The dental arches are well visualized with both upper and lower teeth in occlusion, and developing permanent teeth are visible in the jaw.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "upper_right",
        "observation": "Several teeth with visible developing roots; mixed dentition suggests presence of both permanent and possibly retained primary teeth; no clear gross abnormalities visible.",
        "severity_signal": "none"
      },
      {
        "location": "upper_left",
        "observation": "Similar to upper right: developing teeth evident, mixed dentition pattern, no clear evidence of large caries

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