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] Image description: ```json
{
  "visible_domain": "dental_xray",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "This is a lateral cephalometric X-ray image showing a side view of the skull, cervical vertebrae, nasal cavity, sinuses, mandible, and maxilla. The full dentition in both upper and lower jaws is visible, though some tooth details are overlapped due to the projection. Both the hard and soft tissues of the face are outlined. Skeletal structures including the mandible, maxilla, spine, zygomatic arch, and nasal bones are clearly visible, along with some dental anatomy. No gross artifacts or obstructions are present. There are graduated measurement markers visible on the right side of the image, but no patient identifiers or text labels.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "all",
    "teeth_condition": [
      {
        "location": "front_upper",
        "observation": "Teeth visible in the maxillary anterior region appear intact; overlapping is present due to X-ray angle.",
        "severity_signal": "none"
      },
      {
        "location": "front_lower",
        "observation": "Mandibular anterior teeth visible, no obvious pathology detected.",
        "severity_signal": "none"
      },
      {
        "location": "upper

User message context: ```json
{
  "visible_domain": "dental_xray",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "This is a lateral cephalometric dental X-ray of a human skull in profile view. The bones of the cranium, facial structures, cervical vertebrae, nasal cavity, maxilla, mandible, and teeth are clearly visible. The upper and lower jaw arches show both anterior and posterior teeth. The outline of the soft tissue profile of the face (nose, lips, chin) is also apparent. A measuring scale is present along the right border of the image, providing a graduated measurement for anatomical assessment. No significant artifacts or overexposure are seen. No visible dental prostheses, orthodontic appliances, or implants are apparent. Anatomical landmarks for cephalometric tracing such as sella, nasion, and menton can be identified.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "all",
    "teeth_condition": [
      {
        "location": "upper_jaw",
        "observation": "All maxillary teeth including incisors, canines, premolars, and molars are visible. No gross fractures or major radiolucencies noted.",
        "severity_signal": "none"
      },
      {
        "location": "lower_jaw",
        "observation": "All

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