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": "object",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "The image shows a close-up view of a dental model, likely made from a yellowish dental stone or plaster material. On top of the model, there are three adjacent green structures shaped like teeth, which appear to be wax patterns. The green wax designs cover the occlusal and buccal surfaces of the underlying stone teeth, indicating this is likely a prosthodontic wax-up for dental restorations such as crowns or bridges. No natural soft tissue or oral structures are present. The photo is well-lit and the wax patterns are clearly visible with some glossiness on their surfaces. The background is out of focus but appears blue and white, possibly indicating a clinical or laboratory setting.",
  "dental_observations": {
    "applicable": false,
    "teeth_present": "unclear",
    "teeth_condition": [],
    "gum_condition": null,
    "bone_level": null,
    "root_canals": null,
    "restorations_visible": [],
    "missing_teeth": null,
    "alignment": null,
    "calculus_plaque": null,
    "periapical_areas": null,
    "other_findings": null
  },
  "text_visible": [],
  "possible_concerns": [],
  "service_candidates":

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