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 view of a dental cast or model. Three teeth are represented, with the middle tooth fitted with a shiny metallic crown, likely metal or stainless steel. The adjacent teeth are made of a yellowish material (most likely dental stone/plaster). The occlusal anatomy and grooves of the metallic crown are clearly defined, and the fit against the neighboring teeth appears tight. The setting suggests a laboratory or clinical environment, with parts of a colorful background partially visible (shades of blue and green). No natural gum or oral tissue is shown.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "center (likely posterior molar)",
        "observation": "Tooth restored with a full metallic crown, occlusal morphology visible, no visible fractures or defects on the restoration.",
        "severity_signal": "none"
      },
      {
        "location": "left neighbor",
        "observation": "Replicated tooth structure in dental stone/plaster, intact with no visible defects.",
        "severity_signal": "none"
      },
      {
        "location": "right neighbor",
        "observation": "Replicated tooth structure

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