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 lower jaw (mandibular arch) from an occlusal view. The tongue is retracted, and a cheek retractor is in place. The teeth in the lower jaw are visible; several anterior teeth appear to have fixed dental crowns or a dental bridge. The gums (gingiva) are visible around the teeth, and there is significant white or yellowish material (likely calculus or food debris) accumulated on the molar teeth, especially on the left side (image right). The mucosa of the tongue appears moist and healthy.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "front_lower",
        "observation": "All visible anterior teeth (incisors and canines) have white prosthetic crowns, possibly a continuous bridge.",
        "severity_signal": "none"
      },
      {
        "location": "lower_left",
        "observation": "Molar tooth visible with moderate to significant yellowish-white buildup adjacent to the crown, possibly calculus or retained food debris.",
        "severity_signal": "significant"
      },
      {
        "location": "lower_right",

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