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": "person",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "The image shows a side profile view of a young adult female with a medium skin tone, standing in front of a wooden background, likely a door. Her hair is neatly tied back into a braid and she is wearing a grey textured cardigan over a dark top. She has a stud earring in her visible ear and is wearing two necklaces, one of which is beaded. The background is plain and there are no visible dental, oral, or medical instruments or settings.",
  "dental_observations": {
    "applicable": false,
    "teeth_present": "unclear",
    "teeth_condition": [],
    "gum_condition": "",
    "bone_level": null,
    "root_canals": null,
    "restorations_visible": [],
    "missing_teeth": "",
    "alignment": "",
    "calculus_plaque": "",
    "periapical_areas": "",
    "other_findings": ""
  },
  "text_visible": [],
  "possible_concerns": [],
  "service_candidates": [],
  "no_apparent_issue": {
    "value": true,
    "reason": "No notable concerns are observed in the context of this extraoral person photo. There are no visible injuries, asymmetries, or medical devices."

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