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 an adult mouth with both upper and lower arches visible. All anterior teeth and majority of posterior teeth are visible. The teeth display a yellowish color with significant generalized staining, especially on the upper central incisors and interproximal areas. The gum tissue appears reddish, particularly at the papillae, and slightly inflamed in several regions. There appears to be mild to moderate plaque/calculus accumulation, notably near the gingival margins of both arches. Some teeth show signs of wear/faceted surfaces. There are mild irregularities in the alignment, such as crowding in lower anterior teeth. No obvious crowns, bridges, braces, or implants visible.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "all",
    "teeth_condition": [
      {
        "location": "front_upper",
        "observation": "Generalized yellow discoloration and staining, especially on central incisors. Surface wear evident. Darker stains interproximally. Facial surface irregularities.",
        "severity_signal": "moderate"
      },
      {
        "location": "front_lower",
        "observation": "Moderate crowding and rotational misalignment. Generalized yellowish discoloration and stain

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