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 close-up intraoral photo of an adult's mouth with cheeks and lips retracted using a plastic retractor. Both upper and lower arches are clearly visible from canine to canine and premolars on both sides. The teeth show significant yellow-brown staining, particularly along the gum line and interproximal areas, with more pronounced deposits on the lower anterior teeth. Some teeth show mild to moderate wear and translucency at the incisal edges. The gum tissue appears generally pink but shows mild redness and inflammation, especially on the lower front and upper lateral areas. The lower anterior teeth show mild recession and visible calculus build-up. The alignment is slightly crowded, especially in the lower front. No obvious crowns, implants, or orthodontic appliances are present; some molars are not visible in this image.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "upper_right",
        "observation": "Teeth present up to the premolars with visible staining and slight misalignment; some teeth posteriorly are partially visible or missing.",
        "severity_signal": "moderate"
      },
      {
        "location": "upper_left",
        "observation

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