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 dental model, likely made of yellowish dental stone/plaster, containing three teeth. The central tooth has a shiny metallic crown restoration (possibly a full metal crown), clearly demarcated from the adjacent teeth, which remain unrestored in the model. The crown displays detailed occlusal anatomy. The surrounding environment has a colored background with blue, green, and grey tones, possibly a dental lab surface. No soft tissues or gums are visible, as this is a stone model.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "center_tooth (likely lower molar)",
        "observation": "Shiny metallic crown fully covers the tooth. Anatomical grooves and cusps are visible. Appears well-adapted to the model with no gross overhangs or visible margin gaps.",
        "severity_signal": "none"
      },
      {
        "location": "left_adjacent_tooth",
        "observation": "Intact stone model of a tooth, unrestored, no visible damage.",
        "severity_signal": "none"
      },
      {
        "location": "right_adjacent_tooth",
        "

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