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 photograph showing the front and side views of both upper and lower teeth with lips and cheeks retracted. The gingiva is visible around all teeth. The image clearly displays the color, shape, alignment, and surface of teeth and adjacent gum tissue. Teeth appear natural, no obvious restorations are present. There are some mild discolorations and slight variation in tooth shade, with lower anterior teeth being more yellow than uppers, and mild visible calculus deposition. Tooth alignment presents minor crowding in the lower anterior region.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "all",
    "teeth_condition": [
      {
        "location": "front_upper",
        "observation": "Maxillary central and lateral incisors appear intact with some light staining towards incisal edge. No obvious caries or fractures.",
        "severity_signal": "mild"
      },
      {
        "location": "front_lower",
        "observation": "Mandibular anterior teeth present with visible crowding and rotated appearance, especially central and lateral incisors. More yellowish hue compared to upper teeth. Visible calculus at the gumline.",
        "severity_signal": "mild"
      },
      {
        "location

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