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": "moderate",
    "issues": ["low_resolution", "slight_blur"]
  },
  "description": "The image is a panoramic dental X-ray showing both arches with a focus on the upper jaw. Several dental implants are visible, particularly in the upper arch (maxilla), distributed from the left to the right posterior region. Some of these implants support prosthetic crowns or bridges, while others appear as stand-alone implants. There appear to be additional implants placed in the lower jaw (mandible), but without associated crowns or bridges. The bone contrast is moderate, but some details are lost due to general low resolution. No obvious natural tooth roots are visible; the dental arch is predominantly composed of radiopaque implant fixtures. Some posts or abutments may be visible associated with the implants. There is no clear evidence of large radiolucent periapical lesions, though the image quality limits fine-detail assessment. No patient name, date, or identifying text is visible in the scan area.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "none",
    "teeth_condition": [],
    "gum_condition": "Not visible on X-ray; only bone and prosthetic margins can be inferred.",
    "bone_level": "Bone levels around implants appear generally maintained but detailed assessment is limited by

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