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

```json
{
  "visible_domain": "dental_xray",
  "image_quality": {
    "score": "good",
    "issues": []
  },
  "description": "This is a high-quality panoramic dental X-ray showing the maxilla (upper jaw) and mandible (lower jaw) in full. All tooth positions from left to right are visualized, including third molars (wisdom teeth) in all four quadrants. The bony outlines of the jaws, maxillary sinuses, and nasal cavity are visible. Root and crown morphology for the majority of teeth is clearly defined. No major artifacts or obstructions are present. Scale is shown on the right side.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "all",
    "teeth_condition": [
      {
        "location": "lower_left_third_molar",
        "observation": "Tooth is impacted, mesioangular position, crown directed anteriorly, appears to be partially developed.",
        "severity_signal": "moderate"
      },
      {
        "location": "lower_right_third_molar",
        "observation": "Tooth is impacted, mesioangular position, crown directed anteriorly, partially erupted.",
        "severity_signal": "moderate"
      },
      {
        "location": "upper_right_third_molar",
        "observation": "Tooth is present,

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