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": "This is a close-up, well-lit intraoral photo showing both the upper and lower anterior and premolar teeth between the right and left sides of the mouth. Both arches and gingiva are visible. The teeth appear generally clean with a natural shade. There is some overlapping of the lower front teeth and possibly slight dental crowding. Gums look generally pink, with no obvious swelling or redness. No major discoloration, visible large caries, or apparent restorations are present. Overlays with the labels 'Right side' and 'Left side' are seen at the bottom of the image.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "front_upper",
        "observation": "Upper central and lateral incisors are visible, appear intact, slight irregularity in alignment, no obvious discoloration or caries noted.",
        "severity_signal": "none"
      },
      {
        "location": "front_lower",
        "observation": "Lower anterior teeth show crowding, with overlapping of lower incisors. No gross cavities or fractures are visible.",
        "severity_signal": "mild"
      },
      {
        "location": "upper_right

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