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": "The image is a close-up intraoral photo of the left side of the mouth, showing several upper and lower teeth with a dental cheek retractor in place. Visible are the upper and lower anterior and premolar teeth, the gums (gingiva), part of the upper lip, and slight facial hair. The gum tissue in the upper left area appears visibly red and swollen, especially above the canines and premolars. Several of the teeth, particularly in the lower jaw and premolar area, show brownish or yellowish discoloration, possibly stains or deposits. Some teeth have irregular edges, and there is mild crowding.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "upper_left_premolars",
        "observation": "Moderate brown discoloration on biting surfaces, irregular positioning, some contact loss, possible calculus or decay.",
        "severity_signal": "moderate"
      },
      {
        "location": "lower_left_premolars",
        "observation": "Visible yellow-brown deposits at gum line, mild crowding, possible early caries or significant staining.",
        "severity_signal": "moderate"

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