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-quality intraoral clinical photo showing the upper dental arch from an occlusal perspective. All teeth of the upper arch, including premolars and molars, are visible, as well as the palatal tissue. The gum tissue around the teeth appears pink and consistent, with no visible signs of bleeding, swelling, or significant recession. Tooth surfaces look generally smooth, with no obvious cavities, fractures, or severe discoloration. No visible dental restorations, crowns, fillings, or orthodontic appliances are present. Tooth alignment appears orderly with only minor rotation or crowding, if any. The palatal mucosa appears healthy, with normal coloration and texture. There are no obvious soft tissue lesions, growths, or major irregularities visible.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "all",
    "teeth_condition": [
      {
        "location": "upper_right",
        "observation": "All molars and premolars appear intact with normal anatomical features, no visible restorations or caries.",
        "severity_signal": "none"
      },
      {
        "location": "upper_left",
        "observation": "All molars and premolars appear intact with no visible restoration or

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