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": "oral_photo",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "Close-up intraoral photograph of the left side profile of an individual's mouth. Both upper and lower teeth are partially visible, with the image showing the teeth in an open occlusion. The lips are parted to display the teeth clearly. Gums are visible along the upper arch but less so on the lower. There are no obvious obstructing factors, and the image is in focus with accurate color representation. No visible soft tissue lesions or pronounced swelling are apparent.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "upper_left",
        "observation": "Several anterior and premolar upper teeth visible, teeth are mostly white with minor translucency and some slight irregularities in incisal edges. No obvious caries or fractures visible.",
        "severity_signal": "none"
      },
      {
        "location": "lower_left",
        "observation": "Lower anterior and premolar teeth visible, appear aligned with minor natural variation. No obvious caries or fractures visible.",
        "severity_signal": "none"
      }
    ],
    "gum_condition": "Gingival tissue visible in the upper left quadrant appears pink and healthy, no marked swelling, redness,

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