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": "moderate",
    "issues": ["partial_view", "paper_document_artifact"]
  },
  "description": "The image shows a printed panoramic dental X-ray placed on a paper with visible background edges. The X-ray depicts the full upper and lower jaws. Several dental implants are visible in both arches, mostly in the upper arch, with a fixed prosthesis or bridge attached to some implants. There are few or no natural teeth present. Some implant abutments are visible without crowns attached. The bone structure can be assessed in the panoramic view. There is printed text above and below the X-ray, rotated sideways, with a date, patient's name, dossier number, and technical parameters.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "upper_jaw_general",
        "observation": "Multiple dental implants are present, with a large fixed prosthesis/bridge replacing much of the natural dentition. No natural teeth are apparent in the upper arch. Some implants appear to be without prosthetic crowns.",
        "severity_signal": "significant"
      },
      {
        "location": "lower_jaw_general",
        "observation": "Partial dentition with several implants visible. Few natural teeth appear present,

User message context: ```json
{
  "visible_domain": "dental_xray",
  "image_quality": {
    "score": "moderate",
    "issues": ["partial_view", "slight blur", "scan of printed film"]
  },
  "description": "The image is a panoramic dental X-ray, photographed as a printout. The X-ray shows both jaws. Multiple dental implants are visible in both the upper and lower jaws, some supporting fixed prostheses (bridges). There are several teeth visible, mostly in the lower anterior region. There are edentulous (missing teeth) spaces in the upper jaw, replaced by implants and bridgework. The lower jaw also shows evidence of prosthetic restoration supported by implants. Most natural teeth are missing, replaced by prosthetic structures. The X-ray sheet has printed text at the top and bottom, which appears to include a date, patient name, and dossier number. No other anatomical pathologies, such as gross radiolucencies or obvious bone pathology, are clearly visible at this resolution.",
  "dental_observations": {
    "applicable": true,
    "teeth_present": "partial",
    "teeth_condition": [
      {
        "location": "upper_left",
        "observation": "Multiple implants present, supporting a fixed prosthesis. No natural teeth visible in this quadrant.",
        "severity_signal": "none"
      },
      {
        "location": "upper_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 18840 in messages