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": "moderate",
    "issues": []
  },
  "description": "The image shows a computer screen displaying a digital 3D dental model of the lower jaw. The model is zoomed in on a segment of the dental arch, showing four posterior teeth. The second to last molar is rendered with a noticeably lighter color and more surface detail, possibly indicating a restoration or a CAD/CAM-designed crown. The adjacent teeth are shown in a uniform tan color. The surroundings include part of a black computer keyboard, a white HP computer monitor with visible Windows and application icons on the bottom taskbar, and a marble-patterned surface.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "lower_left_posterior",
        "observation": "One molar is depicted in a lighter color, detailed with fissures and pits, likely representing a restoration or virtual crown. Adjacent teeth appear in a uniform tan shade suggesting they are part of the scan model rather than the final restoration.",
        "severity_signal": "none"
      }
    ],
    "gum_condition": "Gum tissue is not visible in the digital model presented on the screen.",
    "bone_level": null,
    "root_canals": null,

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