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_photo",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "The image shows a close-up of a dental cast model depicting a segment of upper anterior teeth. The material is light beige as typical of dental stone or plaster. One tooth on the right (from the viewer's perspective) is covered with a green wax or plastic material, suggesting a mock-up for either a crown, veneer, or try-in. The adjacent teeth are not covered and appear unfinished, with clear delineation lines between individual teeth. The background is out of focus and predominantly blue and white.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "front_upper",
        "observation": "Tooth on the right is covered with green material, possibly for restoration trial. Adjacent teeth are part of the cast and show typical anatomical contours with no visible artificial coloring or surface features.",
        "severity_signal": "unclear"
      }
    ],
    "gum_condition": "Not visible as this is a cast model with no soft tissues present.",
    "bone_level": null,
    "root_canals": null,
    "restorations_visible": ["Green wax or plastic material covering one upper anterior tooth, likely for prosthetic or aesthetic planning"],

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