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": "oral_photo",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "This is a high-resolution intraoral photo of the lower dental arch taken with retractors to keep the lips and cheeks away. The image shows the mandibular (lower) teeth from first molar to first molar in an occlusal view, with all visible crowns appearing mostly intact. The gums are light pink, and the mucosa of the floor of the mouth is visible. The tongue is not in view. Minimal plaque or deposits can be observed. No overt lesions or swelling are apparent. The crossing of dental midline appears largely straight. No text or identifying marks are present.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "all",
    "teeth_condition": [
      {
        "location": "lower_left",
        "observation": "Molars and premolars visible with smooth crowns, shallow occlusal grooves, minor fissure staining, no obvious large caries or fractures.",
        "severity_signal": "mild"
      },
      {
        "location": "front_lower",
        "observation": "Lower anterior teeth (incisors and canines) show no fractures, color is consistent, slight incisal edge translucency, no obvious crowding.",
        "severity_signal": "none"

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