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

[Image analysis] ```json
{
  "visible_domain": "dental_photo",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "The image shows an intraoral mirror view focusing on the lower anterior teeth of an adult patient. The gingival tissues, labial mucosa, and lingual surfaces of the lower incisors and canines, as well as parts of the premolars, are clearly visible. The photograph shows a significant accumulation of yellowish-brown calculus and plaque deposits on the lingual surfaces of the lower anterior teeth. The gum tissue appears slightly erythematous in some areas, particularly in the interproximal regions. The teeth are generally intact with no obvious large caries, fractures, or major restorations visible in this view. Alignment of the lower anterior teeth appears crowded, especially in the central region.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "front_lower",
        "observation": "Significant yellowish-brown calculus and plaque deposits on the lingual surfaces of the lower incisors and canines. Crowding is visible in this region. No visible caries or large restoration.",
        "severity_signal": "significant"
      },
      {
        "location": "lower_left",
        "observation": "Calculus deposits are visible

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